Excel Training Courses

All aspects of working with a Pivot Table are covered to make the most of this powerful feature. 

Data Modelling is the key to data extraction and delegates are shown how to use PowerQuery as a data discovery and query tool to clean, shape and transform data.  Learn how to import data from a variety of sources or append multiple files with ease to get the data in a format for further analysis or to Pivot the information using conventional Pivot Tables or Power Pivot Tools.  

Power Pivot is used to model data and define calculations. Where previously you had limited ability to create calculated fields and items, learn how to create a whole range calculations  to model your data using the powerful Dax formula tool.

This course is designed for either new users of Excel, users who have been using the system to input data and print worksheets or users wishing to understand and create formulas and functions. 

The prime aim of this course is to ensure users are equipped with the necessary skills to create a professional looking spreadsheet. To further that aim from late morning onwards the delegate will learn how to use functions and formulas to create or amend spreadsheets.

This course shows how to link worksheets together and then looks at the functionality within Excel that can help the user to extract data from existing spreadsheets. Data security is covered with the user being shown how to limit the data being input into cells and then to protect the cells, worksheet and workbook. A comprehensive look at creating, modifying and troubleshooting charts is also covered.

This course builds upon the functions and functionality covered in the previous courses. More complex functions are introduced such as If, Vlookup, Sumifs and Countifs as well as then moving on to nested IF functions. Data analysis techniques, such as Pivot Tables, scenarios and macros are also introduced in this comprehensive and in-depth course.

This course builds upon the functions introduced in the previous courses taking elements of the functions to a higher level and introducing many new functions. The If function is expanded to include AND and OR elements and the use of nested functions with error capture. This course gives the user a good overview of the many different functions available and the way many of them work together to produce powerful manipulative spreadsheets. Over 50 functions are used during this course.

Delegates will use both the macro recorder and the VBA screen to automate and speed up everyday tasks. The user will use combo boxes, drop down boxes and option buttons to update fields based on input criteria entered in other fields and use macros to automate processes such as copying data and printing invoices. Users will then write and amend the visual basic code to manipulate data imported into Excel and learn how to create user forms and custom functions.