Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Excel Mastery Unleashed: Exclusive Training from Simon Sez IT

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Unlock the power of Microsoft Excel with this comprehensive tutorial video combining ten essential Excel tips and tricks. Master advanced functions like OFFSET, XLookup, and SUMIFS, explore What-if Analysis Scenarios, and learn to compare lists using VLookup. Dive into pivot tables with GETPIVOTDATA, create forecast sheets, and visualize data using 3D Maps. Understand statistical concepts like Standard Deviation and financial calculations using Goal Seek and the PMT function. Perfect for both beginners and intermediate users, this step-by-step guide offers timestamps for easy navigation through each topic, allowing you to tailor your learning experience to your specific needs.

Syllabus

- Using OFFSET in Excel
- What-if Analysis Scenarios
- Compare Two Lists with VLookup
- How to Use XLookup
- SUMIFS
- GETPIVOTDATA
- Using Forecasts Sheets in Excel
- 3D Maps
- Standard Deviation in Excel
- Goadl Seek and the PMT Function

Taught by

Simon Sez IT

Reviews

Start your review of Microsoft Excel Mastery Unleashed: Exclusive Training from Simon Sez IT

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.