Online Training

Excel Intermediate for Government

Enhancing data management to improve efficiencies and enable better decision making in government.

1 & 2 July 2024

9:00 AM - 12:30 PM AEST

Next intake: 1 & 2 July 2024 | 9:00 AM - 12:30 PM AEST

Overview

For those already confident with Excel but eager to boost their data management, analysis, and visualisation skills, this course is tailored just for you. In today’s fast-paced world, data is a vital asset for organisations. Excel is a powerful tool for efficiently managing and analysing large datasets, saving time and minimizing errors. Our course dives into advanced Excel features like data cleansing, conditional formatting, VLOOKUP, XLOOKUP, pivot tables, and pivot charts with slicers.

By the course’s conclusion, you’ll be automating tasks, performing accurate calculations, and crafting clear reports – essential for decision-making in government settings. Whether you’re an analyst, finance manager, or procurement specialist, our course will empower you to excel in your role.

Let’s kickstart your journey to Excel mastery!

Learning Outcomes

Build upon your base knowledge of Excel and dive deeper into some of the more advanced functionality in Microsoft Exce
Use VLOOKUP to link and categorise dat
Discover the most efficient and effective ways to clean and transform your data
Analyse data and create dashboards using pivot tables, pivot charts and slicers.

Online Training

Excel Intermediate for Government


Session details

  • Effectively manage and analyse large amounts of data by leveraging advanced Excel features
  • 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
View course modules

Level: Intermediate

Some familiarity with topic is recommended

or

Get this course using subscription credits. Learn more

This course requires 1 credit.

Key Sessions

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

  • Identifying trends, thresholds, anomalies, and specificranges 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 an energetic corporate trainer and consultant with a diverse background. With 15 years of commercial experience as both a computer programmer and analyst, Nicky brings a wealth of knowledge to her role. She has spent over a decade designing and delivering educational programs, catering to various learning needs.

Currently, Nicky holds a position as a lecturer for accounting students at Macquarie University. She is also recognized for her significant contribution as the lead content designer of the highly acclaimed Excel Skills for Business course. This course earned the prestigious Coursera Outstanding Educator Award for Student Transformation in 2018.

Driven by a passion for learning, Nicky is dedicated to empowering individuals to utilize technology with confidence and effectiveness in their professional environments. Her academic credentials include a Bachelor of Science with Honours in Computer Science from the University of the Witwatersrand in South Africa, a Bachelor of Arts in English Literature from the same institution, and a Postgraduate Certificate in Education from the University of Hertfordshire in the United Kingdom.

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Early Bird

Ends 17 May

$A 995

per person + tax $200 saving

 

Regular

Ends 28 Jun

$A 1195

per person + tax

Use training credits

Subscription

Pay today using:

1 credit

Subscribe & save with pre-purchased credit. See more

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

Subscription options

Achieve great value with our customised subscription plans.

Become a member today and upgrade to Premium to access training credits and much more...

Starter

10%

discount off course prices

Purchase at least 3 training credits*

Requires commitment to promote Public Sector Network courses internally


  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Bronze

15%

discount off course prices

Purchase 6-15 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Silver

20%

discount off course prices

Purchase 16-30 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Gold

25%

discount off course prices

Purchase 31-50 training credits*


  • Dedicated account manager
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

Enterprise

X%

to be discussed

Tailor-made training programs with flexible training credits shareable amongst your team across many courses


  • Learning & development consultant
  • Dedicated account manager
  • In-house training options
  • Premium report
  • Access to private discussion groups to connect & collaborate with training peers
  • Connect & collaborate within public sector communities
  • Membership enables access to exclusive case studies, whitepapers & reports

* Most full-day Public Sector Network courses (which may be split over two days) will require one credit, which is valued at approximately $US595 or $A795, plus tax

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