TRAINING

Enroll Now

MICROSOFT ADVANCED EXCEL – COURSE CONTENT Training

1. Advanced Functions

1. IF Function & Nested IF Statements
2. And & Or Functions
3. Lookup Functions (Horizontal And Vertical Lookup)
4. Index Function
5. Array Function
6. Subtotals
7. Conditional Formatting

2. Pivot Tables

1. Create Pivot Table
2. Work With Row / Column Fields
3. Data Fields
4. Customize Table Display

3. Organising Workbooks

1. Creating Templates
2. Styles
3. Protect Ranges & Worksheets

4. Data

1. Enter & Records Using The Input Form
2. Sort Data Into Lists
3. Filter Data – Auto Filter, Advanced Filter
4. Database Functions
5. Validation Rules

5. Goal Seeking

1. Solver
2. Goal Seeking With Charts
3. What-If

6. Scenarios

1. Create Scenarios
2. Create Summary Report
3. Merge Scenarios
4. Protect Scenarios

7. Macros

1. Create Macros – Record & Modify- the VBA Code Generals
2. Relative Referencing
3. Assign To Toolbars / Keyboard

8. Outlines

1. Group Row / Column Data To Create Outline Levels Based On Worksheet Formulae
2. Display Summary Rows and Summary Styles

9. Custom Views

1. Create, Modify
2. Include Hidden Rows, Columns, Filter Settings

10. Report Manager

1. Create, Modify
2. Add Sections
3. Specify Page Numbering