Excel Advanced for Government
December 5 & 12, 2023 | 9:00 AM – 1:20 PM EST | 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 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 summarize 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 modeling and interactive dashboards. 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!
Designed for intermediate users, this course takes you beyond the basics to advanced automation, problem-solving, and data analysis. Master-named ranges, advanced data validation, and aggregation functions. Delve into advanced lookup functions and automation with macros and VBA. Harness the power of Power Query for data transformation and integration. Unlock the potential of Power Pivot for advanced data modeling and interactive dashboards. Don’t miss out on this opportunity to become an Excel champion in a
Take your Excel skills to the next level with our Advanced Excel for Government Training! 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 modeling and dynamic dashboards.
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 charge of driving transformation change in all three levels of government including:
Project, Program and Operations
Advanced-Data Management: By the end of this training, participants
will be able to effectively manage and analyze large amounts of data
using advanced Excel features such as named ranges, data validation,
and aggregation functions. They will gain the skills to organize and clean
data efficiently, ensuring accuracy and integrity.
Automation and Efficiency: Participants will learn how to automate
routine tasks and calculations using macros and VBA. They will be able
to streamline their workflow, save time, and increase productivity by
eliminating manual data entry and repetitive processes.
Advanced-Data Analysis and Visualization: This training will enable participants to perform sophisticated data analysis using advanced lookup functions and Power Pivot. They will be able to retrieve specific information from complex datasets, create relationships between tables, and visualize data using Pivot Charts and Cube Functions. Participants will develop the ability to identify trends, patterns, and anomalies,
leading to more informed decision-making.
Effective Reporting and Dashboards: Participants will acquire the skills
to create clear and concise reports that effectively communicate their
findings. They will learn how to present data visually using interactive dashboards, slicers, and advanced visualization techniques. This will
enable them to convey insights and trends in a visually compelling
manner, facilitating better communication and understanding among
Meet Your Facilitator
IT Trainer and Courseware Developer
Salma is a highly successful data-driven, detail-oriented analyst & business strategist with over 17 years of experience in the field of data. During her career, she has worked alongside C-Suite executives, change & transformation teams, project managers, and consultants from McKinsey to drive major strategic decisions for the organization.
The biggest highlights of her career include overseeing the planning and analysis of 2 major acquisitions and a 3-way merger, and participation in several digitization projects yielding over $5M in annual savings.
An extrovert by nature, Salma is very passionate about teaching as well. During her career, she trained multiple interns, conducted internal workshops on topics related to communicating with data, and advanced Excel. She now conducts (remote) personalized and cohort training sessions to spread knowledge and bridge the gap between communication, data, and design.
When asked what’s unique about this course, this is what she had to say:
“In my course, I teach you how to visualize, communicate impactful data stories and build credibility in the corporate space, how to be known among business stakeholders, management, executives, and earn a seat at the big discussion table”
- 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
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
- 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