Welcome to another Excel tips and tricks tutorial video! We combined ten of our best Excel tutorials into one stepbystep Microsoft Excel training video for beginners. These Excel tips and tricks are ideal for beginners, but also for intermediate Excel users.
Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 Using OFFSET in Excel
00:09:16 Whatif Analysis Scenarios
00:20:23 Compare Two Lists with VLookup
00:35:12 How to Use XLookup
00:49:03 SUMIFS
00:59:47 GETPIVOTDATA
01:09:01 Using Forecasts Sheets in Excel
01:15:27 3D Maps
01:31:38 Standard Deviation in Excel
01:33:43 Goadl Seek and the PMT Function
Get unlimited training with Simon Sez IT’s 160+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssitfirst...
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: / simonsezit
FaceBook: / simonsezit
Subscribe to our channel:
https://www.youtube.com/simonsezittra...
If you enjoyed the video, please give a thumbs up ;)