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