Excel Dimensions’ professional MS Excel consultants provide consulting services to businesses, corporations and individuals throughout Australia.
The customisation of courseware is cost-free, and ensures that time spent in training will maximise relevance. During the training session we’ll use software such as Microsoft Teams or GoToMeeting (or if you prefer, we can use sharing software used by your organisation).It’s the next-best thing to the facilitator being in the same room as your team.Get a FREE 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.