Online Training

Excel Intermediate for Government

Organise, analyse, and visualise data easily

4 and 11 February 2025: 09:00am - 12:30pm AEDT

4 and 11 August 2025: 1:30pm - 5:00pm AEST

Next intake: 4 and 11 February 2025: 09:00am - 12:30pm AEDT | 4 and 11 August 2025: 1:30pm - 5:00pm AEST

Overview

If you’re someone who already works comfortably with Excel but wants to enhance your skills and take your data management, analysis, and visualisation to the next level, then you’ve come to the right place.  

In today’s fast-paced world, data is a critical asset that organisations must leverage to gain a competitive advantage. However, managing and analysing large amounts of data can be overwhelming, time-consuming, and prone to errors. That’s where Excel comes in to allow you to work with data more efficiently and effectively. This course is designed to help you unlock the full potential of Excel by exploring advanced features and functionalities that will enable you to manage and analyse data like a pro. This course will cover a broad range of functions such as cleaning and transforming data, conditional formatting, conditional logic, VLOOKUP, XLOOKUP, pivot tables, and pivot charts with slicers. 

By the end of the course, you’ll be equipped with the skills and knowledge to automate routine tasks, perform complex calculations quickly and accurately, and create clear and concise reports that communicate your findings effectively. These skills are essential for anyone working with data in a government setting, where accuracy, efficiency, and effective communication are critical for making informed decisions that drive results. 

So, whether you’re an analyst, finance manager, procurement specialist, auditor, project manager, or any other professional who works with data in a government context, this course is for you. We’re excited to help you take your Excel skills to the next level and enable you to achieve your goals more efficiently and effectively. Let’s get started! 

Learning Outcomes

Build upon your base knowledge of Excel and dive deeper into some of the more advanced functionality in Microsoft Excel
Use conditional formatting and the IF function to identify trends and anomalies and perform conditional logic
Discover the most efficient and effective ways to clean and transform your data
Use VLOOKUP to link and categorise data
Analyse data and create dashboards using pivot tables, pivot charts and slicers

Online Training

Excel Intermediate for Government


Session details

  • Make sense of complex data sets quickly and efficiently 
  • Manage and analyse large amounts of data by leveraging advanced Excel features like sorting, filtering, and pivot tables  
  • Understand how to automate routine tasks and perform complex calculations quickly and accurately 
  • Learn how to use Excel’s powerful tools for data analysis, visualisation, and reporting 
  • Tools, tips and tricks to create clear and concise reports that will enable you will be able to communicate your findings more effectively and make informed decisions  
View course modules

Level: Intermediate

Some familiarity with topic is recommended

Key Sessions

  • Calculations for joining and splitting text  
  • Changing case and removing unwanted characters  
  • Performing calculations with dates  

  • Identifying trends, thresholds, anomalies, and specific ranges with conditional formatting  
  • Managing and modifying conditional formats  
  • Interactive conditional formats using formulas  

  • Using the IF function to perform conditional logic  
  • Nested IFs  
  • AND and OR functions  

  • Creating and customising tables  
  • Sorting and Filtering table data  
  • Automating processes with tables  

  • VLOOKUP range lookup  
  • VLOOKUP exact match  
  • XLOOKUP (version permitting)  

  • Creating and modifying pivot tables  
  • Adjusting the calculation methods  
  • Sorting, filtering, and grouping in pivots  
  • Formatting Pivots  
  • Creating and customising pivot charts  
  • Dashboards and slicers  

Meet Your Facilitator

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

Learn some of the best practices from Nicky on her interview as she discusses how to capitalise and optimise your data entry, reporting, and visualisation.

What your peers had to say

“Great content presented at a great pace in a clear manner.”

“Gaining an understanding of all of the various functions of Excel.”

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Extra Early Bird

Ends 22 Nov

$A 495

per person + tax $400 saving

 

Early Bird

Ends 17 Jan

$A 695

per person + tax $200 saving

 

Regular

Ends 3 Feb

$A 895

per person + tax

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