How to use Formulas and Functions in Microsoft Excel

In this video tutorial, I will show you how to use formulas and functions in Microsoft Excel. I will start with basic math formulas in Excel and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.

0:00 Intro
0:49 Basic math formulas
3:20 Starting with the SUM Function in Excel (with shortcuts)
5:47 The COUNT function
6:29 Take a look at the status bar in Excel
8:10 AVERAGE, MEDIAN and MODE functions
10:05 MIN and MAX functions in Microsoft Excel
10:54 Functions and formulas with Date and time in Excel
14:11 Using formulas to combine columns
16:05 If statements in Excel
19:26 How VLOOKUP works
21:34 Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.)
24:33 How to use the function wizard

[darrelynguinaling]

I just finished watching tutorials 1-4 and you really did a great job making it so easy to follow through. Thank you, sir!

[wandagreer]

I wish I would have had you as a college professor! You are an excellent teacher. Thank you.

[Giul_Ranz]

I am starting to really like Excel and never thought this would happen! I think in the past I was just fearful because I did a short course many years ago, and then never had the opportunity to use Excel much in my job, however a lot of EA jobs now require a very good understanding of excel. I just used SUMIF in a table and it worked! You are such a fantastic teacher. THANK YOU AGAIN!!! :)

[MM-uwlc]

Excellent professor, quick and simple and easy to understand. Thank U!

[michaelren]

I liked your tutorial because it was concise and to the point, not too much self-promotion, which goes on too much on youtube nowadays.

[Da-vinceArt]

Jamie i've been going through your videos on teachers tech, n believe me you, you and the most talented and the best teacher in the whole world for me, your videos are so clear and crisp, so much clarity of information, thank you so very much pls do keep up the good work of uploading videos and education people thanks a million, god speed and god bless you.

[itimwkq]

Thank you! This was so helpful!!! I was scouring the internet trying to get the answer to this, and in just a few minutes you had shown me exactly what I needed! :)

[toeknee]

Thank you for working hard to create this simplified tutorial videos. 💜 I couldnt thank you enough 🙏

[debbiechigozie]

Didn't know learning excel would be this easy. Thank you so much.

[FrancisSneh-qfgt]

Jamie, you are doing a great job. The truth is you have brought the school in my home. Congratulations!

[annelinnane]

Hi Jamie, I just want to say thank you for all your tutorial. I have learnt so much and growing in confidence using Microsoft 365

[kalhussain]

Top class videos, i've watched all 5 of the beginners one's and really reminded myself of the basics!. Will be moving onto the pivot table ones now. Great content and sub'd!

[jamesblood]

THANK YOU SO MUCH! You are truly educating this old man. You are a wonderful teacher.

[limlilian]

Thank you so much sir, I was supposed to go for an interview and had to have an idea on Excel, I watched this video and went and was able to do my interview.🙏

[jimcazador]

I am doing an ECDL at the moment, these videos are much better than the software provided, These videos really help thanks a million.

[bongnwimankaa]

Wow I'm short of words I just finished watching from lecture 1-4 and I most say I learned alot and will keep implementing it may God bless you and replenish u

[jillkraushaar]

This is THE BEST tutorial on excel functions & formulas I've ever watched! helpful! Thanks SO much! :)

[cinamingrl]

Wow I watch these at work during downtime. I really learned a lot so far, thanks very much!

[yulia]

That's an amazing tutorials, so helpful!!!Thank you very much!

[boitumelomaruping]

Love your tutorials. Simple and effective