Curriculum
Course:
Data Analysis 2024 (BATCH C)
Login
Curriculum
Data Analysis 2024 (BATCH C)
Week 1
0/13
Class One; Text ( Introduction to Data Analysis)
3 Hours
Class One; Quiz
5 questions
Class Two; Text (Introduction to Basic Excel formula and functions)
3 hours
Class Two Video Part 1
Video lesson
Preview
Class Two Video Part 2
Video lesson
Class Two Video Part 3
Video lesson
Class Two Quiz
5 questions
Class Three; Text (Splitting, Transpose, Sort and Filter)
3 hours
Class Three Video Part 1
Video lesson
Class Three Video Part 2
Video lesson
Class Three Video Part 3
Video lesson
Preview
Class Three Quiz
5 questions
WEEK 1 ASSIGNMENT
Assignment
WEEK 2
0/24
Class Four; Text (Drop-down list, Ifstatement, Join and Remove Extra rows)
3 hours
Class Four Video Part 1
Video lesson
Class Four Video Part 2
Video lesson
Class Four Video Part 3
Video lesson
Class Four Video Part 4
Video lesson
Class Four Video Part 5
Video lesson
Class Four Video Part 6
Video lesson
Preview
Class Four Quiz
5 questions
Class Five; Text (VLOOKUP , Proper function, Clean Function, Value Function, Trim Function and Conditional Formatting)
3 hours
Preview
Class Five Video Part 1
Video lesson
Class Five Video Part 2
Video lesson
Class Five Video Part 3
Video lesson
Class Five Video Part 4
Video lesson
Class Five Video Part 5
Video lesson
Class Five Video Part 6
Video lesson
Preview
Class Five Quiz
5 questions
Class Six; Text (Pivot Table and Chart)
3 hours
Class Six Video Part 1
Video lesson
Class Six Video Part 2
Video lesson
Class Six Video Part 3
Video lesson
Class Six Video Part 4
Video lesson
Class Six Video Part 5
Video lesson
Preview
Class Six Quiz
5 questions
WEEK 2 ASSIGNMENT
Assignment
WEEK 3
0/19
Class Seven ; Text(DATA CLEANING)
3 hours
Class Seven Video Part 1
Video lesson
Class Seven Video Part 2
Video lesson
Class Seven Video Part 3
Video lesson
Class Seven Video Part 4
Video lesson
Preview
Class Seven Quiz
5 questions
Class Eight; Text (Power Query Editor)
3 hours
Class Eight Video Part 1
Video lesson
Class Eight Video Part 2
Video lesson
Class Eight Video Part 3
Video lesson
Class Eight Video Part 4
Video lesson
Class Eight Video Part 5
Video lesson
Preview
Class Eight Quiz
5 questions
Class Nine: Text (Data Cleaning with power Query Editor continuation)
3 hours
Class Nine Video Part 1
Video lesson
Class Nine Video Part 2
Video lesson
Class Nine Video Part 3
Video lesson
Preview
Class Nine Quiz
5 questions
WEEK 3 ASSIGNMENT
Assignment
WEEK 4
0/16
Class Ten ; Text (BUILDING OF DASHBOARD AND SLICERS)
3 hours
Class Ten Video Part 1
Video lesson
Class Ten Video Part 2
Video lesson
Class Ten Video Part 3
Video lesson
Class Ten Video Part 4
Video lesson
Class Ten Video Part 5
Video lesson
Class Ten Quiz
5 questions
Class Eleven; Text ( Building Dashboard with a Slicer )
3 hours
Preview
Class Eleven Video Part 1
Video lesson
Class Eleven Video Part 2
Video lesson
Class Eleven Video Part 3
Video lesson
Class Eleven Quiz
5 questions
Class Twelve; Text (Correlation in excel)
3 hours
Class Twelve Video Part 1
Video lesson
Class Twelve Quiz
Quiz
WEEK 4 ASSIGNMENT
Assignment
Video lesson
Class Three Video Part 3
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
No account?
Sign Up
Sign In
Lost Password?