Klaymatrix Data Labs
Klaymatrix Data Labs
Course Content
Knowing the portal
0/2
Getting used to Klaymatrix portal
00:00
Knowing your instructor
00:00
Day 1 – Excel Essentials
0/8
Pre Test
00:00
Introduction to Excel and Its Capabilities
01:55
Quickfire Quiz: Test Your Basics!
Walkthrough of Essential Excel Elements
05:00
Essential Keyboard Shortcuts
20:00
Cell Basics and Referencing (Absolute, Relative, and Mixed)
05:37
Quiz - Cell Referencing
Understanding Data Types in Excel
03:31
Day 2 – Working with Data & Lookup Functions
0/6
Mastering VLOOKUP and Data Validation
07:11
Quiz-vlookup and data validation
Introduction to Data Aggregation and Granularity
00:00
Working with Pivot Tables: Data Summarization and Insights
08:16
Conditional Formatting: Highlighting Key Data Points
00:00
Quiz-Pivot Table and Conditional Formatting
Day 3 – Advanced Functions and Data Manipulation
0/4
Text Functions: Transforming and Cleaning Data
05:00
Date and Time Functions: Managing Temporal Data
05:00
Sorting and Filtering Data for Insights and Organization
30:00
Excel- Text Functions
Day 4 – Visualizations and Storytelling
0/2
Introduction to Graphs and Charts for Visual Data Representation
15:00
Case Study on Data visualization
00:00
Day 5 – Building Dashboards and Advanced Analysis
0/4
Dashboards in Excel – Part 1
00:00
Combining Multiple Charts for Dynamic Dashboards
00:00
Introduction to Basic Statistics in Excel (Mean, Median, Mode)
00:00
Applying Basic Statistical Analysis in Reports
00:00
Day 6 – Dashboards and Final Review
Roughly we would be covering: 1. Power Query - what they are and its basic functioning 2. Case Study: The problem statement (using the data shared with us) and creating an automated tracker with the help of power query. This would include creating a folder structure, standardization of data, writing power query and automatic collation in the tracker - month/client wise
0/8
Dashboards in Excel – Part 2 (Interactive Elements, Slicers)
38:49
Advanced Pivot Table Techniques for Dashboards
00:00
Recap of Key Concepts Covered
00:00
Final Quiz: Dashboards and Key Topics
00:00
Practice Exercises and Group Activity
00:00
Quiz – Post-Test
00:00
How to add your certificate on LinkedIn
00:00
Case Study
ACEFM Case Study
ACEFM data based case study using their data in excel files. This case study is for demonstrating how powerquery in excel can be used to do automation to clean, transform and combine data.
0/1
Case Study
ACEFM – Excel for Business Analytics
About Lesson


Klaymatrix portal is an essential tool in your learning journey. This not only helps in your course journey but is a constant tool for you in your overall data science learning journey.

  • how to sign in

  • where to find your profile

  • about the portal

Previous
Next
0% Complete