Microsoft Excel

Courses are offered from Beginners to Advanced or can be tailored to individual needs and requirements.

The adjacent chart shows the progression routes to most effectively learn Microsoft Excel.

Training needs analysis are available for download if you want to gauge the most effective starting point for expanding your knowledge of this package.

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,