Microsoft Excel
Intermediate Training Course

Microsoft Excel Training For Your Team

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Please select the version that you’re interested in

Please select the level that you’re interested in

Microsoft Excel Intermediate Training Course

Course Overview

Audience:

This course is designed for users who have basic knowledge of Excel and want to further enhance their skills. It covers more complex formulae, including 3D formulae, linking data and charting your data and protecting worksheets and workbooks.

Prerequisite:

To get the most from this course, you must be able to perform basic Excel actions and create basic formulae and functions.

Duration:

This is a 1-day Excel Intermediate Course. The course starts at 09:30 and runs until 16:30.
Alternate timings
can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Excel Intermediate course course can be delivered virtually using online training platforms such as MS Teams or Zoom or face-to-face at any preferred location in the UK, Europe or ROW.

Excel Intermediate Course Outline

RECAPPING BASICS

Absolute, Relative References

Basic calculations

BODMAS

Inserting and deleting sheets

Changing the default number of
worksheets

Tracing Precedence and
Dependent

Show Formula

NAMING CELL RANGES

Concept and Purpose

Naming Individual Cells

Naming Range of Cells

Deleting and amending
ranges

Using Name Ranges in Formulae
/Functions

Named Ranges for Navigation

LINKING SHEETS AND FILES

Changing the default number of
workbook sheets

3D Calculations

Linking sheets in the same file

Linking different Excel files

Using Edit Links

VIEWING OPTIONS

Viewing Different Files
on One Screen

Window Split

Freeze Panes

Viewing Different Parts
of the Sheet
on One Screen

Watch Window

CONDITIONAL AND LOOKUP FUNCTIONS

Benefits and Purpose

IF Statements

Nested IF’s

SUMIF, SUMIFS, AVERAGEIF,
AVERAGEIFS, COUNTIF
and COUNTIFS

ISERROR and IFERROR

Nesting IF with AND, OR

Basic VLOOKUP

FINANCIAL FUNCTIONS

PMT, FV, PV

CONDITIONAL FORMATTING

Data Bars

Colour Scales

Icon Sets

Top/Bottom

Clearing Conditional formatting

Editing existing Conditional Formatting

SHARE THE WORKBOOK

Share the workbook to enable

co-author – multiple people

working simultaneously

ESSENTIAL LIST MANAGEMENT

Sorting Data (by Values, by
Cell Colour by Font Colour,
by Cell Icons)

Multi Column Sort

Advanced Filter

Adding Subtotals

Freeze Panes

Group and Outline

Data Form

Format as Table Feature

Data Consolidation

FORMULAE AUDITING

Tracing Precedence and
Dependants

Using Watch Window

Go To Special…

ADVANCED CHARTS TECHNIQUES

Creating Chart using Shortcut
Keys

Saving Custom Chart as
Templates

Setting Chart as Default

Formatting and Editing Series,
Plot Area, Data Points Chart
Area, legends, etc…

Using Sparklines (Line, Column,
Win/Loss)

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.