TEAM
Microsoft Excel - Intermediate
Zeducation is delivering this course on behalf of Tuputoa and Microsoft.
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.
_svg.png){kind=logo}
Duration
6pm - 8pm (2 - hours)
Location
Online
Best For
Beginners
Funded by Tuputoa and Microsoft for Pasifika and Māori
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