Excel

EXCEL ADVANCED - one DAY

Microsoft Office Excel training the way you need it, when you need it.

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


Click here to download this course outline.