Microsoft Excel Training Courses

Microsoft Excel is a spreadsheet program that can be used for storing, modifying and manipulating data. It's commonly used by businesses to:

• Perform mathematical operations such as summing, dividing and subtraction.
• Finding averages, maximum and minimum values in a range of data.
• Finding values such as profit or loss.
• Sorting and filtering data to find specific information.
• Graphic and charting data to show data trends and aid in analysis.
• It's also used by bigger businesses to create complex models and systems using visual basic (VBA).

AJ Training offer a range of beginner to advanced Excel hands on training courses and workshops delivered online, at our Rotherham training suite or on site at your location.

Levels

Our introduction training is the ideal Excel course for beginners and covers:

Spreadsheet Management
Data Management
Formatting Excel
Formulas and Functions
Formula Auditing
Charts
More details..

eLearning package available

Our intermediate Excel course covers:

Formulas
Formatting Cells
Working with Data
Excel with other programs
Protection
Pivot Tables
More details..

eLearning package available

Our advanced Excel course covers

Consolidation
Text Manipulation
What if Analysis
Forms
Macros
Customising Excel
More details..

eLearning package available

Our Excel VBA training covers:

Environment Introduction
Visual Basic controls
Language
Variables
Creating forms
Debugging
More details..

Try our Level Selector to find the best course for you.

Please assess each statement and select 'YES' if it lists a process you understand, if in doubt select 'NO'.

Statement

Yes No

Copy and paste values

Create sequences using AutoFill i.e. dragging

Create simple formulas, such as the SUM function, to calculate totals

Fix cell references in formulas using Absolute Referencing i.e. using dollar signs ($)

Sort, filter and sub-total data to retrieve information

Create IF, Nested IF and VLOOKUP formulas

Change the colour of a cell depending on the cell's value

Prevent invalid data from being entered into a cell

Create basic array formulas e.g. SUMIF, COUNTIF and AVERAGEIF

Create PivotTables and PivotCharts

Create text manipulation formulas to analyse an external data source

Create INDEX and MATCH formulas

Create INDIRECT formulas

Use tools such as Goal Seek, Scenarios and Data Tables to project figures

Record macros and assign them to a button

Continue Reset

Unique Skills Retention Service

Full feature explanations
Video examples
Sample exercises

Post Course Engagement is optional and charged @ £25.00 plus VAT per delegate per course.

Prices

One Company

£495.00

per day * VBA £695

At our Rotherham training suite
Up to 8 delegates
Lunch and refreshments provided
Option to tailor content, add £100

Enquire Now

On-site Training

£575.00

per day + travel costs * VBA £755

Training at your chosen location
Up to 8 delegates
Equipment Included
Option to tailor content, add £100

Price Estimate

Scheduled Course

£150.00

per delegate, per day * VBA £245

At our Rotherham training suite
Equipped training room
Lunch and refreshments provided

Book Now

ELearning

£39.99

per user

12 months subscription
Unlimited access
Online support
Progress tracker

All trainer delivered courses include

Certificate of attendance
e-Mail support
Course notes
Skills retention add-on

AJ Respond to all online bookings within 3 working hours, we will email you back to confirm prices, availability and content of the requested course.
Once confirmed we will forward joining instructions along with an invoice payable 10 days before the course date.

AJ Scheduled Course List

Excel

Intermediate

09/07/2025

£150.00 per delegate per day

Book Now

Excel

Advanced

10/07/2025

£150.00 per delegate per day

Book Now

Excel

Introduction

21/07/2025

£150.00 per delegate per day

Book Now

Excel

Intermediate

22/07/2025

£150.00 per delegate per day

Book Now

Excel

Advanced

23/07/2025

£150.00 per delegate per day

Book Now

Excel

Introduction

06/08/2025

£150.00 per delegate per day

Book Now

Excel

Intermediate

07/08/2025

£150.00 per delegate per day

Book Now

Excel

Advanced

08/08/2025

£150.00 per delegate per day

Book Now

Excel

Introduction

18/08/2025

£150.00 per delegate per day

Book Now

Excel

Advanced

20/08/2025

£150.00 per delegate per day

Book Now

Excel

Intermediate

21/08/2025

£150.00 per delegate per day

Book Now

Microsoft Excel

VBA

Date TBC

£225.00 per delegate per day

Book Now

Please note scheduled courses are priced per delegate, per day and exclude VAT.

Our course schedule covers the standard training for the coming months, if the dates or course you require is not listed then please call 01709 352307 or email info@ajtraining.net and we will happily schedule additional courses.

Training Reviews

the training was made to be fun and educational I really enjoyed it

Well put across useful information

great to refresh my knowledge on excel and also gain a lot of new knowledge.

Really good an informative, something I really need to put into practice

First class. Excellent content and excellent tutor.

Really interesting. Dan made the maths bit interesting too.

Matthew was very clear, informative, responsive and set a good pace

Really useful and clear instruction with examples

Knowledgeable and comprehensive but in a very plain English way

As a daily user of Excel, I have learnt many new ways to work more efficiently. I really enjoyed the course.

Excel Tips & Tricks

How do I show duplicate values in a range of cells using colours?

GoExcel

If you want to show duplicates clearly, how about using the Conditional Formatting tool to show the duplicates with colour.

All you need to do is select Duplicate Values from the Conditional Formatting tool and choose a colour. The duplicates will now be showing in colour.

How to change your themes fonts in Excel

GoExcel

If you are not happy with the fonts that your theme uses, then you can change them.

To do this go to the Page Layout tab and select Fonts. From the dropdown choose a font option that you like.

How to use the COUNTBLANK function?

GoExcel

If you want to count how many blank cells there are in a range, then why not use the COUNTBLANK function.

To use it, type in =COUNTBLANK( and then put in the range of cells that you want it to count the blanks.

How to only allow whole numbers in cells using data validation

GoExcel

If you want to restrict users so they can only input whole numbers into cells, then use Data Validation.

Firstly, select the cell(s) that you want to restrict. Then go to the Data tab and select Data Validation. Once selected, go to the Allow dropdown and choose Whole Number. In the Data dropdown select the best option for your spreadsheet. For example, if you want the user to input whole numbers between two points then you need to choose Between. Finally, in the Values box type in the criteria(s).

Hyperlinking to a Sheet in your Workbook

GoExcel

A hyperlink can be used to quickly navigate to another sheet within your workbook. This is useful if you have a lot of sheets, as it will save you from having to click through the sheets trying to find the one you want.

1. Select the cell you want the link to appear in

2. Go to the Insert tab, and in the select Links group select Link

3. In the text to display box, type the text that you want to use as your link

4. On the left-hand side of the window, select Place in this Document

5. From the worksheets listed, select the sheet you want to link to

6. Click OK

How to create your own fonts in Excel

GoExcel

If you would like to create your own font combinations instead of using Microsoft’s options, then go to the Page Layout tab and select Fonts. In the dropdown select Customize Fonts. This will open the Create New Theme Fonts window.

In the Heading Font dropdown, select a font you want to use for your headings.

In the Body Font dropdown, select a font you want to use for the body of your text.

In the Name box, give your font combination a name and click Save.

How to delete data from multiple cells at once

GoExcel

If you want to delete multiple cells, then select all the cells you want to delete and then on your keyboard press Delete.

How to use the CHOOSE formula?

GoExcel

If you want to select an item from a list based on an index number, then why not try the CHOOSE formula. For example, if you had a list of days starting with Monday and you asked excel to return the day that corresponded with index number 3 then excel would return Wednesday.

The syntax for the CHOOSE function is =CHOOSE(index_num, value 1, [value 2],...)

Index Number – the number excel is going to use to find the correct item from the list

Value 1 – the first value on your list

Value 2 – the second value on your list (optional)

How to check if a value is a number in Excel?

GoExcel

If you want to check if a value is a number, then use the ISNUMBER function. To use it, type in =ISNUMBER( and then the cell you want to reference. When you hit return you will get either a TRUE or False answer. If you get TRUE returned, it means that the value is a number, date or time. Therefore, if you get FALSE returned it means that the value is not a number value.

How to add a theme to your spreadsheet

GoExcel

If you want to change the look of your Excel workbook, then have a look at applying a theme. A theme allows you to change the colours, fonts and effects in your workbook.

To apply a theme, go to the Page Layout tab and select Themes. From the dropdown choose a theme that you would like your workbook to have.

How to delete multiple rows in Excel

GoExcel

If you want to delete multiple rows of data from a spreadsheet then select the rows you want to delete. Next, right click on a row number you have selected and click Delete from the menu.


Name :
Company :
Telephone Number :
Email Address :		**
Confirm Email Address :		** * Address details dont match

Date Required :
Name :
Company :
Telephone Number :
Email Address :		**
Confirm Email Address :		** * Address details dont match

Course :
Course Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

Course :
Requested Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now

Course :
Requested Date :
Name :
Company :
Telephone Number :
Email :
Confirm Email :

	Enquire Now

Course
Excel Introduction
Excel Intermediate
Excel Advanced

Outlook All in One Covers all levels in one course


PowerPoint All in One Covers all levels in one course

Word Introduction
Word Intermediate
Word Advanced

Course :
Request Date :
Number of Places :
Name :
Company :
Telephone Number :
Email :	**
Confirm Email :	** * Type mismatch

	Book Now