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.