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. Data sheet protection


Session  08

1. Solver, Goal Seek

2. Scenario Manager

3. Data Table


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

Advanced Excel :: Introduction Seminar

Comments

There are no comments yet