• Microsoft Partner
    -
    Learn with experts
  • CPD Certified
    -
    Validated by specialists
  • Rated Outstanding
    -
    11 years in a row
  • Moneyback Guarantee
    -
    100% Peace of mind

Our Excel Courses

1 Day Introduction Excel Training Course: CPD Accredited

Introduction Excel Course

CPD Certified
4.8 / 5
1 day.
Client Site Courses Available.
Online, London & Guildford.

For complete beginners, this CPD certified course covers all the basics of Excel in one day.

  • Navigating Excel & workbooks
  • Inputting data & using dates
  • Cell referencing & formulas
  • Using fonts, colours & borders
  • Printing & formatting your sheet
  • Linking your data together

Overview

For complete beginners, this CPD certified course covers all the basics of Excel in one day.

  • Navigating Excel & workbooks

  • Inputting data & using dates

  • Cell referencing & formulas

  • Using fonts, colours & borders

  • Printing & formatting your sheet

  • Linking your data together

Full Syllabus

  • Starting Excel in Microsoft Office 365 and how it works
  • Using the Ribbon and the backstage view
  • Using shortcut menus and the Quick Access Toolbar (QAT)
  • Understanding and launching dialogue boxes
  • Opening, saving and printing workbooks
  • Inputting text, numbers and dates
  • Working with ranges
  • Using range calculations
  • Editing and overwriting data and formulas
  • Using Undo and Redo
  • Sharing and saving workbooks on a network and via OneDrive
  • Using and managing track changes
  • Using, editing and deleting worksheet comments
  • Basic and advanced data filling
  • Basic Excel formulas and troubleshooting issues
  • Controlling fonts including size, colour, background and underlining
  • Formatting numbers including dates, currencies and times
  • Applying, removing and drawing borders
  • Controlling your worksheet view including the ruler and formula bar
  • Inserting and deleting cells, rows and columns
  • Working with multiple worksheets
  • Basic and advanced print options
    • Using margins and setting a print area
    • Alignment and backgrounds
    • Using rows as repeating print titles
    • Fitting worksheets to a specific number of pages

Am I Ready?

This course is designed for people who haven’t used Microsoft Excel before.

It focuses on foundational Excel skills like data entry, formatting, basic formulas, and navigating the Excel interface.

If you’re not sure, our Excel course level adviser takes less than 60 seconds to complete.

Alternatively, give us a call, we’d be delighted to help.

Instructor

Lucinda is one of our regular trainers for our introduction to Excel training course. She has been training Microsoft Excel for over 20 years.

She is a certified Microsoft Office trainer, a certified life coach and also works as a teaching assistant working at a primary school one day per week.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £275.00 (+VAT)

Book Now
1 Day Intermediate Excel Training Course: CPD accredited

Intermediate Excel Course

CPD Certified
4.85 / 5
1 day.
Client Site Courses Available.
Online, London & Guildford.

This one day CPD certified Excel intermediate course will build your skills making you a faster, more confident Excel user.

  • Creating & formatting charts
  • Using conditional formatting
  • Intermediate-level formulas
  • Creating & filtering data tables
  • Linking data between spreadsheets
  • Time-savings tips and tricks

Overview

This one day CPD certified Excel intermediate course will build your skills making you a faster, more confident Excel user.

  • Creating & formatting charts

  • Using conditional formatting

  • Intermediate-level formulas

  • Creating & filtering data tables

  • Linking data between spreadsheets

  • Time-savings tips and tricks

Full Syllabus

Below is the typical timetable for this training course although exact timings vary between training course.

  • Renaming, inserting, deleting, copying and hiding worksheets
  • Linking data between worksheets and workbooks
  • Different COUNT and SUM formulas
  • Using CONCATENATE to combine text in a cell
  • Choosing, creating and printing basic charts and graphs
  • Creating more advanced charts with axes, titles, legends, gridlines and error bars
  • Using different paste options to paste formulas, values and links.
  • Creating and working with customs views
  • Sorting and filtering data
  • Using conditional formatting to highlight values and duplicates
  • Highlighting data using data bars, colour scales and sparklines
  • Using tables to manage your data
  • Using the Quick Analysis Tools

Am I Ready?

You need a basic of level of Excel knowledge to attend this course. 

This intermediate course is focused making your a faster and more confident user of tools like charts, conditional formatting, and worksheet linking.

It assumes that you understanding the subjects covered in our beginners Excel course like using AutoFill and AutoSum, absolute cell references, formatting worksheets and simple formulas.

Please contact us as we’re very happy to help, or use our Excel level analyser tool to advise you, if you are not sure if this is the right course for you,

Instructor

Lucinda is one of our regular trainers for our intermediate Excel course. She has been training Microsoft Excel for over 20 years.

She is a certified Microsoft Office trainer, a certified life coach and also works as a teaching assistant working at a primary school one day per week.

CPD Accreditation

This course has been CPD certified by The CPD Standards Office.

This course qualifies for 5.75 hours of CPD training.

We issue all attendees who complete this course a full CPD certificate.

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £275.00 (+VAT)

Book Now
Combined Excel Training Course: (Introduction & Intermediate)

Combined Excel Course (Save £55)

CPD Certified
4.86 / 5
2 days.
Client Site Courses Available.
Online, London & Guildford.

Save £55 when you book our Introduction and Intermediate Excel courses at the same time.

This 2 day CPD-certified course is the fastest way to go from complete beginner to confident Excel user.

Overview

Save £55 when you book our Introduction and Intermediate Excel courses at the same time.

This 2 day CPD-certified course is the fastest way to go from complete beginner to confident Excel user.

Full Syllabus

For the detailed syllabus of our introduction and intermediate Excel courses please see the individual courses above.

Am I Ready?

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495.00 (+VAT)

Book Now
2 Day Advanced Excel Training Course: CPD Certified

Advanced Excel Course

CPD Certified
4.9 / 5
2 days.
Client Site Courses Available.
Online, London & Guildford.

Become an Excel power user on this 2 day CPD certified course, mastering Excel’s most powerful tools & functions.

  • Using logical functions
  • VLOOKUP, HLOOKUP & INDEX
  • Creating & editing Pivot Tables
  • Importing & exporting data
  • Automating with macros
  • Using Solver & data controls

Overview

Become an Excel power user on this 2 day CPD certified course, mastering Excel’s most powerful tools & functions.

  • Using logical functions

  • VLOOKUP, HLOOKUP & INDEX

  • Creating & editing Pivot Tables

  • Importing & exporting data

  • Automating with macros

  • Using Solver & data controls

Full Syllabus

Click below to see the detailed course syllabus.

  • Creating and using Defined Names
  • Controlling and documenting Names
  • Using IF with Text and Numbers
  • Nesting IF Functions
  • Using IFERROR, TRUE and FALSE, AND, OR and NOT in formulas
  • Validating data in a number of ways
  • Using formulas as validation criteria
  • Highlighting invalid data
  • Copying validation settings
  • Using XLOOKUP and INDEX MATCH
  • Using reference functions like ROW, COLUMN, OFFSETT and INDIRECT
  • Creating and editing an automatic outline
  • Creating, editing and formatting PivotTables
  • Understanding and creating slicers
  • Inserting a Timeline Filter
  • Advanced PivotTable features like sub-totals, running totals, calculated items and custom names
  • Consolidating data using linked data, data in different layouts and the SUM function
  • Using and merging scenarios and creating a scenario summary report
  • Setting up and using Solver, and running Solver reports.
  • Importing different types of data
  • Working with connected data
  • Exporting data to Word and as text
  • Preparing a worksheet for controls and adding different types of controls
  • Recording simple macros
  • Viewing and editing macros
  • Adding a macro to your ribbon

Am I Ready?

This course is for people who are already reasonably experienced Excel users.

It will show you how to make full use of Excel’s most powerful formulas and built-in functionality.

We recommend that you are comfortable with formulas and basic functions, absolute cell references and sorting and filtering before coming on this course.

If you are not sure if this is the right level course for you, our Excel course level adviser takes less than 60 seconds to complete or alternatively, give us a call as we’d be delighted to help.

Instructor

Photo Of Dallas - Advanced Excel Trainer

Dallas is one of our regular trainers for our advanced Excel course. He has 12 years of experience as an IT trainer.

He also has a PGCE and worked as a school teacher for 7 years before moving into IT training.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495.00 (+VAT)

Book Now
Excel Training: VBA Course

Excel VBA Course

CPD Certified
4.92 / 5
2 days.
Client Site Courses Available.
Online, London & Guildford.

Take complete control of Excel using VBA to create your own code and procedures on this 2 day CPD certified course.

  • The object model & key concepts
  • Programming techniques
  • Procedures & user-defined functions
  • Custom forms including controls
  • Starting procedures automatically
  • Handling errors

Overview

Take complete control of Excel using VBA to create your own code and procedures on this 2 day CPD certified course.

  • The object model & key concepts

  • Programming techniques

  • Procedures & user-defined functions

  • Custom forms including controls

  • Starting procedures automatically

  • Handling errors

Full Syllabus

This is a hands-on course, you will be writing VBA code on both days of the course. The exact timing of segments on individual courses may vary.

  • Understanding, setting up and saving Excel macros
  • Recording, running and editing macros
  • Using relative cell references
  • Assigning macros to the toolbar and ribbon
  • Introduction to VBA, the DEVELOPER tab and the editor screen
  • Understanding the Excel object model and object collections
  • Using and programming in the Object browser
  • Working with Project Explorer and the Properties Window
  • Working with a Code Module and stepping through code
  • Setting breakpoints in code
  • Understanding and bookmarking procedures
  • Creating new sub-routines
  • Using IntelliSense, the Edit Toolbar and commenting statements
  • Understanding, creating and using variables
  • Procedure and level scoping
  • Passing variables
  • Using arrays
  • Understanding and using functions
  • Creating and modifying user-defined functions
  • Creating and referencing a function library
  • Importing a VBA Module
  • Introduction to objects
  • Using Range objects
  • Using object in a procedure and program testing with the editor
  • Using MsgBox
  • Using the InputBox function and method
  • Using IF for single and multiple conditions
  • Using the Select Case statement
  • Loops and looping with specified and unknown iterations
  • Creating a custom form
  • Changing textbox control properties
  • Using controls
  • Adding option and comment buttons
  • Running a custom form
  • Handling form events
  • Transferring data from a form
  • Running and error checking form procedures
  • Programming automatic procedures and automatically starting a workbook
  • Error types and simple error trapping
  • Using the resume statement and decision structures
  • Error handling in forms
  • Defining custom errors

Am I Ready?

This course assumes that you are already an advanced Excel user but does not require any prior knowledge of VBA or Excel macros.

It is a practical course which has you writing your own VBA code on both days of the course.

Instructor

Photo Of Dallas - Advanced Excel Trainer

Dallas is one of our regular trainers for our Excel VBA course. He has 17 years  experience as an Excel trainer.

He also has a PGCE and worked as a school teacher for 7 years before moving into IT training.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £595.00 (+VAT)

Book Now
Excel BI Training: Power Query & Power Tools Course

Excel Power Tools Course

CPD Certified
4.78 / 5
2 days.
Client Site Courses Available.
Online, London & Guildford.

Learn to use Excel’s Power Tools for business intelligence and data analysis on this 2 day CPD certified course.

  • Power Tools: Query, Pivot & Maps
  • Importing data
  • Transforming & preparing data
  • Data models, measures, fields
  • Slicers, Pivot Charts & visualisation
  • Introduction to Power BI

Overview

Learn to use Excel’s Power Tools for business intelligence and data analysis on this 2 day CPD certified course.

  • Power Tools: Query, Pivot & Maps

  • Importing data

  • Transforming & preparing data

  • Data models, measures, fields

  • Slicers, Pivot Charts & visualisation

  • Introduction to Power BI

Full Syllabus

  • What is BI – the main concepts
  • What is Power Query, Power Pivot & Power BI Desktop
  • Importing from CSV, text and Excel files
  • Working with other data sources
  • Meta data and file content queries
  • Different data analysis techniques
  • Filtering out unwanted data
  • Using Auto-Filter and number, text and date filters
  • Removing duplicate values and filtering rows containing errors
  • Sorting rows
  • Moving / deleting columns
  • Splitting columns
  • Merging columns
  • Changing text, number, date/time and locale data
  • Unpivoting columns to rows and transposing a table
  • Creating a custom column
  • Loading data into a worksheet or Excel data model
  • Refreshing queries manually and automatically
  • Query concepts and ETL (extract, transform and load)
  • Creating and editing a simple query
  • Query vs source data
  • How to write ‘robust’ queries
  • What is Power Pivot?
  • Pivot Table Examples with Excel and with a data model
  • Working with Excel files and Excel tables
  • Working with data ranges
  • Understanding acceptable data types
  • Adding and maintaining data in Power Pivot
  • Adding Excel tables to Power Pivot
  • What is a Data Model?
  • Understanding Key Fields
  • Relationships and hierarchy in a data model
  • Types of Calculations in Power Pivot
  • Creating a calculated column and calculated field (measure)
  • Understanding DAX measures
  • Choosing between calculated columns and measures
  • Why a date (calendar) table is required
  • Generating a date table
  • Grouping dates for time analysis
  • Time intelligence functions
  • Excel visualisations:
    • Dashboard & report principles
    • Filtering data using slicers
    • Creating and formatting Power Pivot Charts
    • Connecting Slicers
  • Power BI Desktop
    • Getting data and data models
    • Creating and sharing different visualisations
  • Power BI Workshop
    • Analysing a typical user file, tasks and outcomes
    • Setting up a data model and creating analytics
    • Discussion of the process

Am I Ready?

You don’t need any prior experience with Excel’s Power Tools to attend this course. 

You will be expected to have a good understanding of IF and Lookup functions, Defined Names, importing data and basic PivotTables.

Instructor

Oakley is one of our regular trainers for this course. He has been a Microsoft certified trainer for 6 years.

He has been training Microsoft applications for 19 years and focuses on Excel BI, Power BI and Project.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £895.00 (+VAT)

Book Now

Easy booking & payment

Money back guarantee

Post-course support

Where Are Your Excel Courses in London?

London Training Venue & Course Details

St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150

Online Training Courses

We run a full schedule of interactive online courses over Zoom.
We also deliver private courses over Teams, if requested.

What Do Other Delegates Say About Your Excel Courses?

4.95 from 277 reviews

Getting To Know You

Letting us know before the course which areas you would like to focus on is very helpful.

Tell Us What You Are Looking For From Your Course ->