How Excel Is Used in Real-World Data Analysis Week 1 Reflection | Data Science & Analytics Program, LuxDevHQ

Introduction
Before I enrolled in this data analytics program, Excel was something I associated mostly with tables and basic arithmetic. I knew it existed, I had opened it a few times, and I had absolutely no idea what it was truly capable of. After just one week of structured learning, I can confidently say that my perception of Excel has shifted entirely. It is not just a spreadsheet tool; it is a full-featured data analysis environment that professionals across industries depend on every single day.
Excel is a spreadsheet application developed by Microsoft that allows users to store, organize, calculate, and visualize data. It is one of the most widely used software tools in the professional world, and for good reason: it is accessible, powerful, and flexible enough to handle everything from personal budgets to complex business dashboards.

Three Real-World Ways Excel Is Used in Data Analysis

1. Financial Reporting and Business Decision-Making One of the most common applications of Excel in the workplace is financial analysis. Accountants, finance managers, and business analysts use Excel to build profit-and-loss statements, track expenses, forecast revenues, and monitor key performance indicators. For example, a small business owner might use Excel to compare monthly sales figures across quarters, identify the months where revenue dipped, and make informed decisions about staffing or marketing spend. The ability to create formulas that automatically recalculate whenever underlying data changes makes Excel invaluable in this context, a task that would otherwise take hours of manual number-crunching can be completed in minutes.
2. Marketing Performance Analysis Marketing teams rely heavily on Excel to analyze campaign data. Metrics such as click-through rates, conversion percentages, customer acquisition costs, and return on advertising spend are all regularly tracked in Excel. A digital marketing analyst, for instance, might pull data from multiple advertising platforms into a single Excel file, use formulas to calculate performance ratios, and then present the findings through charts and pivot tables to help management decide where to allocate the next campaign budget. Excel essentially acts as the first line of analysis before more advanced tools are brought in.
3. E-Commerce and Product Performance Tracking Businesses that sell products online like Jumia, for example, use Excel to monitor how their product listings are performing. Analysts track pricing trends, discount effectiveness, customer review volumes, and rating distributions. Through data cleaning, enrichment, and visualization, they can answer critical questions: Are heavily discounted products actually getting more customer engagement? Do higher-rated products command higher prices? This kind of analysis directly influences restocking decisions, promotional strategies, and product listings, all derived from what is essentially a well-structured Excel file.

Three Excel Features I Have Learned and How They Apply

1. AVERAGEIF - Conditional Averaging This formula allows you to calculate the average of a range of values that meet a specific condition. In the context of the Jumia dataset we worked on this week, I used AVERAGEIF to calculate the average rating and average discount for each discount category (High, Medium, Low). Without this formula, I would have had to manually filter the data and calculate averages separately, a process that is both slow and prone to human error. In a real business context, this formula could be used to find the average salary of employees in a particular department, or the average order value for a specific product category.
2. Conditional Formatting - Visual Data Signals Conditional formatting is a powerful visual tool that automatically changes the appearance of cells based on their values. In our project, I applied a colour scale to the rating column so that low-rated products were shaded in red, mid-range products appeared in amber, and top-rated products were displayed in green. This immediate visual feedback makes it far easier for a decision-maker to scan a large dataset and spot problems or opportunities without reading every single row. In a financial report, for example, conditional formatting could flag any expense line that exceeds a set budget threshold, automatically turning it red.
3. Data Cleaning Techniques - The Foundation of Reliable Analysis One of the most important things I learned this week is that raw data is rarely clean. In our Jumia dataset, prices were stored as text strings like "KSh 2,199", discounts were formatted as percentages rather than numbers, review counts were recorded as negative values, and ratings appeared in the format "4.5 out of 5". Before any meaningful analysis could happen, all of this had to be standardized. Using text functions, find-and-replace operations, and careful data transformation, I converted everything into consistent numeric formats. This experience taught me that a significant portion of a data analyst's work occurs before the analysis begins, and getting this step right determines whether the final insights can be trusted.

Personal Reflection: How Learning Excel Has Changed the Way I See Data
Honestly, learning Excel this week has made me far more observant in everyday life. I now notice data everywhere in a shop's price list, in a friend's complaint about a product not being what it was advertised as, in a news headline quoting statistics. Before this course, data felt like something abstract that existed in tech companies and government reports. Now it feels like something I can actually work with.
More specifically, I have come to appreciate that data rarely tells a clean story on its own. It needs to be questioned, cleaned, and structured before it reveals anything meaningful. The fact that a column labelled "Reviews" in our Jumia dataset contained negative numbers was not immediately obvious until I actually inspected the data carefully, and that kind of critical attention is something I am actively developing.
I also realized that the tools we use shape the questions we think to ask. Having access to AVERAGEIF, pivot summaries, and conditional formatting made me start wondering: Which discount category actually produces the best-rated products? Are the most reviewed items also the cheapest? These are exactly the kinds of questions a real analyst would bring to a business meeting, and I am beginning to feel equipped to answer them.
This is only week one, and I am already thinking differently about numbers. I look forward to what comes next.