Online Training
Excel Advanced for Government
Analyse, visualise and organise large, complex datasets from multiple sources
Date 1: 13 and 20 February 2025 (Thursday) | Date 2: 18 and 25 August 2025 (Monday)
9am to 12.30pm AEDT
Next intake: Date 1: 13 and 20 February 2025 (Thursday) | Date 2: 18 and 25 August 2025 (Monday) | 9am to 12.30pm AEDT
Overview
Supercharge your Excel skills with our Advanced Excel for Government Training! Designed for individuals already proficient in intermediate Excel features, this comprehensive course takes you to the next level of automation, problem-solving, and data analysis. Unleash the power of named ranges to streamline calculations and data management.
Master advanced data validation techniques, including automated drop-down lists and complex validations. Learn how to summarise data with precision using advanced aggregation functions. Delve into advanced lookup functions like VLOOKUP, MATCH, INDEX, and more. Automate repetitive tasks using macros and get an introduction to VBA programming. Discover the transformative capabilities of Power Query for data transformation and integration. Master Power Pivot for advanced data modelling and interactive dashboards. Don’t miss this exclusive opportunity to become an Excel expert in a government context.
Ideal for intermediate users, this course empowers you with advanced automation, problem-solving, and data analysis techniques. Discover the power of named ranges, advanced data validation, and aggregation functions. Dive into advanced lookup functions and automation with macros and VBA. Harness the capabilities of Power Query for data transformation and integration. Master Power Pivot for advanced data modelling and dynamic dashboards. Become an Excel expert and excel in a government context. Secure your spot in this exclusive training now.
Course Inclusions
Why choose PSN Academy’s Excel Advanced for Government
- Small class sizes – not more than 20 students allowing time for personalised guidance
- Technical and practical and ready for immediate implementation
- Public sector focus: delivered with the unique public sector challenges in mind
- Flexible and online delivery, for the time-poor public sector professional. This works shop is delivered in 3.5 hour sessions over 2 days. They are delivered online so you can dial-in from your desk or home office
- Learn from leader trainer and well-regarded Excel Expert – Nicky Bull
Online Training
Excel Advanced for Government
Session details
- Take the next step in your journey of becoming an analyst
- Make sense of large complex data sets from different sources quickly and efficiently
- Learn how to unlock insights from unclean data
- 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
Level: Advanced
Familiarity with the topic is required
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
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
Register Today
Join this training for professionals working within the Public Sector
Regular
$A 895
per person + taxAdditional 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 informationCan't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
