It looks like you're using IE11...
This browser offers limited functionality on our website. We recommend you use the latest version of Chrome, Safari, Edge and Firefox.
Two days: 9.30am - 4.30pm on both days
The Advanced Excel course introduces many of the more advanced tools available in Microsoft Excel. It has been designed for users who are proficient in the functionality of Microsoft Excel to help them realise the full potential of the spreadsheet tool.
The Course covers various new topics including the use of sub totals, data tables, charting, linking multiple worksheets and pivot tables. It also covers many of the functions available within Excel.
Attendance at an Intermediate Excel course or extensive knowledge of Excel.
|Exercise 1||Date and time functions|
|Exercise 3||Statistical functions
|Exercise 4||Text functions
Lookup functions - vlookup
|Exercise 6b||Lookup functions - hlookup|
|Exercise 11a||Advanced filters|
|Exercise 11b||Using functions with filtered lists
|Exercise 12||Naming cells|
|Exercise 13||Conditional formatting|
|Exercise 14||Applying autoformats|
|Exercise 15||Hiding rows, columns, worksheets|
|Exercise 16||Formatting cells|
|Exercise 17||Importing text files|
|Exercise 18||Sub totals|
|Exercise 19a||Data input tables|
|Exercise 19b||More data input tables|
|Exercise 20a||Spreadsheet protection|
|Exercise 20b||Cell protection|
|Exercise 21||Custom sorts|
|Exercise 22||Linking cells between Excel worksheets|
|Exercise 23b||Linking worksheets - 3d reference|
|Exercise 24||Linking your Excel spreadsheet to Word|
|Exercise 25||Using hyperlinks in excel|
|Exercise 26||Paste special|
|Exercise 28||Creating charts|
|Exercise 29b||Adding data to charts|
|Exercise 30b||Combined chart type|
|Exercise 31||Formatting chart axis|
|Exercise 32||Pivot tables|
|Exercise 35||Adding a comment to a cell|
|Exercise 38||Freezing panes|
|Exercise 39||Split window in Excel|
||Track changes in Excel
|Exercise 40b||Change track changes display view|
||Remove track changes|
|Exercise 41||Compare and merge spreadsheets|
After completing this course you will be able to:
You will complete all of these using Microsoft Excel.
External attendees: £170 plus VAT per candidate.