25,000+ Courses Nationwide
0345 4506120

Microsoft Excel Advanced - One-to-One Training

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.

Select specific date to see price, venue and full details.

Learning Objectives

WHAT IS INCLUDED IN THE EXCEL COURSES:
  • Excel Course Certificate on completion
  • Excel Course notes
  • Practical Excel Course exercises, Excel Course Homework / Excel SQL Revision work

Course Content

General
Editing Standard Formatting Rules
Input Validate rules
Using Formulas in Conditional Formatting
Group and Outline
Filter and Sorting
Excel Tables and Advanced Filter
Working with Excel tables
Copy specific datasets from sheets, workbooks or external data
Consilidate
Goal seek, consolidate and scenarios
Using Form Templates
Creating Templates
Advanced Excel Lookup Functions
VLookup Function
Hlookup Function
Using the Index Function, Using the Match Function, Index and Match Together
Using the Indirect Function
Excel Advanced Functions
Using Error, Logical, Array, Rounding Functions
Advanced Excel 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
Excel Macros
Creating, amending and deleting macros
Running macros
Macro menus, toolbars and shortcuts

Exams & Certification

  • Excel Course Certificate on completion

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best