Call us today: 0800 028 3045
Microsoft Excel Training Courses
Microsoft Excel – Pivot Table Specialist Course
Our Excel Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who are keen to learn more about the use of Pivot Tables to analyse and present data. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas.
£199.00
1 day
Microsoft Excel Business Intelligence And Dashboards Course
Our Excel Business Intelligence and Dashboards course is designed for existing users of Excel who can build simple Excel spreadsheets and now want to develop their skills in using Excel for better business intelligence and reporting. The course includes dealing with imports of data, analysing data using Pivot Tables and getting the most out of the extensive graphing features in Excel. It also looks at combining information into easy to use dashboards to show key trends and relationships without the need for high levels of detail.
£398.00
2 days
Microsoft Excel Course – Module 1 Essentials
Our Excel Module 1 - Essentials course introduces the basic features of Excel and focuses on creating spreadsheets, adding different types of formula, formatting and printing. You should be competent in using a PC for general business use. No previous experience of Excel is required.
£185.00
1 day
Microsoft Excel Course – Module 2 Gathering and Presenting Data
Our Excel Module 2 - Gathering and Presenting Data course looks at techniques for managing data more effectively. It is designed for existing users of Excel who have attended Module 1 - Essentials or have equivalent knowledge. You should be confident in creating and manipulating Excel spreadsheets and creating calculations before attending.
£185.00
1 day
Microsoft Excel Course – Module 3 Data Analysis
Our Excel Module 3 - Data Analysis course is ideal for those who would like to learn more about data analysis techniques in Excel. It is designed for experienced users of Excel. You should be confident in creating and editing worksheets and be able to write basic formulas.
£185.00
1 day
Microsoft Excel Course – Module 4 Advanced Formulas And Functions
Our Excel Module 4 - Advanced Formulas and Functions course is designed for experienced users of Excel who want to develop their skills in writing formulas and using advanced Excel functions and techniques. You should be confident using Excel and should be able to write basic formulas and functions.
£398.00
2 days
Microsoft Excel Formulas and Functions – Essentials Course
Our Excel Formulas and Functions - Essentials course shows you how to construct basic formulas and functions in Excel. It is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.
£185.00
1 day
NEW! Microsoft Excel Functions – INDEX And MATCH Online Course
Do you find that the VLOOKUP function is not quite dynamic enough? Do you want to be able to search an entire data table without the need to move look up references to the left hand column of your table? Do you want to be able to search through multiple tables rather than just one? Then INDEX and MATCH might just be what you need.
£25.00
1 hour
NEW! Microsoft Excel Look Up Functions – LOOKUP, VLOOKUP, HLOOKUP Online Course
Have you started working with more data and find you can’t cross reference data easily? Have you seen others using the VLOOKUP function but have no idea how it works, or perhaps you have used it a bit but need a refresher? Then this 1 hour online trainer-led session is for you.
£25.00
1 hour
Microsoft Excel Macros Specialist Course
Our Excel Macros Specialist course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.
£199.00
1 day
NEW! Microsoft Excel – Data Validation Online Course
Ever come across drop down lists in spreadsheets? Ever wondered how you can control what people enter into worksheets you send out so that you get consistency of data? Then this 1 hour online trainer-led session is for you.
£25.00
1 hour
NEW! Microsoft Excel – Excel Pivot Tables Online Course
Do you work with large amounts of data that needs to be analysed quickly? Are you constantly being asked to change the way your data is presented? Are you currently using autofilter and copy and paste to extract data from lists? In this 1 hour online session you will see how Pivot tables are able to solve all those problems for you.
£25.00
1 hour
