Рет қаралды 72,034
✅ Download the free course files to follow along
➡️ 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 ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 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 Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)