Advanced Excel Topics

1. Advanced Excel Formulas

Get FREE Advanced Excel Exercises with Solutions!

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

 

What is ExcelDemy?

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

Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo