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.
