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

Video Description

✅ 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 👍🏽 ;-)