Remote/Online Microsoft Excel Training Courses

Microsoft Excel Introduction Course

Free up your time and learn Excel well with our one day course providing a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.

Understand and write formula, 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 Tool bar
Enter and edit data
Adjust Column widths
Move and copy data
Use Auto Fill
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 Formula
Learn the construction of a Function
Use the SUM function
Use Auto Fill 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 - Live Online Delivery over 2 x half days (full day option available on request)

Mon 4th October 2021 (Part 1), Tue 5th October 2021 (Part 2) |

Tue 2nd November 2021 (Part 1), Wed 3rd November 2021 (Part 2) |

Wed 1st December 2021 (Part 1), Thu 2nd December 2021 (Part 2)

Dates are not always set in stone, so if you can't make a date above, or you'd prefer your coursed delivered over a full day, please contact us and we'll see what we can do for you.
Group booking rates available on request. We can deliver live online or at your company offices.

Price

£155

Download Course Details

Book this course

Microsoft Excel Intermediate Course

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.

Prerequisite: Before attending this course delegates must have either attended our Introduction to Microsoft Excel training course, or be comfortable 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 IFS Function (Excel 365 version)
Use the SUMIF Function
Apply the COUNTIF Function
Look up data with the VLOOKUP Function
Look up date with the XLOOKUP Function (Excel 365 version)

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 - Live Online over 2 x half days (full day options available on request)

Mon 18th October 2021 (Part 1), Tue 19th October 2021 (Part 2) |

Wed 10th November 2021 (Part 1), Thu 11th November (Part 2) |

Wed 8th December 2021 (Part 1), Thu 9th December 2021 (Part 2)

Dates are not always set in stone, so if you can't make a date above, or you'd prefer your course delivered over a full day, please contact us and we'll see what we can do for you.
Group booking rates available on request. We can deliver live online or at your company offices.

Price

£175

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.

Prerequisite: Before attending this course delegates must have either attended our Intermediate level Excel training course, or be comfortable 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
Work with new functions SWITCH, CONCAT, TEXTJOIN, IFS and XLOOKUP (Excel 365 version)
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 Tool bar
Assign a Macro to a Button
Edit Visual Basic Code
Create Excel Forms

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

Training Dates - Live Online

Tue 26th October 2021 |

Fri 26th November 2021 |

Fri 17th December 2021 |

Dates are not always set in stone, so if you can't make a date above please contact us and we'll see what we can do for you.
Group booking rates available on request. We can deliver live online or at your company offices.

Price

£195

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
Spark-lines
Pivot Tables
Pivot Charts

Training Dates

Contact us for dates and we'll offer something to suit you either live online or at your offices.

Price

£195

Download Course Details

Book this course

Microsoft Excel Power Pivot

This one day training course is for users who have little or no knowledge of Power Pivot 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 Pivot-tables and Pivot-charts. You will feel more confident using Power Pivot and be able to create your own tables and charts from scratch.

Read More

Microsoft Excel Power Pivot course outline

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

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 Power Pivot Intermediate and Advanced training on request.

Training Dates - Live Online

Contact us for dates and we'll offer something to suit you either live online or at your offices.

Price

£295

Download Course Details

Book this course