Excel - Adv (Differences Between 1 and 2 Day Adv Courses)

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 and Modify
• Create Sections (Sheet, View1, Scenario)
• Add Sections
• Specify Page Numbering

Click here to download:

Excel Adv (Differences Between 1 & 2 Day Course)