• 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

Filter by category:

1 Day Introduction Excel Training Course: CPD Accredited

Introduction Excel Course

Client Site Courses Available.
4.8 / 5
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

Client Site Courses Available.
4.85 / 5
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)

Client Site Courses Available.
4.86 / 5
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

Client Site Courses Available.
4.9 / 5
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

Easy booking & payment

Money back guarantee

Post-course support

Where Are Your Excel Courses in London & Guildford?

London Training Venue & Course Details

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

Guildford Training Venue & Course Details

Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

Online Courses

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

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