Data Analysis Private Class
- Curriculum
- Reviews
-
1Class One; Text (Introduction to Data Analysis)3 Hours
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.
-
2Class Two; Text(Introduction basice excel formula and functions)3 Hours
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.
-
3Class Three; Text (LOOK UP FUNCTIONS)Text lesson
The term ‘Look up’ as used in the context, means to look up (search) from a list.
There are two main LOOKUP functions that can be used within Excel. These are:
HLOOKUP
VLOOKUP
-
4Class Four; Text (Conditional formatting, Sort, Filter, Table, Pivot table and Chart)3 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.
-
Data Analysis Private Class
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.