Advanced Excel Topics

1. Advanced Excel Formulas

Get FREE Advanced Excel Exercises with Solutions!





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


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


What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Kawser Ahmed
Kawser Ahmed

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only a how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can check out my courses at Udemy:

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF