Excel Intermediate Course

 

​

Duration

One Day

 

Course Description

This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter and sort data, summarise database lists, format and modify charts, and conditionally format cells.

 

Course Pre-requisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Intermediate course.

​

​

Course Contents

Multiple Worksheets

• Work with multiple worksheets

• Calculate across multiple sheets

​

Absolute Cell References

• When to use absolute and relative cell references

​

Sort and Filter Data

• Sort single and multiple columns

• Sort a column by fill colour

• Create a custom sort

• Filter single and multiple columns

• Filter for different criteria

• Use advanced filter

 

Work with Large Worksheets

• Freeze panes

• Print headings on every page

• Print area

 

Functions

• Logical Functions – IF, VLookup

• Statistical Functions - Max, Min, Average, Count

 

Charts

• Create and edit types of charts

• Use different formats

• Add different chart elements

 

Create a Table

• Convert data into a table

• Use different formats

• Use table options

• Slice a table

 

Create a PivotTable

• Analyse data by creating a PivotTable

• Manipulate data

• Format

• Slicers

• Chart

 

Import Data

• Import from an external source

​

​

Follow on course:  Excel Advanced - Read more