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

Helpful and informative

Excellent, very informative

Well delivered and engaging

Excellent Course, Excellent Trainer

The trainer was lovely and enthaustic about the subjet

Very informative and has improved my understanding of VBA

Matt was very good at explaining what we required

Excellent, very informative and helpful

Excel Tips & Tricks

How to find the smallest number in a range of cells

GoExcel

If you want to find the smallest number in a range of cells, then use the MIN function. To create this formula type =MIN(

After the open bracket input the range of cells that you want to find the lowest value for. To finish close your bracket and press enter.

How do I apply pound signs to values in Excel?

Instead of having to type out the pound sign repeatedly, Excel has provided a formatting tool that will take care of it for you.

GoExcel

How to apply pound signs

1. Select the values you want to apply pound signs too

2. Go to the Home tab, Number and select the drop down box

3. Select either Currency or Accounting to apply pound signs

How to use the question mark wildcard to filter

GoExcel

If you want to filter using a broader criterion then you can use question marks in your search. A question mark represents a character and you use them within the search bar on your filter dropdown.

For example, if you typed 10?4 into the search bar it would return numbers such as 1004, 1014, 1024, 1034 etc.

What is this week’s number in the current year?

GoExcel

A quick way of finding out which week of the year we are up to is by using the WeekNum function. Once this formula is completed, it will return a number which is based on the week number that you are up to in that current year.

To use the formula, type the function =WeekNum( and then put in a date. Excel will then return the week number that date falls in. If you want it to be dynamic then why not replace the date with the TODAY function.

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 sort multiple columns of data based on the value of its cells

GoExcel

In Excel you can sort multiple columns of data. This allows you to sort your data more thoroughly.

To sort multiple columns, firstly select all your data. Next, go to the data tab and select sort, this will then open the Sort Window. In the drop down next to Sort by, select the column that you want to sort first. In the Sort On drop down select values. For the Order drop down choose how you want the data to be sorted.

Once you have completed that level of drop downs click on add level. Repeat the process above and keep doing it until you have sorted all the columns you want to sort.

Before clicking OK, make sure that the My Data has Headers box is ticked. Otherwise it will sort your headers in with the rest of your data.

Your data should now be sorted by the specified columns.

How to use the FIND formula?

GoExcel

If you want to search for a string of text within a larger string of text, then use the FIND function. This function will return the character number of where the string of text is located. For example, if you wanted to find the letter O in laptop, the FIND function would return 5 as O is the fifth character along.

The syntax for this formula is =FIND(Find Text, Within Text, [Start Number])

Find Text – The text you want Excel to find

Within Text - the string of text you want to find something in

Start Number – the character that you want Excel to start searching from (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 count how many times a value appears in a list?

GoExcel

The Frequency formula counts how many times a value appears in a range. It then places the results into a summary table. The formula does return multiple answers.

Therefore, once you have typed your formula into Excel, instead of pressing Enter, we press Ctrl + Shift + Enter.

How to hide an Excel window

GoExcel

If you want to hide an excel window whilst you’re working on another task, then you can use the Hide tool. This will hide the window and your formulas will still be able to reference the hidden sheet.

To hide a window, go to the View tab and select Hide on the Ribbon. This will then hide the window.

How to add and remove Grand Totals on a PivotTable

GoExcel

If you want to add Grand Totals to your Pivot Table, then select your PivotTable and click on the Design tab under PivotTable Tools. On the Ribbon select Grand Totals and choose where you want them to be applied to your table.


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