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