Home > Microsoft Excel

Microsoft Excel

Excel Introduction (Level 1)
Excel Introduction (Level 2)
Excel Intermediate (Level 1)
Excel Intermediate (Level 2)
Excel Advanced (Level 1)
Excel Advanced (Level 2)
Schedule of Dates

FREE - Training Needs Analysis

What is Excel?
Excel is almost certainly the worlds most popular spreadsheet program.  It allows you to enter different types of data (text, numbers, dates etc) and then allows you to manipulate that data in a number of different ways.
•    You can add formula and functions to your spreadsheets so that you can automate any number of calculations from simple totals and averages right up to complex mathematical equations.
•    You can sort and filter data such as contact details, list of invoices or product lists.
•    You can create charts from your data as well as complex reports.
Who uses Excel?
Most UK companies and corporations around the world use Excel as their preferred spreadsheet program.  Students use it to organise their data.  It is useful for home users to help control finances, keep contact lists and make schedules.

Which Excel Course is right for me?
If you are not sure which course to attend please complete a
training needs analysis form and we will be happy to analyse the results free of charge, alternatively take a Quick Quiz by clicking on one of the links below.  At present we run six scheduled courses: 

Introduction (Level 1)  This course is a prerequisite for anyone who does not already have a good grounding in Excel.  In this course you will learn to enter and format data as well as create basic formula and add functions such a sum or an average.  It will enable you to design and print professional-looking charts. Take the Quick Quiz.

Introduction (Level 2) This course is for users who have already mastered the basics of Excel.  You should already be confident with entering and formatting data, as well as be able to input a simple formula.  In this course you will learn how to fix a formula onto a special cell or range using Absolute References and Named Ranges.  You will learn Count, Text, Date and Rounding Functions. You will be shown how to Link Excel Data to Word or PowerPoint.  You will learn to create a custom chart with your own colour scheme and logo. Take the Quick Quiz

Intermediate (Level 1)  This course if for delegates who already have a good grasp of Excel formula and simple functions but would like to expand their function knowledge to use decision-making functions such as IFS and LOOKUPS. You will learn how to "nest" functions, so that you can use more than one function in any given cell.  It shows heplful tips for calculating over multiple sheets and linking information into other programmes such as Word or PowerPoint. You will be taught how to use conditional formatting to change the colour of a cell dependant on its value. Take the Quick Quiz

Intermediate (Level 2) On this course you will learn how to use Mixed Referencing and Worksheet Specific Named Ranges to speed up formula creation. You will use Data Validation to restrict the values users can enter into a cell.  You will enhance your knowledge of Conditional Formatting so that you can change the appearance of cells by adding your own formulae.  You will learn advanced sorting techniques including Sorting by Colour and Sorting Using a Custom List.  You will explore the various filtering options using AutoFilter.  You will be able to create standard spreadsheets by creating your own Styles and Templates. Take the Quick Quiz

Advanced (Level 1) This course is designed for users who need to use Excel to produce reports and data summaries.  You will learn how to extract filtered data into a new dataset.  It shows you how to manipulate large amounts of data to produce meaningful reports and charts using Pivot Tables and Pivot Charts as well as automating procedures using Macros. You will be able to create a data model and create scenarios using Goalseek and Solver.  Take the Quick Quiz

Advanced (Level 2)  This course is for users who want to automate their spreadsheets using recorded macros. In this course we explore the options for storing recorded macros.  You will learn how to use Relative and Absolute referencing when recording. You will learn how to add buttons to run your macros. You will gain confidence in editing Visual Basic Code.  You will be able to create your own Excel Functions and distribute them to your colleagues.  Take the Quick Quiz​​​​​​​

Scheduled Courses for Microsoft Excel are run in Hertfordshire, They are 1 day 10:00am - 2:30pm.  The cost for most courses is £150 per delegate, although there are reductions available for multiple delegates.  Excel Advanced Level 2 is £180 per delegate.  All courses include lunch and a memory stick containing course documentation and exercises. View a schedule of upcoming dates.