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

Detailed, fun and very helpful!

Very knowledgeable instructor, made the course interesting and easy to talk to and answered any questions the group had.

I thought intermediate level would be a bit more in depth, but looking forward to doing the advanced level.

Very informative, learnt new interesting skills

Good to get detail on the basics

excellent course. very well presented.

Very good and helpful

Helped me massively to improve my excel knowledge

Excel Tips & Tricks

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.

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 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 count cells that contain numbers

GoExcel

If you want to count numbers in a range of cells, then use the COUNT function. To create this formula type =COUNT(

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

How to remove spaces from the beginning and end of a string of text?

GoExcel

In Excel you can use a function called TRIM to remove spaces from the beginning and end of a string of text.

To use it type =TRIM( and then insert the cell reference that you want to remove spaces from.

How to clear multiple filters that are applied to data

GoExcel

Once you have finished filtering multiple columns of data, you can then clear the filters. To do this, go to the data tab and on the ribbon select Clear. This will then return you with all your data.

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.

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

Adding a ScreenTip to a Hyperlink

GoExcel

If you want to personalise your hyperlink, then why not add a ScreenTip. A ScreenTip is a message that gives the user an instruction on what to do with the link. This message will appear when the user hovers over the link.

How to change the direction of my text in Excel?

If you want to make text, such as headers, take up less room in your spreadsheet, then use the orientation tool. This will allow you to view more columns at a time.

GoExcel

How to Change the Orientation

1. Select the cell(s) that contain(s) the text you want to change the direction for.

2. Go to the Home tab, Alignment and select the Orientation tool.

3. Choose the orientation you want to apply.

How do you apply borders to a cell in Excel?

Excel has a tool called Borders which applies lines to your spreadsheet.

GoExcel

How to use borders:

1. Select the cell(s) you want to apply a border too.

2. Go to the Home tab, Font and select the Border tool dropdown.

3. Choose the border you want to apply.


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