Data Analysis 2026 (Batch C)

DATA: A representation of information or material recorded and assumed as facts. used as a basis of reasoning, discussion, or calculation, especially in the form of numbers

d assumed as facts — used as a basis of reasoning, discussion, or calculation, especially in the form of numbers

Excel as an offline spreadsheet application used for data entry, calculations, organization, and basic analysis — the foundation every data analyst starts with.

What is a "Lookup"?

A lookup function searches for a value in one place and returns related information from another place — the same way you'd scan a printed table to find someone's phone number from their name.

What is data cleaning?

Data cleaning, also known as data cleansing, is the process of detecting and correcting errors or inconsistencies in a data.

This can include tasks like removing duplicate records, correcting spelling mistakes, standardizing date formats, and so on. Data cleaning is important because it ensures that your analysis is based on accurate and consistent data.

A pivot table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot table work a little bit differently depending on what you are using it to run in excel.

It is used to analyzed numerical data in details, and answer unanticipated questions about your data. Pivot table is designed for Querying large amounts of data in many user-friendly ways.