Advanced Excel Course Overview

This comprehensive Advanced Excel course will teach you the powerful Excel functions, formulas, data analysis techniques, and advanced tools used by professionals to analyze and visualize complex datasets.

Learn the following key aspects of Excel through hands-on projects and detailed lessons:

• Basic Excel Revision , Shortcut keys
• Working with formulas(Logical,Statistical,Text,Date,Math,Financial etc)
• Lookup and reference formulas and adv lookup formulas
• Advanced Formulas and Functions
• Statistical data analysis
• Sorning, Filter,Adv Filter, Subtotalling etc
• What if analysis
• Complex Data Analysis Techniques
• Working with Multiple Worksheets
• Data Visualization
• Using PivotTables and PivotCharts
• Data Validation and Conditional Formatting
• Working with External Data Sources
• Automating Excel with Macros and VBA
• Excel for Financial Modelling and Forecasting
• Advanced Excel Project