Program Outline
About this Program
This advanced Excel course is designed to take intermediate users to power-user level by introducing higher-level tools, functions and automation capabilities that improve productivity and data management.
Participants build on existing Excel knowledge while exploring advanced functionality including XLOOKUP, enhanced formula techniques, automation tools and advanced data handling methods. The course also introduces macro recording, editing and VBA fundamentals, providing insight into event-driven programming within Excel.
Like all People Tank programs, the course is practical, interactive and designed for immediate workplace application, with opportunities for hands-on learning, discussion and real-world practice throughout.
Program Topics
• Advanced XLOOKUP formulas and data lookup techniques
• Advanced text functions and text manipulation in Excel
• Data cleaning and text-to-columns tools
• Advanced conditional formatting and data highlighting
• Advanced VLOOKUP and lookup troubleshooting
• Database functions for advanced Excel reporting
• Information and error-checking functions in Excel
• Importing, cleansing and fixing spreadsheet data
• Date and time calculations in Excel
• Advanced SUMIF, COUNTIF and calculation functions
• Interactive spreadsheet controls and form tools
• Excel macros and VBA fundamentals
• Automating tasks with Excel macros
• Advanced Excel formulas, functions and automation
• Advanced Excel data analysis and reporting skills.
Delivery Options
• 1x day
• Customisation and timeframes can be adjusted according to each group.
Audience
• Suitable for professionals, leaders and teams seeking practical, workplace-focused learning that builds capability, confidence and performance.
Key Outcomes
• Understand the full functionality of the XLOOKUP function, and how to apply its in-build tools to perform reverse-order searches, error-message generation and wildcard searches
• Learn how to automate your spreadsheets using macros and gain an understanding of VBA code and event-driven programming
• Understand how to manipulate complex text strings to extract valuable text-string subsets using a variety of text functions
• You’ll learn advanced conditional formatting techniques, including highlighting entire data rows
• Learn to create dashboard-type interfaces using Controls, including spin buttons, list boxes, check boxes and scroll bars.
Why Choose Us?
People Tank partners with organisations to design human-centred, future-ready leadership capability that drives real behavioural change.
Who we partner with
get in touch
Get More from Microsoft 365
Connect with People Tank to explore Microsoft 365 training solutions that help your people work smarter, collaborate effectively, and make the most of the tools they use every day.
Prefer to chat?
Book a quick conversation with our team to discuss your organisation’s AI needs.