- 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 Two; Text(Introduction basic excel formula and functions)
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.
-
3
Class Three; Text (Create dropdown list, VLOOKUP, If statement)
DROP DOWN LIST
A drop-down list is a feature in Excel that allows you to select a value from a pre-defined list of options. Drop-down lists are useful for controlling data entry, ensuring consistency, and preventing errors. They can also make it easier for users to enter data, as they don't have to type values manually
-
4
Class Four: Text (Removing extra rows, Sorts and Filter, Pivot table and Chart)
REMOVING EXTRA ROWS
This function is used to remove rows of data that are blank or have no data in certain columns. For example, let's say you have a spreadsheet with 10 rows of data, but 3 of the rows are blank. You could use the remove extra rows function to remove those 3 blank rows. The function would leave you with 7 rows of data.
-
5
Class Five: Text (Excel Cell Reference and Data Cleaning in Power Query Editor)
1. Relative References: Understanding how cell references change when formulas are copied to other cells.
2. Absolute References: Learning how to lock cell references using $ signs to prevent changes when formulas are copied.
-
Data Analysis Batch 2025 (Batch C)
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
