Wherever, whenever, you can learn to use Excel with our live online training. Our instructor-led one-on-one sessions are designed to address topics that will deliver a real learning outcome for the participant, rather than a generic learning experience.Get Your Quote
These instructor-led one-on-one sessions are facilitated by a senior Microsoft Excel trainer, and are designed to return real value on your training investment. Working together we’ll put together the topics for an on-line training course based on your requirements. During the training session we’ll log onto your computer using Microsoft Teams or GoToMeeting, or if you prefer we can use sharing software you may have. We can then both control the mouse. It’s as though our Excel trainer is sitting in the room next to you.Training needs analysis
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.