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

£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

very clear from instructor once again, clear and easy to listen to teacher

Learnt a lot of useful tips for excel

very informative, trainer knew a lot about the subject matter and could answer the questions raised by the group

good overall experience

Well delivered course, met my expectations

Tom was very clear and made it very easy to understand.

It was very useful. Some I had forgotten some I didn't know at all

Very good experience, learnt some new things and understand excel a lot more. Trainer was knowledgeable and engaging and made the session really enjoyable.

Clear, Concise and helpful

very positive. Tutor very helpful and patient! Covered off key elements to enable me to put learnings into practice in work environment. Will be highly beneficial.

Excel Tips & Tricks

How to add Subtotals

GoExcel

Subtotals are applied to data using summary functions such as SUM or AVERAGE. To apply subtotals firstly select all your data. Next, go to the Data tab and select Subtotal and this will open the Subtotal window.

At Each Change In – The column that you want to Subtotal

Use Function – The function you want to use to calculate the Subtotal

Add Subtotal To – The column that contains the values you want calculate

Once you have completed the above options click OK. Subtotals will now be applied to your data.

How do you apply a Sparkline to an excel spreadsheet?

You can use a Sparkline to show your data in a more visual way.

GoExcel

How to insert a Sparkline

1. Go to the Insert tab > Sparkline group and select one of the options.

2. Select the data to be shown in your Sparkline

3. Select a cell location for your cell. Click OK.

How to change your themes colours in Excel

GoExcel

If you want to change a theme’s colours you can choose a different colour scheme.

To choose a different colour scheme go to the Page Layout tab and select Colors. From the dropdown choose a colour scheme that you like.

How to find the numeric representation of a Row

GoExcel

You can use the ROW function to return the row number of the cell that you have referenced. For example, row 1 = 1, row 2 = 2, row 3 = 3 etc.

To use the formula type =COLUMN( and then input the cell that you want to find the column number for.

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 delete multiple columns in Excel

GoExcel

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

How to remove errors from a spreadsheet?

GoExcel

If you keep getting errors in your spreadsheets, then how about forcing Excel to show a different value. To do this we use the IFERROR function.

To apply it to your formulas, nest it around the formula just like the image above.

How to insert the same data into multiple cells using Flash Fill

GoExcel

If you want to insert the same data into multiple cells, then you can do so using the Flash Fill function. To use Flash Fill, select all the cells that you want to input data into. Once you have selected the cells, type in the required data. Finally, press CTRL + Enter. This will now populate all the cells.

How to insert a Timeline into a PivotTable

GoExcel

You can use Timelines to help filter PivotTables based on dates. To insert a Timeline, go to the Analyze tab and select Insert Timeline. This will open the Insert Timelines window. Choose the field you want to create a Timeline for and then click OK. This will now put a Timeline into your spreadsheet.

How do I count items based on a criteria?

GoExcel

If you want to count how many times an item appears in a range of cells, then we can use the COUNTIF formula.

The COUNTIF formula consists of two parts which are:

· Range – the list of data that you want Excel to find the Criteria in

· Criteria – the item that you want Excel to count in the range

So for example, if you wanted to count how many times a persons name appears in a list, your Range would be the list of staff names and the Criteria would be the persons name that you want to count in that list of staff names.

How to apply the Selection Label on a Timeline

GoExcel

The Selection Label is a label that appears on the top left of a Timeline. The label shows you the data you have selected. To apply the Selection Label, click on your Timeline and go to the Timeline Tools tab. On the Ribbon in the Show group check the Selection Label box and this will apply it. If you want to remove it just uncheck the Selection Label box.


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