Learn AI, Data Science & Business — Earn Certificates That Get You Hired
AI Engineer - Learn how to integrate AI into software applications
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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