Our standard Microsoft Excel training 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 2016 and Excel 365
For Mac users – Excel 2016 and Excel 365
Which Microsoft Excel training course is right for you?
Microsoft Excel 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 and saving, opening and closing files
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 while 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
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
Microsoft Excel 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 formulae 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 a formula to make them easier to read
- Use the auditing feature to check where errors originate e.g. DIV/0 or NAME
- 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
Microsoft 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
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 set up 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.
Excel Power User
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
Microsoft IT Training
Which Microsoft Office skills training do you need?