When I started learning Excel as part of my Data Science & Analytics course, I assumed it was just a tool for creating tables and performing basic calculations. After spending a week exploring its features, I quickly realized that Excel is much more powerful than I thought.
Almost every organization generates data. Businesses track sales, schools monitor student performance, hospitals manage patient records, and marketers analyze campaign results. Before data can be analyzed, it needs to be organized, cleaned, and summarized—and that's where Excel comes in.
In this article, I'll share some of the Excel concepts I've learned so far and how they're used in real-world data analysis.
Understanding the Excel Workspace
Before working with data, it's important to understand the basic structure of Excel.
When you open Excel, you're working inside a workbook. A workbook can contain multiple worksheets (often called sheets), which help organize different sets of data.
At the top of the screen is the Ribbon, which contains tabs such as Home, Insert, Page Layout, Formulas, Data, and View. The Ribbon acts like a control center where you can access Excel's tools and features.
Rows run horizontally and are identified by numbers, while columns run vertically and are identified by letters. The intersection of a row and column is called a cell, where data is entered.
At first, all these parts seemed overwhelming, but after using Excel regularly, navigating through them has become much easier.
The Different Types of Data in Excel
One of the first things I learned is that not all data is the same.
Excel commonly works with:
- Text data (names, product categories, locations)
- Numeric data (sales figures, quantities, prices)
- Date and time data (order dates, deadlines)
- Logical data (TRUE or FALSE values)
Understanding data types is important because Excel treats each type differently when performing calculations and analysis.
Number Formats Matter More Than I Expected
Another concept that surprised me was the importance of number formatting.
The same number can be displayed in different ways:
- General format
- Currency format
- Percentage format
- Date format
- Time format
- Accounting format
For example, the number 0.25 can be displayed as 25% simply by changing the format.
Proper formatting makes data easier to read and helps prevent mistakes during analysis.
Functions That Save Time
Functions are one of the most powerful parts of Excel.
SUM()
The SUM() function adds numbers together.
Example:
=SUM(B2:B20)
This adds all values from B2 through B20.
Businesses often use SUM() to calculate total sales, expenses, or profits.
AVERAGE()
The AVERAGE() function calculates the mean value.
Example:
=AVERAGE(C2:C20)
This helps analysts understand the typical value within a dataset.
MAX()
The MAX() function returns the largest value.
Example:
=MAX(D2:D20)
A company could use this to find the highest monthly sales figure.
SQRT()
The SQRT() function finds the square root of a number.
Example:
=SQRT(144)
Result:
12
This function is especially useful in mathematics and statistics.
POWER()
The POWER() function raises a number to a specified exponent.
Example:
=POWER(5,2)
Result:
25
This can be useful when performing financial or statistical calculations.
SUMIFS() and AVERAGEIFS(): Taking Analysis Further
One of the most interesting things I learned was that Excel can calculate values based on specific conditions.
SUM() vs SUMIFS()
A regular SUM() adds everything in a range.
Example:
=SUM(B2:B20)
But what if you only want the sales from a specific region?
That's where SUMIFS() comes in.
Example:
=SUMIFS(C2:C20,A2:A20,"Nairobi")
This adds only the sales associated with Nairobi.
AVERAGE() vs AVERAGEIFS()
AVERAGE() calculates the average of all values.
Example:
=AVERAGE(C2:C20)
AVERAGEIFS() calculates an average only when specific conditions are met.
Example:
=AVERAGEIFS(C2:C20,B2:B20,"Electronics")
This calculates the average sales for products in the Electronics category only.
These functions make Excel incredibly useful for business reporting because analysts often need answers to very specific questions.
Using Conditional Formatting to Find Insights Quickly
One feature I found particularly impressive is Conditional Formatting.
Conditional Formatting automatically changes the appearance of cells based on rules.
For example, you can:
- Highlight sales above a target value
- Color low-performing products in red
- Show high-performing products in green
- Display data bars to compare values visually
Instead of manually searching through hundreds of rows, Excel immediately draws attention to important information.
Finding and Highlighting Duplicates
Duplicate data can cause serious problems during analysis.
Excel makes it easy to identify duplicates.
To highlight duplicates:
- Select the data.
- Go to Home > Conditional Formatting.
- Choose Highlight Cells Rules.
- Select Duplicate Values.
Excel immediately highlights duplicate entries.
For example, if a customer appears twice in a customer list, Excel can quickly identify the duplicate record.
Removing Duplicate Data
After identifying duplicates, Excel also allows you to remove them.
Steps:
- Select the dataset.
- Go to the Data tab.
- Click Remove Duplicates.
- Choose the columns to check.
- Click OK.
This feature is commonly used when cleaning datasets before analysis.
Freezing Headers for Large Datasets
One challenge when working with large spreadsheets is losing sight of column names while scrolling.
Excel solves this using Freeze Panes.
To freeze the header row:
- Click the View tab.
- Select Freeze Panes.
- Choose Freeze Top Row.
Now the column headers remain visible no matter how far you scroll.
This simple feature makes working with large datasets much easier.
Simple Excel Shortcuts That Save Time
I've also started learning keyboard shortcuts, and they significantly improve productivity.
Some useful shortcuts include:
- Ctrl + C → Copy
- Ctrl + V → Paste
- Ctrl + X → Cut
- Ctrl + Z → Undo
- Ctrl + S → Save
- Ctrl + A → Select all
- Ctrl + F → Find
- Ctrl + Arrow Keys → Jump to the edge of a dataset
Even learning a few shortcuts can make working in Excel much faster.
How Excel Is Used in the Real World
After learning these concepts, I can see why Excel is still widely used across industries.
Businesses use Excel to:
- Track sales performance
- Create financial reports
- Manage budgets
- Analyze customer data
- Monitor inventory
- Evaluate marketing campaigns
- Clean and prepare data for deeper analysis
Before data is loaded into advanced tools such as Python, SQL, or business intelligence platforms, it often passes through Excel first.
My Personal Reflection
The biggest thing Excel has taught me so far is that data is much more than numbers on a screen.
Every row tells a story. Every calculation answers a question. Every chart reveals a pattern that might otherwise remain hidden.
A week ago, I saw spreadsheets as boring tables. Today, I see them as tools for discovering insights and making better decisions.
I'm still at the beginning of my journey, but learning Excel has already changed the way I think about data. I look forward to learning more advanced functions, data visualization techniques, and analytical skills in the coming weeks.
Final Thoughts
Excel remains one of the most important tools in data analysis because it combines simplicity with powerful analytical capabilities. From organizing raw data to performing calculations, identifying trends, cleaning datasets, and supporting business decisions, Excel plays a critical role in turning information into actionable insights.
For someone just starting in data science and analytics, learning Excel has been an eye-opening experience, and I'm excited to continue building on this foundation.
Top comments (0)