This course is an advanced course and is aimed at those who use Excel regularly. It covers features and functions that tackle issues arising from complex spreadsheet models. As such, delegates will need to have the experience to provide their own context to understand the need to apply these features. This course will also benefit those people who are already using VBA to achieve some of these tasks.
Drawing on the wealth of experience from experienced spreadsheet solution developers, by the end of this course you will be able to apply the tried and tested techniques to combine Excel functions and features to produce dynamic dashboards and fully automated reporting without the need for macros/VBA. The course does however provide the essential techniques for those who need to add considerable power to their VBA solutions. Throughout the course the group will develop a model to consolidate all features from this (and lower level) courses. Features and techniques from the model can be applied to a broad range of solutions and considers the importance of design to ensure the model is flexible, accurate, easy to maintain and scalable.
Delegates should be totally comfortable with the content of the ‘Advanced’ course and have no problems using VLookups or the IF function. They will often be data analysts who use Excel as a significant part of their job. Those who have attended the Advanced course should apply and consolidate what they have learnt before attending this course.
Courses are delivered in 2010, 2013, 2016, 2019 & O365
Training can be delivered in either of the following ways:
Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.
Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.
Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.
All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.
Short on time, but still want to boost staff performance?
Book a Sprint Session!
Each Sprint Session follows a 90-minute format for ultra-focused team learning.
Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.