Browse all IT training courses

Microsoft Excel Advanced

Click here for a PDF version

Introduction

Microsoft Excel is the world's leading Windows spreadsheets, combining worksheet, graphics and database functions with sophisticated presentation facilities. 

Objectives

To consolidate existing knowledge and extend awareness of Excel's advanced features. To understand how to produce data models using tools such as Scenario Manager and Pivot Tables. To take control of data entry by protecting and hiding cells. 

Designed for

Existing users. Participants should have attended our "Microsoft Excel Intermediate" course or attained a similar level of proficiency. 

Duration

One day. 

Topics

  • Review of basic skills
  • File linking
  • Referencing different sheets in the same workbook
  • Referencing external workbook files
  • Functions
  • Lookup functions
  • Logical functions
  • Nested =IF functions
  • Data Consolidation
  • Scenario Manager
  • Solver
  • PivotTables
  • Forecasting
  • Data Validation
  • Security of the worksheet
  • Protecting cells and worksheets
  • Hiding cells and sheets
  • Customising Excel
  • Toolbars
  • Recording Macros

Follow-up

Individual consultancy and tuition as required. 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses