Online Training

Excel Advanced for Government

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

14 & 16 May 2024

9:00am – 12:30pm AEST

Next intake: 14 & 16 May 2024 | 9:00am – 12:30pm AEST

Overview

Elevate your Excel skills with our Advanced Excel for Government Training! Tailored for intermediate users, this course advances your proficiency in automation, problem-solving, and data analysis. Master named ranges, advanced data validation, aggregation functions, and advanced lookup functions. Automate tasks using macros and get an introduction to VBA programming. Discover the transformative capabilities of Power Query and Power Pivot. Don’t miss this exclusive opportunity to excel in a government context!

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

Master Excel's advanced features for precise data management and analysis of large datasets.
Boost efficiency and productivity by automating tasks and calculations with macros and VBA.
Explore advanced data analysis using lookup functions and Power Pivot for informed decision-making.
Develop expertise in creating clear reports and visualising data through interactive dashboards.

Online Training

Excel Advanced for Government


Session details

  • Master advanced Excel features
  • Enhance efficiency and productivity
  • Excel in data analysis and reporting
View course modules

Level: Advanced

Familiarity with the topic is required

or

Get this course using subscription credits. Learn more

This course requires 1 credit.

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

Meet Your Facilitator

Nicky Bull

Nicky Bull

Corporate Consultant, Blue Chameleon

Nicky Bull, a dynamic corporate trainer and consultant, brings over 15 years of commercial experience as a computer programmer and analyst. She is a lecturer at Macquarie University, and her expertise extends to designing and delivering educational programs. Nicky was the lead content designer for the acclaimed Excel Skills for Business course, receiving the Coursera Outstanding Educator Award in 2018. Holding a BSc Hons in Computer Science and a BA in English Literature, along with a Postgraduate Certificate in Education from the University of Hertfordshire, U.K., Nicky is dedicated to enabling confident and effective technology use in the workplace.

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Regular

Ends 13 May

$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