Microsoft Excel Training Courses

Microsoft Excel Introduction Course

This one day course provides a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.

Understand and write formulae, build common functions, apply formatting, sorting, filtering and generate charts in Excel spreadsheets. You will also learn valuable shortcuts enabling you to work efficiently.

Prerequisite: Delegates wishing to attend our Microsoft Excel Introduction training course should be comfortable with using a computer.

Read More

Microsoft Excel Introduction training course outline

Basics and Formatting
Tour the Microsoft Excel Environment
Customise the Quick Access Toolbar
Enter and edit data
Adjust Column widths
Move and copy data
Use AutoFill
Format a worksheet
Copy and clear formatting
Prepare a worksheet for printing
Save a worksheet as a PDF
Learn keyboard shortcuts

Formulas and Functions
Understand and write Formulae
Learn the construction of a Function
Use the SUM function
Use AutoFill to copy a formula

Further Functions
Use Functions AVERAGE, MIN, MAX and COUNT
Calculate percentages
Learn how to use relative and absolute cell referencing

Work with Data Lists
Use Freeze Panes
Sort data
Filter Information

Charts and Graphs
Create bar, column, line and pie charts
Explore and change chart properties

Training Dates

7th November 2019

2nd December 2019

8th January 2020

11th February 2020

Dates are not always set in stone, so if you can't make a date above, contact us anyway and we'll see what we can do for you.

Price

£155

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Intermediate Course

You've mastered the basics - you can write formulae and apply a function and you're ready to find out more about what Excel can do.

A full day which provides a delegate who has a good basic knowledge of Excel the confidence to use some of the more advanced functions, use Excel as a database (data lists) and summarise data over multiple sheets.

Pre-requisite: Before attending this course delegates must have either attended our Introduction to Microsoft Excel training course, or be confortable with those topics covered at Introduction level.

Read More

Microsoft Excel Intermediate training course outline

Rounding Functions and Named Ranges
Word with Rounding functions
Create Named Ranges
Use Named Ranges with common Functions

Work with Data Lists
Sort multiple columns
Filter Information
Apply Validation Rules
Create Subtotals
Insert and work with Pivot Tables
Apply conditional Formatting

Work with More Advanced Functions
Work with the IF Function
Use the SUMIF Function
Apply the COUNTIF Function
Look up data with the VLOOKUP Function

Multiple Sheets and Protection
Enter data and use Formulas across sheets
Group sheets for Input and formatting
Consolidate data on a summary sheet
Protect a worksheet
Protect cells within a worksheet
Password protect a workbook

Training Dates

21st November2019

9th December 2019

18th December 2019

14th January 2020

20th February 2020

Dates are not always set in stone, so if you can't make a date above, contact us anyway and we'll see what we can do for you.

Price

£175

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Advanced Course

This one day Microsoft Excel Advanced training course is for those with a sound working knowledge of Microsoft Excel. For those delegates who wish to progress to use the most complicated functions and features. At the end of this course you will investigated some of the higher functions of Microsoft Excel.

Pre-requisite: Before attending this course delegates must have either attended our Intermediate level Excel training course, or be confortable with those topics covered at Intermediate level.

Read More

Microsoft Excel Advanced training course outline

Work with and Nest Functions
Nest functions IF with AND / OR, VLOOKUP, VLOOKUP with MATCH and INDEX/MATCH
Apply DATE Functions
Use and nest TEXT Functions
Use Flash Fill
Understand and manage Errors

Advanced Pivot Tables
Grouping data
Work with Filtering and Slicers
Create calculated fields
Adjust field settings
Drill down and refreshing data

What If Analysis Tools
Use Goal Seek
Create Scenarios with Scenario Manager
Create Data Tables

Macros and Excel Forms
Record a Macro
Assign a Macro to the Quick Access Toolbar
Assign a Macro to a Button
Edit Visual Basic Code
Create Excel Forms

Prerequsite: Delegates must have either attended our Microsoft Excel Intermediate training course, or be comfortable with topics covered at our Intermediate level.

Training Dates

27th November 2019

18th December 2019

27th January 2020

27th February 2020

Dates are not always set in stone, so if you can't make a date above, contact us anyway and we'll see what we can do for you.

Price

£195

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Data Lists

This one day training course for those who work with columns of data in lists within Excel, perhaps exported from another application or entered directly into Excel. The aim of this course is to explore Excel features that work well with large sheets of data. Learn the features offered within Excel when working with Data Lists and explore the power of using Pivot Tables.

Read More

Microsoft Excel Data Lists course outline

Setting up and Entering Data
Rules to follow
Using the Data Form
Setting up Data Validation
Freeze Panes

Useful Functions
The IF, AND and OR Functions
Database Functions
VLOOKUP Function
Excel Tables
Flash Fill

Reporting Tools
Sorts and Filters
Conditional Formatting
SubTotals
Sparklines
Pivot Tables
Pivot Charts

Training Dates

15th November 2019

24th January 2020

Dates are not always set in stone, so if you can't make a date above, contact us anyway and we'll see what we can do for you.

Price

£195

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel PowerPivot

This one day training course is for users who have little or no knowledge of PowerPivot in Excel. This course provides you with a working understanding of the basic features. At the end of the course you will have a good working knowledge of how to import data from multiple data sources into a single Excel workbook, create relationships between data, create calculated columns and build PivotTables and PivotCharts. You will feel more confident using PowerPivot and be able to create your own tables and charts from scratch.

Read More

Microsoft Excel PowerPivot course outline

Introduction
PowerPivot Overview
Where do I get PowerPivot from?
Connecting to a Data Source
Pasting Data into PowerPivot

Data Models
Introduction to the Data Model
Combining Data from Two data tables
Combining Data from more than one source
Using the Diagram View
Managing relationships between tables

Analysing Data
Creating a Pivot Table
Creating a Pivot Chart
Combining Pivot Tables and Charts into one View
Creating Slicers
Creating a Calculated Column
Introducing DAX (time permitting)
Basic DAX Expressions (time permitting)

NOTE: We also offer PowerPivot Intermediate and Advanced training on request.

Training Dates

5th November 2019

7th January 2020

Dates are not always set in stone, so if you can't make a date above, contact us anyway and we'll see what we can do for you.

Please contact us for further dates

Price

£295

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course