Excel Formulas for Beginners - 1+ Hour Class!

✅ Download the free course files to follow along
➡️www.simonsezit.com/excel-form...
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.
✅www.simonsezit.com/excel-form...
📝 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 ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
th-cam.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@Nadia-di4xw]

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.

[@SimonSezIT]

Great to hear!

[@savitan6027]

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

[@arsraza354]

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.

[@SimonSezIT]

Thanks, we will!

[@sonyalangeveld5731]

Really clear and easy to understand. Thanks

[@SimonSezIT]

Glad it was helpful!

[@SimonSezIT]

✅Download the Free Instructor Files to follow along the course here ►www.simonsezit.com/excel-formulas-bootcamp-instructor-files/
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 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
& here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html

[@clareswahn106]

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

[@SimonSezIT]

Glad it was helpful!

[@marinadanilina3275]

Excellent tutorial!

[@SimonSezIT]

Glad you liked it!

[@user-su3uu5fi7m]

Thank you so much, this was so helpful

[@SimonSezIT]

Glad it was helpful!

[@shafialanower3820]

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

[@SimonSezIT]

Glad you enjoy it!

[@Lyriks_]

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

[@SimonSezIT]

You are so welcome

[@giannowaller7664]

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.

[@sangayjamtsho2487]

Can I use in my excel2016

[@shainayang4917]

Y'all should do smartsheet next 👀🙏

[@SimonSezIT]

Smartsheet, nice idea. We'll look into it!

[@ramug2988]

Tooo much advertisement 😅

[@lesleykeddy5612]

that's what we have to put up with for a totally free tutorial. I am an Excel trainer and Deb offers the best Excel tutorials I've seen. You can either Skip Ads or become a paid subscriber otherwise it is the only way these can be made free to us

[@giannowaller7664]

Pay for premium. Its much cheaper than actually paying for all the free training they giving us. You cant have everything for free