Download the free course files to follow along
️https://www.simonsezit.com/excel-formulas-bootcamp-instructor-files/

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.

https://www.simonsezit.com/excel-formulas-bootcamp-instructor-files/

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

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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