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.
Campus locations
Study method
- In-class
- Blended
- Online
Locations
- England
- London
- Milton Keynes
- Portsmouth
- Southend-on-Sea

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
- Editing Standard Formatting Rules
- Input Validate Rules
- Using Formulas in Conditional Formatting
- Group and Outline
- Filter and Sorting
- Working With Tables
- Copy Specific Datasets From Sheets, Workbooks or External Data
- Creating Templates
- VLookup Function
- Hlookup Function
- Using the Index Function, Using the Match Function, Index and Match Together
- Using the Indirect Function
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.