Data Analysis Batch A 2026

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

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.

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.

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.

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.