Learning Data Analytics the Easy Way with MS Excel

Pravin Waswa — Sat, 24 Jan 2026 13:15:21 +0000

Understanding data is a valuable skill in today's world, which revolves around data-driven systems. One of the easiest and most accessible tools for getting started with data analytics is Microsoft Excel. Whether you are a student, a business owner, or someone curious about data, Excel provides powerful features that allow you to analyze data without writing any code.

This guide walks you through how MS Excel can be used for basic data analytics, especially for beginners who are new to data anaylsis.

What Is Data Analytics and Why Does It Matter?

Data analytics is the process of examining data to discover useful information, patterns, and trends that help with decision-making. For example:

A business may analyze sales data to identify best-selling products
A student may analyze survey results for a project
A marketer may track website traffic over time

Excel helps turn raw data into meaningful insights using easy-to-use tools.

Why Microsoft Excel Is a Great Tool for Beginners

Microsoft Excel is often the first data analytics tool people learn—and for good reason.

Here’s why Excel is ideal for beginners:

It has a simple, user-friendly interface
It is widely available and used in most workplaces
It supports data organization, calculation, and visualization
No programming knowledge is required

Excel may look simple at first, but it is powerful enough to handle many real-world data tasks.

Getting Familiar with the Excel Workspace

When you open Excel, you are greeted with a worksheet made up of rows, columns, and cells:

Rows run horizontally and are numbered (1, 2, 3…)
Columns run vertically and are labeled with letters (A, B, C…)
Cells are the boxes where rows and columns intersect (for example, A1)

Each cell can store text, numbers, dates, or formulas.

Entering and Structuring Data in Excel

Good data analysis starts with well-organized data. In Excel, data is usually structured in a table format.

Example of a simple dataset:

Column A: Employee ID
Column B: First Name
Column C: Last Name

Best practices when entering data:

Always use the first row for column headers
Avoid empty rows or columns
Keep the same type of data in each column

Turning Your Data into an Excel Table

Excel tables make data analysis easier and more efficient.

How to Create a Table

Select all your data
Press Ctrl + T (Windows)
Ensure My table has headers is checked
Click OK

Benefits of using tables:

Built-in sorting and filtering
Cleaner formatting
Formulas automatically expand with new data

Sorting and Filtering Data to Find Insights

Sorting Data

Sorting allows you to arrange data in a specific order.

Examples:

Sort sales from highest to lowest
Sort dates from earliest to latest

Steps:

Click anywhere inside the table
Go to Data → Sort
Choose the column and sorting order

Filtering Data

Filtering helps you focus only on the data you need.

Examples:

View sales for a single product
Show data for a specific date range

Steps:

Click the filter arrow in a column header
Select the values you want to display

Using Basic Excel Formulas for Analysis

Formulas are the backbone of data analysis in Excel. They help you calculate totals, averages, and other key metrics.

SUM – Adds numbers together

=SUM(A2:A28)

AVERAGE – Calculates the average value

=AVERAGE(B3:B33)

COUNT – Counts how many cells contain numbers

=COUNT(C2:C30)

Visualizing Data with Charts

Charts turn numbers into visuals, making data easier to understand.

Popular chart types in Excel:

Column charts – Compare values
Line charts – Show trends over time
Pie charts – Display proportions

Creating a Chart

Select your data
Go to Insert → Charts
Choose a chart type

Analyzing Data with PivotTables

PivotTables are one of Excel’s most powerful features for summarizing data.

They allow you to answer questions like:

What is the total sales per product?
How much was sold each month?

How to Create a PivotTable

Click anywhere in your data table
Go to Insert → PivotTable
Choose where to place it
Drag fields into Rows, Columns, and Values

When Excel Is the Right Tool for Data Analytics

Excel works best for:

Small to medium-sized datasets
Beginner and intermediate analysis
Reporting and dashboards

However, for very large datasets or advanced analytics, tools like Power BI, SQL, or Python may be more suitable.

Microsoft Excel is an excellent starting point for anyone interested in data analytics. Its combination of tables, formulas, charts, and PivotTables allows beginners to explore data, uncover insights, and build confidence in their analytical skills.

If you’re new to data analytics, mastering Excel is one of the smartest first steps you can take.

What is Git and Why Version Control is Important

Pravin Waswa — Sun, 18 Jan 2026 04:28:08 +0000

What is Git?

Git is a version control system that allows developers to keep track of changes made to their code over time. It saves a history of edits, makes it possible to restore earlier versions when needed, and enables multiple people to work on the same project without interfering with one another’s changes.

Importance of Version Control

Tracks Changes – Keeps a clear record of what changed, who made the change, and why.
Restores Previous Versions – Allows you to revert or compare older versions when issues arise.
Enables Teamwork – Lets multiple people work on the same project without overwriting each other’s work.
Supports Safe Experimentation – Uses branches to test features or fixes without affecting the main code.
Provides Backup – Stores project history locally and on platforms like GitHub for added safety.
Improves Code Quality – Encourages reviews, documentation, and accountability.

How to Push Code to GitHub

Pushing code means sending your local changes to a GitHub repository so they are saved online and shared with others.

Steps and commands:

Check which files were changed

git status

Stage the files you want to include

git add .

Save the changes with a message

git commit -m "Describe the changes made"

Upload the changes to GitHub

git push origin main

How to Pull Code from GitHub

Pulling code means downloading the latest changes from GitHub to your local computer. It ensures you are working with the most recent version of the project and helps avoid conflicts.

Steps and commands:

Get and merge the latest updates

git pull origin main

How to Track Changes Using Git

Git allows you to monitor what has changed in your project at any time. Tracking changes helps you review work, identify errors, and understand how the project has evolved.

Useful commands to use

View the current state of your files

git status

See line-by-line changes

git diff

View commit history

git log

DEV Community: Pravin Waswa

Learning Data Analytics the Easy Way with MS Excel

What Is Data Analytics and Why Does It Matter?

Why Microsoft Excel Is a Great Tool for Beginners

Getting Familiar with the Excel Workspace

Entering and Structuring Data in Excel

Turning Your Data into an Excel Table

Sorting and Filtering Data to Find Insights

Sorting Data

Filtering Data

Using Basic Excel Formulas for Analysis

Visualizing Data with Charts

Creating a Chart

Analyzing Data with PivotTables

How to Create a PivotTable

When Excel Is the Right Tool for Data Analytics

What is Git and Why Version Control is Important

What is Git?

Importance of Version Control

How to Push Code to GitHub

Steps and commands:

How to Pull Code from GitHub

Steps and commands:

How to Track Changes Using Git

Useful commands to use