Excel Formulas for Beginners - 1+ Hour Class!

✅ Download the free course files to follow along

Formulas and Functions are the cornerstones of Excel. It enables you to perform calculations from as simple as finding totals to as complex as creating financial models.

This 1-hour Webinar will teach you what formulas and functions are and how calculations in Excel work, including the BODMAS rule.

We start from the basics such as SUM, AVERAGE, MIN, MAX, and COUNT, and then move on to more advanced formulas like VLOOKUP, UNIQUE, CONCAT, IF and nested IF, and other Text Functions. You will also learn how to use Autofill and Excel Named Ranges as well as Absolute vs Relative Referencing. We also show you how to do Error Checking on formulas and some useful keyboard shortcuts, tips, and tricks.

We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master MS Excel.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Agenda
0:02:46 - What are formulas and functions
0:05:10 - Using SUM, Autosums, and Autofill
0:13:42 - Understanding Excel Operators and the BODMAS rule
0:17:59 - Using Average, MIN, MAX, COUNT and COUNTA
0:26:32 - Absolute vs. Relative Referencing
0:32:59 - Using Named Ranges in Formulas
0:39:26 - Text Functions
0:59:41 - VLOOKUP

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[Nadia-dixw]

I just started the class and have learned more in 15 min than I have in weeks of trying to gain a understanding of formulas. Thank you so much for your teaching skills. I am amazed.

[savitan]

your videos are super useful so refreshing to see how excel has changed

[SiminLotfjou-em]

I really enjoy Deb tutorials. Thank you so much❤

[sonyalangeveld]

Really clear and easy to understand. Thanks

[arsraza]

thanks to you a lot. yours current and previous tutorials helping me a lot to book a job. i hope you shall post more premium videos.

[clareswahn]

really clear, it's a great revision tool for me. thank you

[shafialanower]

Thank you for sharing quality content. You guys are amazing 🙏

[suuufim]

Thank you so much, this was so helpful

[SimonSezIT]

If the link doesn't work, please try another web browser or try clearing your browser cache.

🔥Check out our FREE 300+ hour training course playlist here 👉

[Lyriks_]

O-M-G MARY ME DEB ASHBY, just what i was looking for, thank you so much ✌

[giannowaller]

Very useful but...where is the yellow circle around the pointer. Was at times difficult to follow, needed to go look for the pointer first.

[shainayang]

Y'all should do smartsheet next 👀🙏