permanent and temporary recruitment
learning and development solutions
From a beginner with little or no knowledge, to the more advanced techniques, these courses are designed to allow for every capability of each individual.
The course will focus on the capability of Excel to handle very large amounts of data which can be analysed, manipulated and then presented into professional looking reports.
Participants will cover the essential skills required to work with Excel. During the day we will enter and edit data, enter formulas and functions, save, open and create workbooks, manipulate cell ranges, format sheet appearances, print, and create professional charts and reports.
Participants will explore advanced Formulae and Function techniques, including understanding arguments and the use of Array Functions.
Participants will take advantage of some of the more complex Excel features including working with multiple sheets, linking data across files, Auto Filtering, Subtotals and the creation and protection of templates.
In this course we will learn techniques to speed up navigation and use utilities to analyse large spreadsheet files. We will also teach you to how to work with linked files and templates so that reports are both professional and in keeping with the corporate image.
This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. You will learn how to write object-oriented programs and how to create loops and implement error-handling.