Our Excel training courses can be delivered on-site at your premises in Ballarat (or online) and will teach you how to use this software to its full potential, saving you time & money.
Not only are our courses the most comprehensive and in-depth training programs in Australia, we also customise the content to include those areas of Excel that will maximise your productivity “back at the desk”. The majority of training courses we conduct Australia-wide are customised to our client’s requirements, and it’s cost-free.
Perfect for any beginner and covers the basics of using Microsoft Excel. It’s designed to get you up and running quickly, covering a solid grounding in the basics of calculations and database filtering and sorting, as well as tips and tricks to slash the time it’ll take you to perform Excel tasks.Course Details
Address the toolsets that take participants from beginner to high-productivity user. The course covers the 2 most requested areas after the beginners level – the first looks at LOOKUP and IF functionality, and how to work with large data ranges effectively through named ranges.
The second area looks at advanced database manipulation techniques, and takes a deep dive into effective methods of extracting meaning from Excel databases quickly.
Designed to introduce higher-level Excel tool-set functionality and take intermediate-level users to the power-user level. It introduces a host of new Excel tools and functions, and also expands on the functionality of intermediate-level tools, adding powerful complimentary functions make Excel jump.
In addition, we look at the macro/VBA side of Excel, when we not only record, run and modify macros, but introduce participants to the principles of event-driven programming.
Visual Basic for Applications (VBA) take off where the standard Excel tool-set end. It’s more than spreadsheet automation; it’s about introducing functionality through programming solutions that’ll expand your productivity.
The skills and knowledge you’ll acquire in this course will be the starting point in learning to create real-life working VBA applications within Excel.