Enlightened Training: Microsoft Excel

This course concentrates on developing your existing knowledge of Excel and includes working with more advanced formulas and functions. You will learn how to get Excel to make decisions using IF functions and conditional formatting. You'll also learn how to create templates for commonly used worksheets and protect data using the security features. This course will also enable you to create, build and customise graphs including plotting trend lines, and use Pivot Tables to help analyse data. You need to be using Excel regularly, including writing your own formulas, in order to get the most out of this course. For Course Outline click here.

This course focuses on advanced methods of data list management using Excel spreadsheets. You will learn how to summarise large workbooks, use data analysis tools to forecast figures based on a range of scenarios and use data consolidation to help you present your information. You must be using Excel regularly, including extracting data with formulas and pivot tables, in order to get the most from this course. For Course Outline click here.

This course is for you if you are an Advanced Excel user who has never used VBA and who would like to learn how to automate repetitive tasks. This course moves at a fast pace and is an introduction to the basics of editing macros. By the end of the course, you will be able to automate simple, repetitive excel tasks to speed up your work, and have a basic understanding of how to tackle automating more complex tasks. For Course Outline click here.

This course is designed for those who use Excel almost exclusively for data analysis. You will learn how to access and use the data analysis tools available in Excel to assist you with reporting and presenting your data. Advanced chart building is the cornerstone of this course, along with creating Pivot Tables, working with Goal Seek and Scenarios, creating and working with data tables and consolidation of data across multiple sheets. You need to be using Excel on a daily basis and be confident when creating and editing formulas and figures in an Excel spreadsheet. For Course Outline click here.

This course focuses on refreshing your key skills in Excel to allow quick progression to the Intermediate Excel course. This is most suitable for those who have maybe not used Excel for a while, or who wish to refresh their editing and calculation skills in Excel before moving onto the Intermediate Excel course. This is course is not for you if you have never used Excel before. For Course Outline click here.