Data Analysis Batch A 2026
- Description
- Curriculum
- Reviews
-
1Class One Text: Introduction to Data Analysis3 Hours
Data: a representation of information or material recorded and known or assumed as facts and used as a basis of reasoning, discussion or calculation represented especially in the form of numbers
-
2Class One Quiz5 questions
-
3Class Two Text: Introduction To Excel3 Hours
Data Manipulation Techniques:
1. Text to Column: Splitting text into multiple columns using delimiters.
2. Concatenate: Combining text from multiple columns into one column.
3. Transpose: Rotating data from horizontal to vertical or vice versa.
-
4Class Two Quiz5 questions
-
5Class Three Text(Nested IF, Value and clean functions)3 Hours
Nested functions contain a function within another function. They can handle MORE
than two outcomes (A limitation of the normal IF Function)
Sometimes nested functions can contain several functions nested within each other.
-
6Class Three Quiz5 questions
-
7Class Four Text: Conditional formatting, Sort and Filter3 Hours
Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
-
8Class Four Quiz5 questions
-
9Class Five Text: Data Cleaning in Power Query3 Hours
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.
-
Data Analysis Batch A 2026
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.