excel+training

Excel training

Whether you're looking for Excel training for yourself or others, you will find more information on the following:

What course and levels are available?

You can choose from over 14 different types of Excel courses and levels.

Whether it's an introduction to Excel, something more advanced all the way to data visualisation and Excel Dashboards for Business Intelligence, we have you covered.

Our popular Excel VBA (Visual Basic for Applications) courses enable you to automate spreadsheets saving time and reducing errors.

All our Excel training courses cover the most widely used versions of Microsoft Excel, from 2013, 2010, to 2007. We can cater for earlier versions of Office such as 2003 by running dedicated training events specifically for you.

Unsure of what Excel course is right for you? You can speak to a trainer, try this quick online survey, or, for multiple people, we can run a Training Needs Analysis (TNA).

Training formats

We offer a wide choice of Excel training formats, such as public schedule instructor led courses at our London venues, onsite at your offices, closed groups at our venues, floor-walking to blended learning including eLearning.

For larger scale training requirements, such as upgrading staff to a new version of Excel, our training rollout service offers full TNA with the option of project managed delivery to ensure a smooth user migration.

Why trust us?

Our company culture fosters a performance and customer service focused training team. We publish all customer feedback daily on our website, you can browse 50,855 previous customer reviews. More reviews can be found on independent review sites like TrustPilot, where we are rated as "Excellent".

We are committed to delivering what we promise and we don't cancel courses. To drill into more detail just visit here.

All customers attending training at our venues can expect a relaxed productive day of training, opportunity to network with other attendees and enjoy a warm restaurant lunch. After attending our training you get 24 months training support and access to a host of learning resources.

Resources

On our resources page you can find links to our current Excel blog, Excel survey, free training manuals, hints & tips and much more.

Below is an extract from our Excel training course material that we supply as a printed handout on all our public courses.


Excel training

Excel 2010/2013 Introduction

Unit 4: Using Functions

In this section you will learn how to: 

  • Identify common functions 
  • Insert a function into a formula 
  • Use the SUM, AVERAGE, MAX, MIN and COUNT functions

What are Functions?

In Excel, a function can be described as a built in tool for performing mathematical or logical tests. Quite often, you may need to perform operations in your worksheets that involve many cells, like totaling a lengthy column of numbers or averaging a large group of data. Excel's functions can help you with these tasks.

Excel 2010 has a wide range of functions. For example, you can use functions to find totals, averages, counts, minimum (smallest) and maximum (highest) amounts.

SUM - Calculates the sum for a range of cells.
AVERAGE - Returns the average for a range of numbers.
MAX - Returns the largest number from a range of numbers.
MIN - Finds the minimum number in a range of numbers.
COUNT - Will count the number of cells in a list that contain numbers.

Using AutoSum

It is often useful to have totals or sums for the rows and columns of numbers in your worksheet. AutoSum can easily add all of the numerical data in a column or row. 

  • Select the cell immediately below the column of data (or immediately beside the row of data) 
  • Click the Formulas tab 
  • Click AutoSum button in the Function Library group.
    (The AutoSum button can also be found on the 'Home' ribbon in the 'Editing' group).
  • The column or row of data to be summed will now be enhanced by an animated border.
    Notice that you can see the range to be summed in the active cell. 
  • Press Enter and the total will be displayed in the cell.

Try it: On Sheet 1 of Sales report.xlsx use the AutoSum button to calculate Total actual and target sales for each quarter in row 11.

The Function Library

Excel 2010 contains an extensive library of functions that you can call upon to help you solve problems. These tools are available in the Function Library button group, on the Formulas ribbon.

The first and largest button is Insert Function. This button will open a dialogue box allowing you to search for and insert hundreds of functions.

You can also click the small fx button next to the formula bar to display the Insert Function box.

Clicking the Insert Function button activates the Insert Function dialogue box and provides access to the large range of functions available in Excel.

Once the Insert Function dialogue box is open: 

  • Select the function you wish to use from the available list and click OK or 
  • Type the name of the function you wish to use in the Search for a function area, press Enter, select the function when it appears in the list and click OK.

In the Function Arguments dialogue box, click the top button with the red arrow, then select the range of cells to enter into the formula from the spreadsheet, click OK.

Try it: On Sheet 1 of Sales report.xlsx type Average into cell A12. Use the Insert Function button to calculate average actual and target sales for each quarter in row 12.

Using the AutoSum dropdown list

The AutoSum button dropdown arrow provides access to common functions, and the Insert Function dialogue box.

To insert a function using the AutoSum list:

  • Select the cell where the formula is to appear in the spreadsheet
  • Select the function you wish to use from the AutoSum list
  • Check the formula to ensure it is accurate - edit the formula if necessary
  • Press Enter to confirm the formula and display the formula result.

Try it: On Sheet 1 of Sales report.xlsx type Minimum into cell A13. Use the AutoSum list to calculate minimum actual and target sales for each quarter in row 13.

Entering functions manually

All the common functions follow the same basic structure:
=function_name(cell:cell) or =function_name(cell,cell,cell)

Therefore, formulas containing functions can be typed directly into a cell in the spreadsheet. After pressing the = (equals button) start typing a function name. Immediately after entering the first character of the name, Excel provides you with a list of function names beginning with that letter. Locate the function name you require and double click on it. Excel will then insert the name together with the opening bracket. All you then have to do is to complete the function requirements and press enter. The closing bracket is automatically inserted for you and the result of the formula is entered into the selected cell.

Try it: On Sheet 1 of Sales report.xlsx type Maximum into cell A14. Enter formulas to calculate maximum actual and target sales for each quarter into row 14.

Type No. of employees into cell A15.

Use any one of the three methods for inserting functions to enter the COUNT function into cell B15. The COUNT function can be used on cells that contain values, to determine how many values there are. In this case, we want to know how many employees there are.

Using AutoCalc

The AutoCalc feature in the status bar at the bottom-right of the Excel window can be used to find the result of using particular functions on cells that have been selected in the spreadsheet.

To use the AutoCalc feature:

  • Select the range of values that you wish to find the total/average/minimum/maximum/count of
  • Right-click in the status bar and choose the relevant function(s) from the menu to view the result in the status bar area.