Microsoft Excel Advanced Fast Track - 1 Day

Course Overview

Microsoft Excel Advanced Fast Track - 1 Day

Understand where to use and how to create useful functions and how to analyse data with pivot tables. 

Course Content

Practical Functions 

Statistical functions (COUNTIF and SUMIF) 

Logical functions (IF, AND and OR) 

Lookup and reference functions (VLOOKUP and HLOOKUP) 

Text functions 

Data Validation  

Validating text, values, dates and lists 

Validation input messages 

Error message alerts

Locating invalid data 

Introducing Pivot Tables 

Creating a pivot table 

Drilling down on pivot data  

Sorting, grouping and filtering pivot data 

Summarise value fields 
 
Automating Spreadsheets with Macros 

Recording and running macros 

Deleting a macro 

Macro virus protection