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

£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

very informative, looking forward to taking the knowledge learnt into practice

very informative and will be very useful

Very thorough and Mike was very clear at explaining things.

Very well presented. Matt is obviously very knowlegable on Excel. Lots of little hints and tips.

Tom was a good instructor and I also learnt alot from today.

Very good, clear and concise.

I found the content easy to understand and follow, and Matt did a brilliant job of answering any questions asked.

very good and insightive

Very useful and helpful

Learnt a lot of new skills that can help with my field of work. Very interactive which made me learn a lot more by actually doing the actions rather than just listening

Excel Tips & Tricks

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.

How to insert and remove a blank line after each item in a PivotTable

GoExcel

If you feel that your PivotTable is quite compact when working with multiple rows, then you can space your data, so you can read it more easily. To do this go to the Deign tab under PivotTable Tools and select Blank Rows from the Layout Group. In the dropdown choose the option you want.

How to use the AND formula?

GoExcel

If you want to check that multiple conditions in your spreadsheet are TRUE, then we can use the AND formula.

For example, if you wanted to check if a number is greater than 10 but less than 50 we could use an AND formula. The formula in this example would be =AND(A5>10,A5<50)

Another example that you could use the AND formula is to compare two cells to check that they are the same. The formula for this example would be =AND(A5=10,B5=10)

How to filter data using Slicers?

GoExcel

You can use slicers to filter data that is formatted in a table quickly and easily. To insert a slicer into your Excel spreadsheet, select your table and go to the Insert tab. In the Filters group select Insert Slicer and choose the fields from the list you want a slicer to apply too.

You will now have a slicer in your spreadsheet. To use it, just select the option from the list that you want to view. For example, above I have chosen to see the food orders that Terry Walton dealt with.

How to apply filters to data

GoExcel

If you want to be able to filter your data, then we firstly we have to apply filters to your data.

To apply filters, select your data and go to the Data tab. On the ribbon you will find the Filter button. Click on it and you will notice dropdowns will get applied to your headers.

How to apply the Developer tab?

GoExcel

If you want to work with macros or add form controls to your spreadsheet then you will need access to the Developer tab. The Developer tab doesn’t appear as a default in Excel, so you have to add it to your tabs.

To add the Developer tab, go to the File tab and select Options. From the Excel Options window select Customise Ribbon and tick the Developer box on the right. Finally click OK and you will notice the developer tab at the end of your tabs.

How to create an IF formula

GoExcel

An IF formula is where we give Excel a statement and it will return an answer based on that statement. For example, if expenditure is greater than budget then return overspent, otherwise return under budget.

The Syntax for an IF formula is IF(Logical_Test, Value_if_True, Value_if_False)

The Logical Test is the statement that Excel uses to be able to return the right answer. In the Logical Test we must use Conditional Logic symbols which are > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to), = (equal to), <> (not equal to).

Value if True is the answer you want Excel to return if the Logical Test is met.

Value if False is the answer you want Excel to return if the Logical Test isn’t met.

For your Value if True and Value if False you can use text (which must be in speech marks), cell references, numbers and formulas.

How to replace text with new text in Excel?

GoExcel

If you want to replace a section of text, then give the REPLACE function a go. This function allows you to replace a specified amount of characters with new text.

The syntax for the REPLACE function is =REPLACE(old text, start num, num chars, new text)

Old text – the text that you want to replace

Start num – the first character that you want to replace

Num chars – the amount of characters you want to replace

New text – The new text you want to replace the old text with

How to create a PivotTable

GoExcel

To put data into a PivotTable, highlight your data and select the Insert tab. On the Insert tab select PivotTable, this will open the Create PivotTable window. Make sure the range of cells it is showing is correct. Next select where you want the PivotTable to be placed. You can either select it to be on a New Worksheet or an Existing Worksheet. Once you have chosen an option, click OK and Excel will now have created a PivotTable for you.

How to find if a number is odd in excel?

GoExcel

If you need a formula that will return if a number is odd, then why not give the ISODD function ago. Type in the function =ISODD( and then select the cell you want to reference. When you hit enter it will either return a TRUE or FALSE answer. TRUE means the number is odd and false means that it’s an even number.

How to display Subtotals to a PivotTable

GoExcel

If you want to display Subtotals on your PivotTable then select your PivotTable and go up to the PivotTable Tools tab and select Design. On the Ribbon click on Subtotals and choose where you want the Subtotals to be displayed.


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