How I Learned Excel in My First Week Of Data Science - Real-World Uses Explained

When I started learning Data Science, I expected to spend my first week writing Python code, exploring machine learning models, and working with advanced tools.

Instead, I spent most of my time in Excel.

At first, it felt underwhelming—just rows, columns, and simple spreadsheets. But within a few days, I realized something important: Excel is not a basic tool at all. It is one of the most widely used tools in data analysis, business decision-making, and reporting.

📊 Real-World Uses of Excel

Excel is widely used across industries for handling and analyzing data. Some of the most common uses include:

• Business Analysis - Tracking sales and identifying trend
• Accounting and Budgeting - Managing Expenses, Profits and Financial reports
• Marketing Analysis - Measuring campaigns performance and customer behavior
• Data Entry and Management - organizing large datasets efficiently

Businesses rely on Excel because it helps turn raw data into meaningful insights for decision making.

🛠️ Key Excel Features I Learned

In my first week, I explored several important Excel Features that help with data organization and analysis:

• Excel Interface Overview - I first explored how Excel is organized, including Ribbon, Worksheets, Cell, Row, Columns, and formula bar. this helped me understand how to navigate the tool before working with data
• Data Sorting - Organizing data by numbers, Text and Dates
• Filtering - Showing only relevant data based on condition
• Data Validation - Ensuring accurate and consistent data entry
• Freeze Panes - Keeping header Visible while scrolling through large datasets. These features make working with data much easier, faster and more structured.

🧮 Basic Excel Functions I learned

I was also introduced to some basic Excel functions used in Data Analysis.
Aggregate Functions

-SUM - Add all values in a range
-AVERAGE - Calculate the mean of a dataset
-COUNT - Counts numerical entries in a dataset

Conditional Functions

-SUMIF() and SUMIFS()** - Add values that meets one or more conditions
-COUNTIF() and COUNTIFS() - Counts records that match specific criteria
-AVERAGEIF() and AVERAGEIFS() - Calculate average based on selected conditions

These functions help analysts answer business questions such as total sale by product, customer count by region, or average performance across departments.

OTHER FUNCTIONS
I also learned about:
-TEXT FUNCTIONS such as LEFT(), RIGHT(), LEN(), and CONCAT()
-DATE and TIME FUNCTIONS such as TODAY(), NOW(), DAY(), MONTH(), YEAR()
These functions help analyst clean data, identify Trends, and create meaningful reports.

💡 What this changed for me

Before learning Excel, I saw data as just a number in rows and columns. Now I understand that data can tell stories, reveal patterns, and support real-world decisions.
Even after just one week, I can already see how powerful Excel is in transforming raw data into useful insights.

🚀 Final Thoughts

This is only the beginning of my Data Science journey, but Excel has already changed how I think about data and how I approach data analysis.
Next I plan to learn advanced Excel features such as Tables, XLOOKUP, and Dashboard before moving deeper in python and data visualization.

💬 What was your first experience with Excel like?
I'd love to hear from others learning Data Analytics or working in the field.