Microsoft Excel Training: Advanced

Description

This course explores some of the more advanced features of Excel and includes a number of methods of performing data analysis.

Pre-Requisites

Delegates should have experience of using Excel, or should have attended either the Excel Introduction or Intermediate courses prior to attending this course.

Course Content

Worksheet Functions

Using the function wizard
Calculate using statistical functions

Logical Functions

If, And and Or functions

Lookup Tables

Using the Lookup function
Calculating with conditional criteria

Goal Seek

Calculating variables based on a fixed result

Data Tables

Extending calculations to include variable elements

Scenarios

Saving scenarios containing different variable elements

Solver

Using variables to arrive at optimal solutions

Pivot Tables

Creating and using pivot tables

Macros

Creating, saving and replaying macros

Format

This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.

Duration

This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.