Advanced Excel Topics
Advanced Excel Topics
Advanced Excel Topics
1. Advanced Excel Formulas
SUMIFS
SUMPRODUCT
VLOOKUP & XLOOKUP
INDEX + MATCH
Handling Excel Formula Errors
Dynamic Array Formulas
Handling Circular References
Audit Excel Formula
2. Using Structural References
Using Formulas with Excel Tables
Excel Table Advanced Tips
3. Conditional Formatting
4. Advanced Excel Charting
Interactive Charts in Excel
Sparklines
5. Pivot Tables and Reporting
Pivot Table with Multi Table
Slicers and Timelines
Pivots for Large Datasets
Report Filters
Advanced Pivot Table Skills
6. Excel Macros and VBA
7. Keyboard Shortcuts
8. Data Tables in Excel
9. Solver in Excel
10. Simulations in Excel
11. Forecasting in Excel
12. Trend Analysis
13. Scenario Analysis in Excel
14. Using Excel with other Tools and Optimizing Excel’s Power
Combining Excel Files with Power Query
Making PPT slides from Excel
Consolidating Multiple Workbooks
Using Web APIs in Excel
Sending Emails from Excel
Creating MS Word Reports from Excel