Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features. Working knowledge of Excel or our Excel Intermediate course.
Benefits
- At the end of the Excel Advanced course you will have a complete understanding of the higher functions of Excel.
- You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
Duration & Cost
Hours per Week | 3 Months | 6 Months | 9 Months | 11 Months | 12 Months |
---|---|---|---|---|---|
15 | £1,800 | £3,000 | £4,000 | £4,720 | £4,900 |
9 | £1,500 | £2,500 | £3,300 | £3,900 | £4,050 |
6 | £1,190 | £2,030 | £2,750 | £3,350 | £3,500 |
4 | £860 | £1,460 | £1,940 | £2,360 | £2,465 |
Full time classes are 15 hours per week or more
Excel Advanced Course Syllabus
-
Using logical functions
Naming ranges
- Creating named ranges
- Using named ranges in formulasThe IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions -
Working with lookups
The VLOOKUP function
The HLOOKUP function -
Advanced list management
Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown listUsing database functions
- Setting up criteria
- DSUM
- DAVERAGE
- DCOUNT - PivotTables and PivotCharts
Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables
- Using analytical options
Using Goal Seek
Using the Solver add-in
Working with scenarios
- Creating and saving scenarios
- Viewing scenarios
- Macros
Creating macros
Using the macro recorder
Viewing and editing macro VBA code