Book now

Excel Advanced Course, Private 1-to-1

Course summary

Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases.

This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

Course Outline

General

  • Editing Standard Formatting Rules
  • Input Validate rules
  • Using Formulas in Conditional Formatting
  • Group and Outline
  • Filter and Sorting

Tables and Advanced Filter

  • Working with tables
  • Copy specific datasets from sheets, workbooks or external data

Consilidate

Goal seek, consolidate and scenarios

Using Form Templates

  • Creating Templates

Advanced Lookup Functions

  • VLookup Function
  • Hlookup Function
  • Using the Index Function, Using the Match Function, Index and Match Together
  • Using the Indirect Function

Advanced Functions

  • Using Error, Logical, Array, Rounding Functions

Advanced Pivot Table Tools

  • Importing Pivot Table Data,
  • Calculated Fields in Pivot Tables,
  • Showing Pivot Data as a Percentage,
  • Creating Custom Pivot Tables Styles
  • Pivot Charts

Macros

  • Creating, amending and deleting macros
  • Running macros
  • Macro menus, toolbars and shortcuts

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 30th Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher