✅ Download the free course demo files to follow along
➡ https://www.simonsezit.com/excelform...

In this training video, we've combined some of our best Excel formulas and functions tutorials to take you from beginner to expert in under 3 hours! We've split this tutorial into 3 topics to make learning easier.

We start with logical functions in Excel, looking at the IF, IFS, COUNTIF, and SUMIF functions. Following that are the lookup functions in Excel, such as VLOOKUP, HLOOKUP, INDEX MATCH, and more. And finally, we walk you through dynamic arrays in Excel. Dynamic arrays allow you to work with multiple values simultaneously in a formula.

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 Excel formulas.

✅ https://www.simonsezit.com/excelform...

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

00:00:00 Logical Functions
00:45:17 Lookup Functions
01:39:44 Dynamic Array

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

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

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ➡
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for Excel beginners    • Microsoft Excel Beginner's Training T...  

✅ Excel 2021 Tutorials for Intermediate Users here    • Excel 2021 Tutorials for Intermediate...  

✅ Microsoft Excel Tips and Tricks    • Microsoft Excel Tips and Tricks  

✅ Microsoft Office 2021 and Office 365 Training here    • Microsoft Office 2021 and Office 365 ...  

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simonsezit  
FaceBook:   / simonsezit  

Subscribe to our channel:
https://www.youtube.com/simonsezittra...

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