Program Outline
About this Program
This practical Excel training program is designed to help participants progress from beginner users to highly productive Excel users. The course focuses on advanced tools and techniques that improve efficiency, accuracy and confidence when working with large data sets.
Participants explore highly requested functions including LOOKUP formulas, INDEX/MATCH, IF functions and named ranges, while also developing advanced database management and data analysis skills to extract insights more effectively.
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 Excel formulas and cell referencing
• Absolute, mixed and named ranges in Excel
• Dynamic named ranges and Excel tables
• VLOOKUP, INDEX MATCH and lookup functions
• IF statements and logical functions in Excel
• Error handling and advanced formula techniques
• PivotTables and Pivot Charts for data analysis
• Data filtering, slicers and timelines
• Advanced Excel reporting and comparative calculations
• Grouping, subtotals and data summarisation
• Data validation and dropdown lists
• Custom number and text formatting in Excel
• Excel tables, duplicate removal and structured data
• Advanced filtering and extracting unique values
• Intermediate to advanced Excel data management 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
• Learn to build well-structured LOOKUP, CHOOSE and INDEX/MATCH functions, so they’re easy to create, deploy and modify
• Understand how to create well-designed IF functions, then building on this to create “nested” functions (functions within functions)
• Understand how to use named ranges to turn large datasets into easily controllable areas, making building complex formulas easier
• Move past basic filtering to create high-level filtering structures that automatically calculate, as well as perform both AND and OR-related functions
• Learn to build and manipulate PivotTables quickly, including using Slicers to apply filter conditions to multiple pivot tables at the same time.
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.