DEV Community

Cover image for HOW EXCEL IS USED IN REAL-WORLD DATA ANALYSIS
Jedidah Ondiso
Jedidah Ondiso

Posted on

HOW EXCEL IS USED IN REAL-WORLD DATA ANALYSIS

#analytics #datascience #microsoft #productivity

Excel is a powerful spreadsheet program developed by Microsoft. It is used to organize, calculate, analyze, and visualize data using a grid of cells arranged in rows and columns.

HOW EXCEL IS USED IN REAL-WORLD DATA ANALYSIS

  1. Business Decision-MakingCompanies track historical sales, monitor KPIs, and evaluate regional or product-line performance.

  2. Financial Reporting and Budgeting-Finance professionals use Excel to manage corporate budgeting, historical revenue tracking, and financial modeling.

  3. Marketing Performance Analysis -Marketers evaluate the effectiveness of their campaigns by correlating advertising spend with consumer engagement and sales.

EXCEL FEATURES OR FORMULAS I HAVE LEARNED
i) Data validation
Data validation restricts the type of data or values users can enter into a cell. It is ideal for creating dropdown lists, limiting numerical ranges, or preventing typing errors.

Quick Steps to Set Up Data Validation

a)Select the cells where you want to apply the rule.

b)Go to the Data tab on the ribbon and click Data Validation.

c)In the dialog box, use the Settings tab to choose an Allow option (e.g., Whole Number, List, Date, or Text Length) and define the criteria.

d)Click the Input Message tab to display a helpful tip when the cell is selected.

f) Click the Error Alert tab to set a custom warning message if invalid data is entered.

g) Click OK.

ii) Countif
Countif is used to count the number of cells in a range that meet a specific condition or criteria.

=COUNTIF(range, criteria)
Enter fullscreen mode Exit fullscreen mode

For instance it can be used to count the number of employees whose salary is above ksh 100,000.

iii) Average
The AVERAGE function in Excel is used to calculate the average of the selected values.

=AVERAGE(A1: A20)
Enter fullscreen mode Exit fullscreen mode

Average can be used to calculate the avarage age of students in Grade 5.

Learning Excel has reshaped how I see data because it has shifted my perspective from raw information to structured insight. Instead of staring at endless rows of numbers, I am able to recognizing patterns, relationships, and possibilities.

For example Visualizing data reveals trends and outliers that raw numbers hide. Suddenly, I am able to tell a story using data.

Also I have learnt to summarize huge datasets into meaningful insights, shifting focus from detail to big-picture patterns.

Top comments (0)