The following section details the additional topics that are covered in the 2 day Advanced Excel course (as opposed to the 1 day Advanced Excel course).
As well as covering additional topics, attending the 2 day course (as opposed to the 1 day) provides delegates with the opportunity to work their way through more examples & benefit from the extra time to absorb information.

Advanced Functions
§ Index Function
§ Array Function
Organising Workbooks
§ Styles
Data
§ DataBase Functions
Goal Seeking
§ Solver
§ Goal Seeking With Charts
§ What-If
Scenarios
§ Create Scenarios
§ Create Summary Report
§ Merge Scenarios
§ Protect Scenarios
Report Manager
§ Create, Modify, Delete
§ Create Sections (Sheet, View1, Scenario)
§ Add Sections
§ Specify Page Numbering
.jpg)
|