Microsoft Excel Training

Our standard Excel Courses take you through the skills needed to work in your business on a day to day basis.

We deliver Microsoft Excel training for both Windows and Mac users.

For Windows – Excel 2007, Excel 2010, Excel 2013 and Excel 2016

For Mac users – Excel 2008 and Excel 2011

Which Excel training course is right for your organisation?

Microsoft Excel Training Essentials

Who should attend?

Anyone who has never used Microsoft Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts.

Training Requirements

Delegates must be confident in using a mouse.

Aim

By the end of the course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae.

What you will learn

  • In particular you will be able to:
  • Create, save, close, open and print spreadsheets
  • Insert and delete rows or columns in your spreadsheet
  • Get Excel to automatically add up numbers
  • Copy formulae in your spreadsheet whilst keeping one of the cell references constant
  • Alter the look of the numbers and text, to make parts of the spreadsheet stand out
  • Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand

Course Outline

Microsoft Excel Training Essentials

Click here to download the course outline

Microsoft Excel Intermediate

Who should attend?

Anyone who has used Excel before to create and alter simple spreadsheets.

Training Requirements

Delegates must be confident in using a mouse. Additionally you must have used Excel before and be familiar with using formulae for simple calculations, for example, AutoSum, basic formatting and autofill to quickly copy formulae.

Aim

By the end of the course, you will be confident in going beyond the basic features in Excel. For example using multiple sheets, linking them to create formulae across sheets, use common functions such as Average and If statements and manage data in an Excel database.

What you will learn

In particular you will be able to:

  • Protect part of your spreadsheet to avoid deleting formulae
  • Create and work on more than one worksheet
  • Copy part of your Excel spreadsheet to a Word document and have any changes made in Excel updated in the Word document
  • Use features such as average, minimum and maximum to create statistical information
  • Create a calculation based on a condition. For example, add a £10 bonus to all staff who have achieved results above target
  • Extract specific information from an Excel database. For example, show only the organisations with more than 1000 employees

Course Outline

Microsoft Excel Intermediate

Click here to download the course outline

Microsoft Excel Training – Advanced

Who should attend?

Anyone who has been using Excel for budgets and managing information.

Training Requirements

Delegates must be confident in using a mouse. Additionally you must have used Excel before and be familiar with entering formula and using absolute cell references (see our Excel Essentials and Intermediate Outlines).

Aim

By the end of this Excel training course, you will be confident in using some of Excel’s more advanced features. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.

What you will learn

In particular you will be able to:

  • Move around a spreadsheet speedily using range names and even use them in formula to make them easier to read
  • Use the auditing feature to check where the errors such as DIV?0 or NAME come from
  • Create calculations based on conditions. For example, add a £10 bonus to all staff who have achieved results above target
  • Use Hlookup and Vlooukup functions. For example, to look up how much poll tax should I pay based on the value of my house?
  • Use Filters and Pivot Tables to help manipulate your data to find only the data you are interested in and make it easier to read
  • Create macros to automate your work
  • Assign a button on a toolbar to a macro to make it easier to use

Course Outline

Microsoft Excel Training - Advanced

Click here to download the course outline

Excel Training – VBA

Who should attend Excel VBA Training?

This course is for experienced users of Excel who wish to use Excel VBA to automate repetitive tasks.

Requirements

Delegates must have experience of using Excel to an advanced level, recorded and edited macros.

Aim

By the end of the course you will learn how to use Visual Basic to control Excel, and to automate processes to speed up and simplify your work with Excel data.
What you will learn

In particular you will be able to:

  • Understand what VBA is.
  • Understand the Excel object model, and make use of its properties, methods and events
  • Declare and manipulate variables
  • Write code which looks at a condition and carries out different actions accordingly
  • Write code which repeats an action a specified number of times
  • Create functions to reuse frequently used pieces of code
  • Trap errors, to avoid users seeing problems and to find problems in code

Course Outline

Excel Training - VBA

Click here to download the course outline

Excel Pivot Tables and Dashboards

Who should attend this training?

Anyone who needs to use Microsoft Excel to create dashboards for visual and data analysis when wanting to present clear and logical output for decision makers.

Requirements

Delegates wishing to attend this course must;

  • Have attended the Microsoft Excel advanced course or be familiar with the topics that are outlined.

Aim

By the end of this course you will be able to use workbook best practice to setup a dashboard from scratch by using charts, tables and other visualisation techniques.

What you will learn?

In particular, you will be able to:

  • Create a number of differing pivot charts and alter their make-up to effectively present data.
  • Use slicers to control the output to charts and tables.
  • Build linked tables to present information.
  • Learn the features of conditional formatting to highlight changes in data.

Course Outline

Microsoft Excel - Pivot tables and dashboards

Click here to download the course outline

Excel Power User Training

Who should attend Excel Power User Training?

Anyone who wishes to be adept and get the most out of Microsoft Excel by using its advanced functionality.

Requirements

Delegates wishing to attend this course must;

  • Have attended the Microsoft Excel advanced course or be familiar with the advanced course topics.

Aim

By the end of this course you will be able to manipulate data sets, locate specific data in a table, consolidate data and create single formulas to aggregate a series of data.

What you will learn?

In particular, you will be able to:

  • Import data outputted from differing systems, tidy, amend and query.
  • Use lookup and reference functions to simplify finding specific entries in a data table
  • Summarise and report results from data on separate worksheets or workbooks and easily update and aggregate
  • Work with array formulas on a series of data values to aggregate them using SUM(), AVERAGE(), or COUNT(), to return a single value in a single cell

Course Outline

Microsoft Excel Power User

Click here to download the course outline


Microsoft IT Training

Which Microsoft Office skills training do you need?

Please give us as much information as possible so that we can give you the best answer.

Fields marked with a * are required