✅ Download the free course files to follow along
➡️ https://www.simonsezit.com/article/advanced-formulas-in-excel-1-hour-recorded-webinar/
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 200+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-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 👍🏽 ;-)