Training Courses

Call us on 01324 719698 or Fax 01324 719942

Course Description

This is a one day course designed for delegates who are experienced users of Microsoft Excel and want to make use of the advanced tools available and build automated spreadsheets.

The topics below represent a suggested course content. However, these can be adapted to meet specific objectives.

Course Contents

• Data Lists

The Excel database facilities will be demonstrated including sorting, extracting data using auto and advanced filters, and subtotals.

• Grouping and Outlining

The concept of grouping and outlining Rows and Columns will be looked at and demonstrated.

• Data Analysis Tools

The use of Excel’s Pivot Tables, Goal Seek and Scenario Manager features will be taught.

• Macros
  Recording and running Excel macros to create ‘shortcuts’ for frequently used tasks will be explained and demonstrated