Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE)

✅ Download the free course files to follow along
➡️ https://www.simonsezit.com/article/ad...

In this 1-hour, recorded webinar, Excel expert Deb Ashby takes you through a host of incredibly useful Advanced Excel formulas and functions.

📝 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 - Introduction
0:05:07 - Logical Functions in Excel (IF, IFS, AND, OR)
0:17:00 - Two-way Lookups in Excel (INDEX, MATCH)
0:21:29 - Assigning Random Values in Excel (CHOOSE, RANDBETWEEN)
0:25:23 - Finding the Most Recent Occurrence (INDEX, MATCH, MODE, SUMPRODUCT)
0:30:48 - Looking up Values (XLOOKUP)
0:40:32 - Extracting Text Strings (LEFT, RIGHT, LEN, FIND)
0:46:09 - Sum and Count with Multiple Criteria (SUMIFS, COUNTIFS)
0:52:59 - Dynamic SUM Calculations (SUM, OFFSET, MATCH)

🌍 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...

💻 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:   / simon-sez-it  
FaceBook:   / simonsezit  

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

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