Data-Driven Discoveries

Expires in: 17 days

This 5-day intensive training is designed to equip professionals with essential data analysis skills, empowering them to transform raw data into meaningful patterns and actionable outcomes. Through hands-on exercises and practical examples, participants will explore advanced filtering techniques, master formulas and functions, and gain expertise in joins and Power Query. Whether you're a data novice or looking to refine your skills, this course will help you leverage data more effectively in decision-making processes.

Curriculum

5 Sections
16 Lessons
0 Quizzes
0 Google Meets
0m Duration

Expand All

Advanced and Basic Filtering

4 Lessons0 Quizzes0 Google Meets

Understanding the purpose and applications of data filtering.
Basic Filtering: Sorting and filtering data to focus on relevant subsets.
Advanced Filtering: Using multiple criteria to refine data views
Hands-on Exercise: Applying filters to large datasets to isolate key information

Mastering Formulas and Functions

3 Lessons0 Quizzes0 Google Meets

Overview of essential Excel functions for data analysis
Practical Applications of:
Hands-on Exercise: Building nested formulas to solve complex problems.

Joins Playground and XLOOKUP Practice

4 Lessons0 Quizzes0 Google Meets

Introduction to data joins: Understanding their purpose in combining datasets
XLOOKUP: Using the function to retrieve data from tables
Joins Playground: Experimenting with inner, outer, left, and right joins
Hands-on Exercise: Merging datasets and resolving mismatched records

Guide to Joins

2 Lessons0 Quizzes0 Google Meets

Detailed exploration of join types and their use cases
Practical Examples: Working with real-world datasets to master joins

Introduction to Power Query

3 Lessons0 Quizzes0 Google Meets

Overview of Power Query and its benefits for data analysis
Using Power Query to:
Hands-on Exercise: Building a Power Query workflow to prepare a report