Excel Advanced Course

Excel Advanced Course

Course FAQ's - Contact Us for your Bespoke Excel Course - What's Included

Book now

From £250

Choose your date for London and book here
Choose your date for Milton Keynes and book here
Choose your date for Southend-on-Sea and book here
Choose your date for Portsmouth and book here
Choose your date for Manchester and book here

Microsoft Excel Advanced Course, Private 1-to-1, PC and Mac Versions 2007 upwards

Excel 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.

Excel Course Outline

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
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

What is included:

Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.

Other Excel Courses

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.