The Most Addictive Python and SQL Courses
Google AI Professional Certificate - Learn AI Skills That Get You Hired
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