- Description
- Curriculum
- Reviews
-
1
Class One Text (INTRODUCTION TO DATA ANALYSIS)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
-
2
Excel Class One -
3
Class Two Text (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.
We clarified the difference between formulas and functions, highlighting how they're often used interchangeably in everyday usage.
-
4
Excel Class Two
-
5
Class Two Quiz -
6
Class Three Text (Using Lookups)
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
XLOOKUP
-
7
Class Three Quiz
-
8
WEEK 1 ASSIGNMENT
-
9
Class Four Text (If Statement, Nested If and Functions for Data Cleaning)
An IF statement in Excel is a logical function that tests a condition and returns one value if true and another value if false.
-
10
Class Four Quiz
-
11
Class Five Text (Sort and Filters, Removing extra rows, Conditional formatting, removing duplicate)
Sorts: Arrange data in a specific order (ascending, descending, alphabetical, etc.) to organize and analyze it.
Filters: Show only specific data that meets certain conditions, hiding the rest. This helps focus on relevant information
-
12
Class Five Quiz
-
13
Class Six Text: (Data Cleaning in 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.
