Excel advanced

Short course

In Abingdon

£ 165 + VAT

Description

  • Type

    Short course

  • Location

    Abingdon

  • Duration

    1 Day

This course is to give the user the advanced principles of using Excel 2007. Can be preceded by the two one day courses entitled Excel 2007 Foundation and Excel 2007 Intermediate.

Facilities

Location

Start date

Abingdon (Oxfordshire)
Milton Hill, OX13 6AB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course outline
Working with Lists
Sort data; Query from a list; List functionality; Extract data; Use filters; Use data validation; Use conditional formatting; Perform multi-level sorts; Database functions.
Analysing Data
Consolidate multiple lists; Use Goal Seek and Scenarios.
Auditing Worksheets
Check and review data; Find cells that are referred to in a specific formula; Find formulas that refer to a specific cell; Find errors.
Customising Reports
Use PivotTables; PivotChart reports.
Importing and Exporting Data
Import from other applications; Export to other applications.
Templates
Work with existing templates; Create templates; Edit templates.
Macros
Create and modify simple macros.

Excel advanced

£ 165 + VAT