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)

Tue 9th August 2022 (Part 1), Wed 10th August 2022 (Part 2)

Mon 5th September 2022 (Part 1), Tue 6th September 2022 (Part 2)

Tue 4th October 2022 (Part 1), Wed 5th October 2022 (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)

Thu 11th August 2022 (Part 1), Fri 12th August 2022 (Part 2)

Thu 8th September 2022 (Part 1), Fri 9th September 2022 (Part 2)

Mon 10th October 2022 (Part 1), Tue 11th October 2022 (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 30th August 2022

Wed 28th September 2022

Tue 25th October 2022

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 Advanced Plus

This one day training course is for users who are at Advanced level but want just a bit more! The course can be tailored to requiremenets and our outline is a possible list of objectives you may wish to cover.

Read More

Microsoft Excel Advanced Plus course outline

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

Creating a Pivot Table
Creating a Pivot Chart
Combining Pivot Tables and Charts into one View
Creating Slicers
Creating a Calculated Column

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

Function Work
KPIs
Two way Index
Work with OFFSET
Work with SUMPRODUCT

NOTE: This course is a suggested list of objectives which we can be customised and tailored if requested.

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