Microsoft Excel is the leading spreadsheet program which provides users with the tools to manage small or large volumes of data and utilise built-in features to create calculations, produce charts, sort and filter data, and analyse information in a meaningful way. Let us show you the tools which will save you time and make your use of Excel more efficient. Microsoft Excel provides an abundance of tools which provide endless possibilities for data analysis and review.
Our Microsoft Excel Training courses comprise of a 3-level study program: introduction, intermediate and advanced. Each study level is generally conducted over 1 day, however, can be customised to suit the needs of the participants.
Training is available for Excel versions 2000-2016.
Our courses include skills analysis for each participant along with unlimited ongoing post course support via email.
Microsoft Excel Introduction
This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting. Participants will explore features including the use of cell ranges, create a formula and calculation from scratch, various formatting techniques, sorting and filtering, and create effective charts.
Microsoft Excel Intermediate
This course aims to expand participant’s knowledge and demonstrate how to create more productive workbooks. It covers custom number formats, series and fill techniques, conditional formatting, sparklines, absolute and relative cell references, named ranges, intermediate formulas including IF, IFERROR, LOOKUP and more, advanced charting features and data manipulation tools like Tables.
Microsoft Excel Advanced
This course aims to extend participant’s skills and knowledge to protect worksheet data, perform advanced data operations using summarising, data consolidation, filters, PivotTable techniques, macros and much more.
Click the link below to download a preview of the course content.
For a full course outline please Request this Outline.