- Description
- Curriculum
- Reviews
-
1
Class One; Text (Introduction To Data Analysis)What is Data analysis?
Data analysis is the process of identifying, cleaning, transforming, and modeling data to discover meaningful and useful information. The data is then crafted into a story through reports for analysis to support the critical decision-making process.
-
2
Class One Quiz -
3
Class Two; Text (Introduction to Excel)
Formulae and Functions
Formula are users made (it is defined by a user’s without excel instructions) When a user uses any kind of logic to get an answer is called formula.
Using Formulae
Simple mathematical operators can be used to:
Add (+) Also known as SUM
Subtract (-)
Divide (/)
Multiply (*)
Calculate Indices (powers) of a number
-
4
Class Two Video Part 1 (Introduction to Basic excel formula and functions) -
5
Class Two Video Part 2
-
6
Class Two Video Part 3
-
7
Class Two Video Part 4
-
8
Class Two Quiz
-
9
Class Three: Text (Split, Transpose, Drop down list and Vlookup functions)
SPLIT FUNCTION
The split function is used to split a string into multiple parts based on a delimiter. A delimiter is a character that separates parts of a string. For example, the split function could be used to split a first name and last name into two separate columns. If you had a column of data with full names, like "John Adebayo", the split function could be used to separate "John" and "Adebayo" into two columns.
-
10
Class Three Video Part 1
-
11
Class Three Video Part 2
-
12
Class Three Video Part 3
-
13
Class Three Video Part 4
-
14
Class Three Video Part 5
-
15
Class Three Video Part 6
-
16
Class Three Quiz
-
17
WEEK 1 ASSIGNMENT
-
18
Class Four; Text (If statement and data cleaning)
IF Function
An IF function is made up of 3 parts:
A condition
What to do if the condition is met
What to do if the condition is not met
-
19
Class Four Video Part 1
-
20
Class Four Video Part 2
-
21
Class Four Video Part 3
-
22
Class Four Video Part 4
-
23
Class Four Video Part 5
-
24
Class Four Video Part 6
-
25
Class Four Quiz
-
26
Class Five: Text (SORT AND FILTER, CONDITIONAL FORMATTING, PIVOT TABLE AND CHART)
What is the difference between filter and sort by?
Filters set a hard boundary on the search results and exclude anything not falling within the categories selected, while sort sets a soft boundary and only changes the sequence of appearance. Sorting helps to organize data by particular attribute or parameter, such as alphabetically or by date or by descending and ascending order.
-
27
Class Five Video Part 1
-
28
Class Five Video Part 2 (Sort and Filter)
-
29
Class Five Video Part 3
-
30
Class Five Video Part 4
-
31
Class Five Video Part 5
-
32
Class Five Quiz
-
33
Class Six: Text (Data Cleaning using Power Query Editor)
Power Query Editor, also known as "Get & Transform" in some versions of Microsoft Excel, is a data analysis tool that allows users to efficiently import, transform, and combine data from various sources.
-
34
Class Six Video Part 1 (Power Query Editor)
-
35
Class Six Video Part 2
-
36
Class Six Video Part 3
-
37
Class Six Quiz
-
38
WEEK 2 ASSIGNMENT
-
39
Class Seven; Text (Advance part of data cleaning)
What is data cleaning?
Data cleaning, also known as data cleansing, is the process of detecting and correcting errors or inconsistencies in a dataset. This can include tasks like removing duplicate records, correcting spelling mistakes, standardizing date formats, and so on. Data cleaning is important because it ensures that your analysis is based on accurate and consistent data.
-
40
Class Seven Video Part 1 (Advance part of data cleaning)
-
41
Class Seven Video Part 2
-
42
Class Seven Video Part 3
-
43
Class Seven Video Part 4
-
44
Class Seven Quiz
-
45
Class Eight; Text (Continuation on data cleaning and Chart)
What is data cleaning?
Data cleaning, also known as data cleansing, is the process of detecting and correcting errors or inconsistencies in a dataset. This can include tasks like removing duplicate records, correcting spelling mistakes, standardizing date formats, and so on. Data cleaning is important because it ensures that your analysis is based on accurate and consistent data.
-
46
Class Eight Video Part 1
-
47
Class Eight Video Part 2
-
48
Class Eight Video Part 3
-
49
Class Eight Video Part 4
-
50
Class Eight Video Part 5
-
51
Class Eight Video Part 6
-
52
Class Eight Video Part 7
-
53
Class Eight Video Part 8
-
54
Class Eight Quiz
-
55
Class Nine; Text (Chart and Dashboard)
1. BUILDING OF DASHBOARD AND SLICERS
A dashboard is a visual representation of data that's designed to provide an at-a-glance overview of key metrics. A dashboard can include a variety of visualizations, like charts, tables, and graphs.
It's a great way to get a quick overview of your data and identify areas that need attention. Dashboards are often used in business intelligence and data analytics applications.
-
56
Class Nine Video Part 1
-
57
Class Nine Video Part 2
-
58
Class Nine Video Part 3
-
59
Class Nine Video Part 4
-
60
Class Nine Video Part 5
-
61
Class Nine Video Part 6
-
62
Class Nine Video Part 7
-
63
Class Nine Video Part 8
-
64
Class Nine Video Part 9
-
65
Class Nine Quiz
-
66
WEEK 3 ASSIGNMENT
-
Data Analysis 2025 (Batch A)
₦200,000
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
