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:Learning Outcomes
Online Training
Excel Advanced for Government
Session details
- Master advanced Excel features
- Enhance efficiency and productivity
- Excel in data analysis and reporting
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, 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
Additional discounts are available for group registrations of 10 or more. For group or payment enquiries or custom training solutions, please contact [email protected]
New Learning Platform, New Login - Here's What You Need to Know
We've just launched our upgraded PSN Learning Hub, powered by Absorb LMS, to deliver a smoother, smarter training experience. To access and purchase training, you'll now need to log in through our Single Sign-On (SSO) system using your free PSN membership account.
Why the extra step?
This change helps us personalise your learning journey, track your progress, and give you access to exclusive member benefits all in one place.
Not a member yet?
Becoming a PSN Member is Fast, Free, and Packed with Perks:
- Access to our online community of 300,000+ public sector professionals
- Invitations to exclusive free events, webinars, and training previews
- Priority access to new programs and member-only pricing
- Personalised content and networking opportunities through the PSN Platform
If you're not a member yet, it only takes a minute to register, and you'll unlock far more than just training access.
Register for free nowAlready a member? Just log in to continue.
Can't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
