Menu
  1. Home
  2. Microsoft
  3. Excel
  4. Short
  5. Excel Advanced Course, Private 1-to-1
Enquire Now

Excel Advanced Course, Private 1-to-1

Study Method
In-class
Locations
London, Milton Keynes, Portsmouth, Southend-on-Sea
Institution
PCWorkshops
Start Date
Multiple start dates available

Course overview

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.

Expand all and read more

Campus locations

Study method

  • In-class
  • Black Friday
  • Blended
  • Online

Locations

  • England
    • London
    • Milton Keynes
    • Portsmouth
    • Southend-on-Sea
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • Excel Advanced course certificate on completion (assessment based)
  • Excel Advanced course notes
  • Practical Excel Advanced course exercises, Excel Advanced course homework/Excel Advanced course revision work
  • To assist after the course, 1 free session for questions online Excel Advanced course via Skype/Teamviewer

Subjects

Core Units
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
Consolidate
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
And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £290

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.