Excel Advanced for Government
Friday, 2 & 9 February 2024 – 9:00 AM – 12:30 PM AEDT | Online
Unleash the Power of Advanced Excel: Elevate Your Skills for Government Professionals
Supercharge your Excel skills with our Advanced Excel for Government Training! Designed for intermediate Excel users, this comprehensive course enhances your automation, problem-solving, and data analysis abilities. Master named ranges, advanced data validation, aggregation functions, and lookup functions. Automate tasks with macros, explore VBA programming, and harness the transformative power of Power Query and Power Pivot. Don’t miss this exclusive opportunity to become an Excel expert in a government context!
Elevate your Excel skills with our Advanced Excel for Government Training! This course goes beyond the basics, focusing on advanced automation, problem-solving, and data analysis techniques. Master named ranges, data validation, aggregation functions, lookup functions, macros, VBA, Power Query, and Power Pivot. Don’t miss out on becoming an Excel champion in a government setting!
Take your Excel skills to the next level with our Advanced Excel for Government Training! This course empowers intermediate users with advanced automation, problem-solving, and data analysis techniques. Discover named ranges, advanced data validation, aggregation functions, lookup functions, macros, VBA, Power Query, and Power Pivot. Become an Excel expert and excel in a government context. Secure your spot in this exclusive training now!
Who Should Attend
This course is designed for heads, directors, assistant directors, managers, and team leaders in charged with driving transformation change in all three levels of government including:
Project, Program and Operations
Master advanced Excel features like named ranges, data validation, and aggregation functions to effectively manage and analyze large datasets with accuracy and efficiency.
Streamline your workflow, save time, and increase productivity by learning how to automate tasks and calculations using macros and VBA, eliminating manual data entry and repetitive processes.
Learn advanced data analysis techniques using functions like lookup and Power Pivot, enabling you to retrieve specific information, identify trends, patterns, and anomalies, and make informed decisions.
Acquire skills in creating clear and concise reports, presenting data visually with interactive dashboards, and conveying insights effectively, improving communication and understanding among stakeholders.
Meet Your Facilitator
IT Trainer and Courseware Developer
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.)
- Named Ranges
- Using the Name Box
- Create from Selection
- Name Manager and using named ranges in calculations
- Data Validation
- Add simple validation
- Add validation that uses calculations
- Create automated drop-down lists
- Aggregation Functions
- Summarising data with COUNTIFS, SUMIFS & AVERAGIFS
- Aggregating with multiple criteria
- Advanced Lookup Functions
- VLOOKUP (recap)
- INDIRECT & XLOOKUP (time & version permitting)
- Macros and VBA
- Understand macros and macro security
- Record and run macros
- Edit macros and introduction to VBA
- Power Query
- 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
- Power Pivot
- 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