Microsoft Office Excel – Intermediate
1 Day Duration
Overview
This intermediate course is aimed at users who have a comfortable working knowledge of Microsoft Office Excel and wish to gain skills in some of the features within Excel that can enhance spreadsheets. The course is hands on and delegates will update and create intelligent formulae and efficient spreadsheets.
Working with lists in Excel
Rules for working with lists
Formula autofill
Sorting within lists
Filters in lists
Subtotalling lists
Intermediate Functions
Naming cells and ranges within functions
IF function and nesting IF’s
SUMIF
COUNTIF
LOOKUP
DATE
TODAY
Analysing Data
Pivot tables and pivot chart reports
Filtering within Pivot Tables
Formatting Pivot Tables
SUM, AVERAGE and COUNT features
Grouping dates within Pivot Tables
Drilling down within Pivot Tables
Linking Data within Excel
2D and 3D referencing
File linking
Paste special
Hyperlinks within Excel
Text
Web pages
Images
Further Excel Features
Conditional formatting
Data validation
Comments within spreadsheets