Start your data analytics journey by learning how to read, understand, calculate, and reason about a simple business dataset in Excel.
Excel Analytics
Sales Overview
Records
5
Products
4
Regions
3
Revenue
₹359K
Learning Flow
Imagine you are working as a junior data analyst for a small electronics store. The store records daily sales in Excel.
Sales Dataset
Small electronics store
| Date | Region | Product | Units | Price |
|---|---|---|---|---|
| 1 Jan | North | Laptop | 3 | ₹50,000 |
| 2 Jan | South | Mouse | 10 | ₹1,000 |
| 3 Jan | North | Keyboard | 5 | ₹2,000 |
| 4 Jan | East | Laptop | 2 | ₹52,000 |
| 5 Jan | South | Monitor | 4 | ₹15,000 |
Interactive Activity
What does one row in this dataset represent?
Excel is one of the most widely used tools for organizing, calculating, and analyzing business data. In this beginner Excel lesson, you learn how a dataset is structured and how rows, columns, cells, dimensions, and measures are used in data analytics.
This lesson introduces the basic structure of an Excel dataset using a simple sales example. You learn how to identify individual records, understand columns, recognize dimensions and measures, work with cell references, and calculate revenue.
Excel becomes more powerful when you use it to answer business questions. Instead of only entering numbers, a data analyst uses Excel formulas and structured datasets to calculate metrics, compare results, identify patterns, and communicate findings.
One of the first useful calculations in sales analytics is revenue. Revenue can be calculated by multiplying the number of units sold by the selling price.
If Units are stored in cell D2 and Price is stored in E2, the corresponding Excel formula is:
Understanding the structure of data is an important foundation for data analytics. Rows generally represent observations or records. Columns represent fields or variables. Dimensions such as Product, Region, and Date describe or categorize the data, while numerical measures such as Units, Price, and Revenue can be calculated and analyzed.
This interactive lesson is designed to build analytical thinking from the beginning. You learn a concept, interact with realistic data, answer a question, receive immediate feedback, and then apply the concept to a business problem.
Learning Principle
Understand the data → Calculate → Compare → Interpret → Answer