Excel Advanced

Date: December 9, 2019
Time: 09:30 to 16:00
Venue: Kings Hill
Package: Excel

Email to book this course


Delegates should be confident in working with the Windows environment.  A very sound background of designing Excel spreadsheets through attendance of the Microsoft Excel Introduction and Intermediate courses or equivalent experience is essential.

Course Objectives

  • To create powerful spreadsheets through the use of advanced functions
  • To analyse data held as a database
  • To summarise large amounts of data

Course Contents

Naming Cells

  • The Name Box
  • Name Manager
  • Define Name
  • Using Names in Formula
  • Create names from selection

Advanced Functions

  • Date and Time
  • Logical (Nested and Multiple IF)
  • Lookup Tables
  • Text Functions
  • Data Validation

Database Features

  • Advanced Filters
  • Database Functions
  • Subtotals
  • Pivot Tables

Importing and Exporting

  • Importing Text Files


  • Creating Macros
  • Assigning a Macro to a Button
  • Running a Macro from Shortcut Keys