1 Day Course | 1 delegate £225.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information.
This one-day instructor led course is designed to develop the practical skills of Excel users. By the end of the course delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.
Use advanced formulas and functions
Define names for individual cells and ranges
Use the database tools in Excel
Work effectively with large spreadsheets
This course is designed for delegates who have completed the Excel Level 1 course or have equivalent knowledge. Delegates should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT and also be aware of the difference between relative and absolute references.
VLOOKUP and HLOOKUP
Function to combine data from multiple cells
Naming cells and ranges
Linking applications (Excel with Word or PowerPoint)
Sorting data – ascending, descending, left to right
Sorting data in custom sequences
Filtering data with AutoFilter
Creating customised and advanced filters
Using data forms to enter, delete and search for data