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 30th Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Mon 30th Oct
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Thu 02nd Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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