Microsoft Office Access – supporting your business development
John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.
Read Full TestimonialAs a result of this popularity, knowledge of how Excel works is something many employers look for. Therefore having a good understanding of how the program works is definitely a bonus. Learning how to effectively use Excel can improve your employment prospects as well as enabling you to improve your productivity through learning shortcuts and formulae to use daily.
If you come on one of our Excel training courses with us, you will benefit from the expertise of top quality trainers who will help guide you in developing your Excel knowledge.
The basic Excel training course begins with the building blocks for learning the basics within the package. This course covers how to create function and symbol based formulas as well as how to set up your ‘spreadsheets’. It covers the popular SUM formula alongside some other basic formulas too.
The intermediate Excel training course builds on the basic level course. During this course you will be guided through some more advanced features of the program, developing your existing knowledge further. This course covers creating charts, IF statements, sorting and filtering, multi sheet linking and more.
Going for the advanced Excel training course will allow you to develop your knowledge even more and enable you to have a good understanding of some complex features of the program. In this advanced course you will look at macros, pivot tables, VLOOKUPs, data validation and more in depth functions.
Finally, there are two master class Excel courses available. The master class Excel bronze course steers you through more advanced pivot tables and macros. It also covers some What If Analysis functions like Data Tables and Scenarios, and the INDEX, MATCH, and INDIRECT functions.
Then the master class Excel silver course follows on from the bronze course. This course covers a half day introduction to VBA programming alongside advanced data validation, array work, multi sheet pivot tables and some other lesser known but useful functions.