TEAM
Microsoft Excel - Intermediate
OVERVIEW
This training program is designed to help individuals gain proficiency in retrieving data from large datasets, organize and visualize data, perform calculations, and analyze data for better decision-making. The training will enhance efficiency, productivity, and competitiveness of participants in the workplace, as data analysis is a crucial aspect of making informed decisions in today's business world. Proficiency in these features is a valuable skill set that can benefit individuals in various roles and industries.
Duration
3 - hours
Certification
Digital Credential: Excel Intermediate
Location
onsite or online
Best For
Beginners
$350 + GST
per person (for groups 10 - 15)
WHAT YOU WILL LEARN
-
Participants will be able to efficiently retrieve data from large datasets using XLOOKUP and VLOOKUP functions.
-
Participants will be able to organize and visualize data using Excel's Analyze Data feature.
-
Participants will learn how to perform calculations using SUMIF, COUNTIF, and IF formulas.
-
Participants will be able to convert data between different formats and combine/split data from various sources.
-
Participants will have hands-on experience working with real-world data and gain a solid understanding of the importance of data analysis in decision-making.
"I especially enjoyed learning about the Analyze Data feature, as it allowed me to organize and visualize data in ways I never thought possible. Thanks to this program, I feel more confident and efficient in my work, and I'm excited to apply my new skills to future projects."
- Participant