Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE). and this video is uploaded by Simon Sez IT at 2021-02-10T08:00:06-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [7cHwPFutzbQ]
| Name | Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE) |
| Video Uploader | Video From Simon Sez IT |
| Upload Date | This Video Uploaded At 10-02-2021 16:00:06 |
| Video Discription | ✅ 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 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-month-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 👍🏽 ;-) [7cHwPFutzbQ] |
| Category | Science & Technology |
| Tags | excel tips and tricks | excel for analysts | advanced excel | excel formulas | excel advanced formulas | learn excel formulas | advanced excel tricks | advanced formulas in excel | excel | microsoft excel | excel tutorial | excel tips | excel formulas and functions | excel tips and tricks 2019 | excel online course | excel tricks 2019 | excel advanced | learn excel | excel functions |
