Event Description
Take your Excel skills to the next level and unlock the full potential of your data. This practical, hands-on programme is designed to help professionals confidently manipulate, analyse, and interpret data using advanced Excel tools and techniques.
Delivered over two interactive half-day sessions, this workshop explores advanced functions, data analysis tools, and introduces macros and Visual Basic for Applications (VBA). Facilitated by Accredited Microsoft Master Instructor Louise Friel, participants will gain the confidence to work more efficiently and eliminate the need to rely on external tutorials for everyday Excel challenges.
Key takeaways:
- Use advanced functions including IF, AND, OR and nested formulas
- Analyse data using lookups, subtotals, and pivot tables
- Build pivot charts and work with multidimensional data
- Apply forecasting tools such as Goal Seek, Solver and scenarios
- Automate tasks using macros and gain an introduction to VBA
Who should attend?
This programme is ideal for professionals who already have a working knowledge of Excel and want to enhance their data analysis skills, improve efficiency, and gain confidence using more advanced features within the software.
Register for Event