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

I found the section on OneNote to be quite helpful and will use it in the future, and learned a lot of new things on Outlook

Very enlightening session

really good. Dan was really impressive in range of knowledge and method of explanation

Extended my knowledge of Excel, thoroughly explaining hints, tips and tricks.

good beginners course

Really helpful, Matt explained things very well

Informative, eye opening, time saving

Excellent. Matthew's knowledge combined with the activities enabled me to learn new skills

Excel Tips & Tricks

How to find the Median of a range of numbers?

GoExcel

If you want to find the middle value of a range of figures, then use the MEDIAN function in Excel. Type =MEDIAN( and then insert the range of cells you want to find the Median of. When you hit return it will provide you with the median.

How to use the asterisk wildcard to filter

GoExcel

If you want to filter data more broadly, then why not use an Asterisk Wildcard to help. An asterisk represents multiple characters when filtering. In the search bar on your filter dropdown you can place the asterisk in different places to return different outcomes. For example:

*A would return all records that end in A

A* would return all records that start with A

H*A would return all records that start with H and end in A

*A* would return all records that has a A in it

How to change the Time Level on a Timeline

GoExcel

On a Timeline you can filter based on either Year, Quarter, Month or Day. To change the date options, click on the Time Level dropdown located in the top right of your Timeline. Finally, select the date option you want to filter your dates by.

How to create your own colour scheme in Excel

GoExcel

If you don’t like the colour schemes that Excel provides then you can create your own colour scheme.

To create your own colour scheme, go to the Page Layout tab and select Colors. At the bottom of the dropdown select Customise Colors. This will then open the Create New Theme Colors window. Finally go and choose different colour for your Accents and Hyperlinks.

To finish give your new colour scheme a name by typing it into the Name box and then click Save.

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 find if a number is even in excel?

GoExcel

If you need excel to return a number as Even then use the ISEVEN function. Type =ISEVEN( and then select the cell you want to reference. If you get a TRUE answer it means that the number is even. If you get a FALSE answer it means that the number is odd.

How to unhide an Excel window

GoExcel

If you want to unhide an Excel window, then select the View tab and click on Unhide. This will open the Unhide window. Select the window you want to unhide and then click OK.

How to create an input message

GoExcel

An Input Message informs the user what data needs to go into the selected cell. To create an Input Message, go to the Data tab and select Data Validation. This will then open the Data Validation window. Next go to the Input Message. In the Title box type the title for Message and in the Message box type the message you want the user to read. Finally click OK.

Num – the cell that you want to round

Num digits – the number of decimal places you want to roundup to, for example 1 would round up to one decimal place


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