Microsoft Excel Training
Excel combines an extensive set of spreadsheet tools with a powerful macro language (VBA), capable not only of automating complex and time-consuming processes but also of providing an environment in which to build complete applications.
We provide graded Excel training through our range of standard courses as well as options with fully-tailored content to meet your individual requirements. All aspects of Excel are covered.
Excel Macros and VBA
If you are interested in getting started with macros we have an Excel VBA course which will provide you with a sound understanding of how to use the Visual Basic Environment to create, test and modify macros using VBA. This is a great introduction to one of Excel's most under-used features.
At a basic level, Excel provides a macro recorder which will create the macros for you but the chances are that, as soon as you discover what they can do, you will want to use them more and more.
You don't need to be an Excel expert to work with macros although you should have a good knowledge of Excel and be prepared to learn some programming.
We like to work on real projects with our clients and an Excel Workshop could be the ideal way for you to build up your Excel skills at the same time as generating useful spreadsheets for your business. Your workshop can be based around your own files and data so that you create an end product of immediate benefit. Here are some suggestions for topics which might typically be included in a half day or full day workshop.
- Charts and Graphs
- Pivot Tables
- Importing and Exporting Data
- Macros and VBA
- Data Analysis and What If Tools
Remember that the content can be fully customised and if you need help to decide what is most appropriate we can provide initial advice or consultancy.
Costs are based on a daily consultancy rate, together with small incremental costs per delegate.