Excel Advanced for Government

Wednesday, 4 October – 9:00 AM – 12:20 PM & Thursday, 5 October 2023 – 9:00 AM – 12:20 PM AEDT | Online

Training Overview

Unleash the Power of Advanced Excel: Elevate Your Skills for Government Professionals

Supercharge your Excel skills with our Advanced Excel for Government Training! Designed for intermediate Excel users, this comprehensive course enhances your automation, problem-solving, and data analysis abilities. Master named ranges, advanced data validation, aggregation functions, and lookup functions. Automate tasks with macros, explore VBA programming, and harness the transformative power of Power Query and Power Pivot. Don’t miss this exclusive opportunity to become an Excel expert in a government context!

Elevate your Excel skills with our Advanced Excel for Government Training! This course goes beyond the basics, focusing on advanced automation, problem-solving, and data analysis techniques. Master named ranges, data validation, aggregation functions, lookup functions, macros, VBA, Power Query, and Power Pivot. Don’t miss out on becoming an Excel champion in a government setting!

Take your Excel skills to the next level with our Advanced Excel for Government Training! This course empowers intermediate users with advanced automation, problem-solving, and data analysis techniques. Discover named ranges, advanced data validation, aggregation functions, lookup functions, macros, VBA, Power Query, and Power Pivot. Become an Excel expert and excel in a government context. Secure your spot in this exclusive training now!

Who Should Attend

This course is designed for heads, directors, assistant directors, managers, and team leaders in charged with driving transformation change in all three levels of government including:


Project, Program and Operations

Data Scientists

Learning Outcomes

Master advanced Excel features like named ranges, data validation, and aggregation functions to effectively manage and analyze large datasets with accuracy and efficiency.

Streamline your workflow, save time, and increase productivity by learning how to automate tasks and calculations using macros and VBA, eliminating manual data entry and repetitive processes.

Learn advanced data analysis techniques using functions like lookup and Power Pivot, enabling you to retrieve specific information, identify trends, patterns, and anomalies, and make informed decisions.

Acquire skills in creating clear and concise reports, presenting data visually with interactive dashboards, and conveying insights effectively, improving communication and understanding among stakeholders.

Meet Your Facilitator

Nicky Bull
IT Trainer and Courseware Developer

Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs. She lectures accounting students at Macquarie University and was the lead content designer for the hugely popular Excel Skills for Business course that received the Coursera Outstanding Educator Award for Student Transformation in 2018.

Nicky is passionate about learning and enabling people to use technology confidently and effectively in their workplace. She holds a BSc Hons in Computer Science (University of the Witwatersrand, South Africa), a BA in English Literature (University of the Witwatersrand, South Africa), and a Postgraduate Certificate in Education (University of Hertfordshire, U.K.)

Key Sessions

Day 1: Module 1Day 2: Module 2
  • Named Ranges
    • Using the Name Box 
    • Create from Selection 
    • Name Manager and using named ranges in calculations 
  • Data Validation
    • Add simple validation 
    • Add validation that uses calculations 
    • Create automated drop-down lists 
  • Aggregation Functions
    • Summarising data with COUNTIFS, SUMIFS & AVERAGIFS  
    • Aggregating with multiple criteria
  • Macros and VBA
    • Understand macros and macro security 
    • Record and run macros 
    • Edit macros and introduction to VBA 
  • Advanced Lookup Functions 
    • VLOOKUP (recap) 
    • MATCH 
    • INDEX 
    • INDIRECT & XLOOKUP (time & version permitting) 
  • Power Query 
    • What is Power Query and how to get data from other spreadsheets  
    • Create queries that pull data from a folder 
    • Perform simple transformations like adding and splitting columns  
    • Perform more complex transformations like unpivoting data 
  • Power Pivot 
    • Understand Power Pivot and Enable the Power Pivot Add In 
    • Work with the Data Model and Define Relationships 
    • Create PivotTables from the Data Model 
    • Visualise data with Pivot Charts and Cube Functions 
    • Create interactive dashboards with Slicers 


Final Price


per person + GST

Customised in-house options available for teams

Interested in any of our online trainings?

You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.

Interested In Learning More?

The Data Management & Analytics Community provides a hub for public sector professionals from around the globe to learn, network, collaborate, benchmark, and share best practices with their peers. Become a member today for free and gain access to:

  • Live chats and digital forums
  • Global content library
  • Priority event registration
  • Networking opportunities with peers
  • Complimentary access to exclusive events and insights