Microsoft Excel Fundamentals and Advanced Skills

Get to grips with Excel

Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information. This course can run on Excel 2010, 2013 or 2016 and has more bells and whistles than any version before it, and can be daunting for a novice user.

There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you.

Course Code
2 Days
Delivery Style
Course Type
Private Only
Max Delegates
Available as Nutshell

Book your virtual training

  • Date
  • Venue
  • Cost
  • More info
Purpose of this course

This course will introduce you to Excel and give you the skills to use the program every day as well as the knowledge of advanced functions and features.

Who is this course for

Anyone that manages, stores or looks at data as part of their role.

You will learn how to
  • Create and customise workbooks in Excel 2010, 2013 or 2016
  • Use Excel as a day to day user
  • Present data graphically
  • Create Pivot tables and graphs
  • Use Excel functions and formulae for mathematical processes and automation
  • Program Excel 2010, 2013 or 2016 using Visual Basic
Benefits for your organisation

This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.

Benefits for you as an individual

An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.

Welcome to Excel

Workbooks and Worksheets
File Types
Spreadsheet Navigation

Excel Interface

The Quick Access Toolbar
Excel Ribbon
Overview of Tabs
Command Groups

Excel Basics

Autosum and Autofill
Introduction to Formulae

Workbook Formatting

Modification of Cells and Cell Data
Styles and Borders
Chart Creation and Modification
Cell Referencing

Functions and Formulae

Mathematical Operators
Error Checking
Nested Functions
Array Formulae


Creation and Formatting
Sort and Filter
Excel as a Database

Data as a Graphic

Add and Edit Shapes

Advanced Data Management

Automatic Grouping, Outlining and Subtotalling
Scenario Manager
Data Analysis Tools

Pivot Tables

Creation and Formatting of Pivot Tables
External Data

Pivot Charts

Creation and Formatting of Pivot Charts
Advanced Tasks

Advanced Excel Tasks

Advanced Functions
Logical Functions

Excel Programming

Keyboard Shortcuts
Visual Basic


There are no prerequisites for this course though a basic knowledge of Microsoft Office would be advantageous.