Online Training

Excel Advanced for Government

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

8 & 15 May 2024

9:00 AM to 1:20 PM EST

Next intake: 8 & 15 May 2024 | 9:00 AM to 1:20 PM EST

Overview

This transformative adventure is tailored for intermediate users, delving into advanced automation, problem-solving, and data analysis techniques. Master the art of named ranges, weave data tales with automation sorcery using macros and VBA, and sculpt dynamic dashboards in a visual symphony. From complex lookup functions to the enchanting capabilities of Power Query, this course propels you into the Excel cosmos.

Secure your spot now to level up your Excel game and become a champion in government settings. Don’t just upgrade; embrace a training experience that’s both transformative and exhilarating!

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

Wrangle complex data: Clean, organize, and analyze large datasets with named ranges, validation, and aggregation functions.
Automate workflows: Save time and increase productivity with macros and VBA, eliminating manual tasks.
Uncover insights: Perform advanced analysis using lookup functions and Power Pivot, identify patterns and trends.
Communicate effectively: Create clear reports and interactive dashboards with compelling visualizations.

Online Training

Excel Advanced for Government


Session details

  • Elevate your Excel skills with advanced features like named ranges, data validation, and aggregation functions.
  • Dive deep into the world of advanced lookup functions, macros, and VBA programming for efficient automation.
  • Master Power Query and Power Pivot for transformative data transformation, integration, and dynamic dashboards.
View course modules

Level: Advanced

Familiarity with the topic is required

or

Get this course using credits with a Premium subscription. 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

• VLOOKUP (recap)
• MATCH
• INDEX
• INDIRECT & XLOOKUP (time & version permitting)

• Understand macros and macro security
• Record and run macros
• Edit macros and introduction to VBA

• 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

Salma Sultana Image

Salma Sultana

Data Storytelling and Visualization Expert and Excel Advanced Expert

Meet Salma Sultana, your seasoned guide through the world of data mastery. With 17 years of expertise, Salma has shaped major strategic decisions alongside C-Suite executives and managed multimillion-dollar acquisitions and mergers. Beyond her analytical prowess, she’s a dynamic trainer who’s conducted workshops and personalized sessions, bridging the gap between communication, data, and design. In her course, Salma focuses on teaching you the art of visualizing impactful data stories, building credibility in corporate spaces, and earning your seat at the big discussion table.

Join her transformative journey where Excel becomes your key to corporate influence.

Register Today

Join this training for professionals working within the Public Sector

Pay for individual courses

Early Bird 1

Ends 1 Mar

$595

per person + tax $400 saving

 

Early Bird 2

Ends 5 Apr

$795

per person + tax $200 saving

 

Regular

$995

per person + tax

Use training credits

Subscription

Pay today using:

1 credit

Get credit by subscribing to Premium. 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...

Basic

Members

Unlock public content, complimentary events, training courses and vital Insights

$0 per year Join Now

Exclusive Basic Member Benefits:

  • Access benchmark case studies and deep dive white papers and reports
  • Connect & collaborate with public sector peers
  • Discover and explore solutions tailored for government in Marketplace
Limited Time Introductory Offer

Premium

Enhance your learning experience with our Premium Services

$A 2895 + GST for 12 months Get Started

Includes all Basic Member Benefits, plus:

  • Masterclasses: Complimentary signup for ANY available Masterclasses in your region, including exclusive masterclass content
  • 4 training credits* which can be used to cover up to 4 courses
  • Access to 'private çommunity of practice' groups for your masterclass or courses

Enterprise

Team up to take your learning to the next level

 
Get a Quote

Includes all Basic and Premium Member Benefits, plus:

  • Dedicated account manager
  • Tailor-made training programs with flexible training credits which can be shared across your team across many courses.
  • Access to 'private çommunity of practice' for team members who have signed up for specific masterclasses or courses

* Most full-day Public Sector Network courses (which may be split over two days) will require one credit. Most two day courses (which may be split over multiple days) will require two credits. Check the details for individual courses

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