Excel Training: Advanced Techniques and Tips
To build robust and scalable models that can be changed over time requires using robust development techniques. Although some of these may be beyond the scope of typical users, many of the fundamental requirements can be easily learned and the application of these can greatly improve productivity and reliability.
ExcelCodex offers bespoke in-house Excel training where we will help users to enhance the models they are using and working on with real life application of techniques.
We will cover dynamic referencing, use of defined named ranges, conditional & logic statements, use of date and text functions for dynamic labeling, intersection and structured layouts & key dos and don’ts to name a few. Most of these are easy to learn but users don’t know about them and once they do, become an integral part of their work going forward.
Training is driven by the users’ inputs on the day and so will not follow a set format although we work from a list of topics to cover.
To reserve a course – Contact Us