Microsoft Excel Intermediate

Calculations and Named Ranges
Brief review of common functions and formulae
Calculate and format dates
Create Named Ranges
Use Named Ranges with Functions

Work with Data Lists
Sort multiple columns
Filter Information
Apply Validation Rules
Create Subtotals
Insert and work with Pivot Tables
Apply conditional Formatting
Work with More Advanced Functions
Work with the IF Function
Use the SUMIF Function
Apply the COUNTIF Function
Look up data with the VLOOKUP Function

Multiple Sheets and Protection
Enter data and use Formulas across sheets
Group sheets for Input and formatting
Consolidate data on a summary sheet
Protect a worksheet
Protect cells within a worksheet
Password protect a workbook

Any user who is competent at writing basic formulas and functions within Excel but who would like to expand their knowledge.

Must be comfortable with Excel Introduction course objectives before attending.

Certificate of training

Engaging delivery live online by qualified trainers
A maximum of 4 delegates on a public course
1 year's after course support included
We post your course materials to you

Post out your course materials and email a link to join the course on enrollment