Microsoft Excel

Microsoft Excel Training

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 level that you’re interested in

Microsoft Excel 2013 Intermediate

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 can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Excel 2013 Intermediate Course Outline

RECAPPING BASICS

Absolute, Relative References

Basic calculations Recap (BODMAS)

Inserting and deleting sheets

Changing the default number of worksheets

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 aid

LINKING SHEETS AND FILES

3D Calculations

Linking sheets in the same file

Linking different Excel files

Using Edit Links

VIEWS

Viewing Different Files on One Screen

Window Split

Freeze Panes

Viewing Different Parts of the Sheet on One Screen

Watch Window

CONDITIONAL FUNCTIONS

Benefits and Purpose

IF Statements

AND, OR

SUMIF and SUMIFS

AVERAGEIF and AVERAGEIFS

COUNTIF and COUNTIFS

ISERROR and IFERROR

Nesting IF with AND, OR

ESSENTIAL LIST MANAGEMENT

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

Multi Column Sort

Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)

Multi Column Filter

Advanced Filter

Adding Subtotals

Group and Outline

Data Form

Format As Table Feature

Data Consolidation

CREATING TABLES

What is a table?

Why use a table?

Creating a table

Table Tab

Naming a table

Formatting a table

Removing an existing table

WORKING WITH TABLES

Resizing a table

Adding and removing columns

Total Rows and Inbuilt calculations

Frozen first row

Filtering

Pros and Cons

CALCULATIONS IN TABLES

Understanding table references

Basic calculations that auto update

BUilding a calculation in a table

SUMIF, COUNTIF without absolute references

Tables and VLOOKUP’s

Naming part of a table

APPLYING AND MANAGING CONDITIONAL FORMATTING

Data Bars

Colour Scales

Icon Sets

Top/Bottom Basic

Clearing Conditional Formatting

Copying Conditional Formatting to other cells and sheets

LOOKUP FUNCTIONS

Vertical Lookup (VLOOKUP)

Horizontal Lookup (HLOOKUP)

FORMULAE AUDITING

Formula View

Tracing Precedents

Tracing Dependents

Using Watch Window

Go To Special…

CHARTS/GRAPHS ADVANCED TECHNIQUES

Creating Chart Using Shortcut Key

Saving Custom Chart as Templates

Setting Chart as Default

Applying Trendlines

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.