Advanced Excel Course:
Our advanced Excel Public Course is a one day instructor-led intensive course that will focus on the advanced functions and features that allow you manipulate data. This includes functions like VLOOKUP, INDEX, MATCH , OFFSET , COUNTIFS and SUMIFS.
Great emphasis is placed on mastering Pivot tables to analyze your data..
This course covers 2010 , 2013 & 2016 Excel versions.
We realize that there is an awful lot to take in when doing a one day advanced Excel course, so we, uniquely give every student access to our online course as well . This is great not just for revising but also for further study as our online course covers all levels of Excel.
See full syllabus below
What Excel Level am I ?
What will the course do for me ?
In the video below watch a trained and untrained Excel user tackling common Excel tasks. Notice the huge difference in time and effort and please note this video only covers intermediate Excel skills not somebody with advanced Excel Skills.
CPD Certified Course
This course is CPD certified
by the CPD Standards office
Upcoming Advanced Excel Courses
Level 3 Course Dates:
- Thursday 19th April
- Thursday 17th May
- Thursday 21st June
- Thursday 26th July
- Thursday 23th August
Course Syllabus: Advanced Excel Course:
- VLOOKUP + Helper columns,
- INDEX and MATCH
- SUMIF & SUMIFS
- COUNTIF & COUNTIFS,
- OFFSET & INDIRECT FunctionsCase studies:
We will look at real life examples and models using these techniques.
- IF and nested IF Functions
- AND, OR, NOT Functions
Text and Date Functions with examples of combining Text functions.
- Advanced Filters
- Using List Features
- Dynamic Lists
- The new Sumifs and Countifs Functions
- Using the Pivot Table Wizard
- Changing the pivot table layout
- Grouping items
- Inserting calculated fields
- Pivot Table Options
- Display and hide data in fields
- Lay out reports directly on worksheet
- Pivot Charts
- Pivot Tables Slicers
- 20 Pivot Tables Recipes for powerful reports
- Pivot Tables Macros
- Creatng Independent Pivot table
- Custom Views
- Goal Seek
- Data Tables
- Purpose of Macros
- Recording macros
- Where to save macros
- Absolute and relative record
- Running macros:
- Custom buttons, menu items, keyboard shortcuts
Case Studies: Examination of Macros to save time and automate your work.