Online Training

Excel Advanced for Government

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

19 & 20 August 2024

9:00 AM to 12:30 PM AEST

Next intake: 19 & 20 August 2024 | 9:00 AM to 12:30 PM AEST

Overview

Our Advanced Excel for Government Training empowers individuals proficient in intermediate Excel features to excel in automation, problem-solving, and data analysis. Gain mastery over named ranges, advanced data validation, and aggregation functions. Explore advanced lookup functions like VLOOKUP, MATCH, INDEX, and more. Learn to automate tasks with macros and delve into VBA programming. Discover the transformative capabilities of Power Query and Power Pivot for data transformation, integration, and dynamic dashboards. Elevate your Excel skills and become an Excel champion in a government setting. Secure your spot in this exclusive training now!

Who Should Attend?

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

Learning Outcomes

Advanced Data Management: Effectively manage and analyse large amounts of data using advanced Excel features such as named ranges, data validation, and aggregation functions. Gain the skills to organise and clean data efficiently, ensuring accuracy and integrity.
Automation and Efficiency: Learn how to automate routine tasks and calculations using macros and VBA. Streamline workflow, save time, and increase productivity by eliminating manual data entry and repetitive processes.
Advanced Data Analysis and Visualisation: Perform sophisticated data analysis using advanced lookup functions and Power Pivot. Retrieve specific information from complex datasets, create relationships between tables, and visualise data using Pivot Charts and Cube Functions. Participants will develop the ability to identify trends, patterns, and anomalies, leading to more informed decision-making.
Effective Reporting and Dashboards: Create clear and concise reports that effectively communicate findings. Learn how to present data visually using interactive dashboards, slicers, and advanced visualisation techniques. This will enable you to convey insights and trends in a visually compelling manner, facilitating better communication and understanding among stakeholders.

Online Training

Excel Advanced for Government

Session details

  • Elevate your Excel skills with advanced features like named ranges, data validation, and aggregation functions.
  • Dive deep into the world of advanced lookup functions, macros, and VBA programming for efficient automation.
  • Master Power Query and Power Pivot for transformative data transformation, integration, and dynamic dashboards.
View course modules

Level: Advanced

Familiarity with the topic is required

Register Now Pricing options

Key Sessions

• Using the Name Box
• Create from Selection
• Name Manager and using named ranges in calculations

• Add simple validation
• Add validation that uses calculations
• Create automated drop-down lists

• Summarising data with COUNTIFS, SUMIFS & AVERAGIFS
• Aggregating with multiple criteria

• Understand macros and macro security
• Record and run macros
• Edit macros and introduction to VBA

• VLOOKUP (recap)
• MATCH
• INDEX
• INDIRECT & XLOOKUP (time & version permitting)

• 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

• 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

View Training Guide

Meet Your Facilitator

Nicky Bull

Nicky Bull

Corporate Consultant | Blue Chameleon

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.).

Register Today

Join this training for professionals working within the Public Sector

Additional discounts are available for group registrations of 10 or more. For group or payment enquiries or custom training solutions, please contact [email protected]

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.

Enquire here for more information

Can't see what you need?

Download our training catalogue to review all available topics

Download full catalogue

Get in Touch

Empowering the public sector with meaningful actionable advice to help solve the problems worth solving. If you would like to do an in-house course, please get in touch.

Request the training catalogue

To receive a PDF copy of the Public Sector Academy training catalogue, please submit the details below:

By submitting your email address, you are consenting to Public Sector Network potentially reaching out to you about the academy offering.

Achieve great value with our customised subscription plans