Advanced Excel Live Course : Course Content
Session 01
1. Introduction to Advanced Excel
2. Useful Excel shortcuts and tricks
Session 02
1. Advanced Excel Formula 01
Session 03
1. Advanced Excel Formula 02
Session 04
1. Advanced Excel Formula 03
Session 05
1. Data Grouping & Subtotal
2. Text to columns & Cell Combination
3. GO TO commands, Space Filing
4. Conditional Formatting
5. Advanced Filtering
Session 06
1. Sparklines, Hyperlink, Format Tables, Data Validation
Session 07
1. Pivot Tables, Pivot Charts, Slicers
2. Datasheet protection
Session 08
1. Solver, Goal Seek
2. Scenario Manager
3. Data Table
4. Working with AI
Session 09
1. New Formulas - O365
2. Data Types, Geography, Forecast sheet, Map
Session 10
1. Developing complex Excel Modules
Session 11
1. Preparing Advanced Dashboards
Session 12
1. Developer Tab
2. Macro, VBA Coding, Form Controls
Comments