How Excel is Used in Real-World Data Analysis

Ruto Kipkirui Robert — Sat, 06 Jun 2026 15:38:51 +0000

Introduction

In today's fast-paced business environments, data is considered the cornerstone of decision-making, policy formulation, and other organizational needs. MS Excel is a robust spreadsheet developed by Microsoft for organizing, analyzing, and visualizing data in rows and columns. In the data science and analytics domain, MS Excel is critical for analyzing and managing data to generate insights that enhance decision-making. Excel's polarity is characterized by its ease of use, flexibility, automation, and visualization.

Ways Excel Is Used in Real-World Data Analysis

Across the data science and analytics domain, MS Excel is frequently employed in the following ways;

a) Data Cleaning and Preprocessing

At the beginning of every data science and analytics project, data cleaning is required, and MS Excel is the primary tool. Typical Excel features and functions applied during data cleaning include Text to Columns, Remove Duplicates, Find and Replace, and Power Query.

b) Exploratory Data Analysis

Before performing data science and analytics activities, it is crucial to understand the dataset at hand, its structure, and trends. MS Excel features Pivot Tables, Pivot Charts, and Slicers that provide instant aggregation, sorting, and visualizations.

c) Data Analysis and Reporting

Modern organizations and businesses operate based on insights generated from data. MS Excel features such as pivot tables, charts, and conditional formatting help data analysts analyze and visualize data for clear, actionable insights that enhance decision-making.

MS Excel Features or Formulas

The typical MS Excel features and formulas employed in the data science and analytics domain include the following.

Data Cleaning Functions

Function	Purpose	Example	Result
`UPPER()`	Converts text to uppercase	`=UPPER("john")`	JOHN
`LOWER()`	Converts text to lowercase	`=LOWER("JOHN")`	john
`PROPER()`	Capitalizes the first letter of each word	`=PROPER("john doe")`	John Doe
`TRIM()`	Removes extra spaces from text	`=TRIM(" John Doe ")`	John Doe
`LEFT()`	Extracts characters from the left side	`=LEFT("John",2)`	Jo
`RIGHT()`	Extracts characters from the right side	`=RIGHT("John",2)`	hn
`MID()`	Extracts characters from the middle of the text	`=MID("John",2,2)`	oh
`LEN()`	Returns the number of characters in a text string	`=LEN("John")`	4
`FIND()`	Returns the position of a character or substring (case-sensitive)	`=FIND("o", "John")`	2
`SEARCH()`	Returns the position of a character or substring (not case-sensitive)	`=SEARCH("o", "JOHN")`	2
`SUBSTITUTE()`	Replaces specific text within a string	`=SUBSTITUTE("John Doe", "Doe", "Smith")`	John Smith
`REPLACE()`	Replaces text based on position	`=REPLACE("John Doe",6,3,"Smith")`	John Smith
`CONCAT()`	Combines multiple text strings	`=CONCAT("John"," ", "Doe")`	John Doe
`TEXTJOIN()`	Combines text with a specified delimiter	`=TEXTJOIN(", ", TRUE, "John", "Doe")`	John, Doe

Statistical Functions

Function	Purpose	Example	Result
`AVERAGE()`	Calculates the mean value	`=AVERAGE(B2:B10)`	Average of values
`MEDIAN()`	Returns the middle value	`=MEDIAN(B2:B10)`	Median value
`MODE()`	Returns the most frequent value	`=MODE(B2:B10)`	Most common value
`MIN()`	Returns the smallest value	`=MIN(B2:B10)`	Minimum value
`MAX()`	Returns the largest value	`=MAX(B2:B10)`	Maximum value
`COUNT()`	Counts cells containing numbers	`=COUNT(B2:B10)`	Number of numeric cells
`COUNTA()`	Counts non-empty cells	`=COUNTA(B2:B10)`	Number of filled cells
`COUNTBLANK()`	Counts empty cells	`=COUNTBLANK(B2:B10)`	Number of blank cells
`STDEV.S()`	Calculates sample standard deviation	`=STDEV.S(B2:B10)`	Sample variability
`STDEV.P()`	Calculates population standard deviation	`=STDEV.P(B2:B10)`	Population variability
`VAR.S()`	Sample variance	`=VAR.S(B2:B10)`	Sample variance
`VAR.P()`	Population variance	`=VAR.P(B2:B10)`	Population variance
`LARGE()`	Returns the nth largest value	`=LARGE(B2:B10,1)`	Largest value
`SMALL()`	Returns the nth smallest value	`=SMALL(B2:B10,1)`	Smallest value
`RANK()`	Returns the rank of a value	`=RANK(B2,B2:B10)`	Position in list
`PERCENTILE()`	Returns a percentile value	`=PERCENTILE(B2:B10,0.75)`	75th percentile

Personal Reflection

As a beginner data scientist, learning MS Excel as a foundational tool has changed how I interact with data. While previously I thought it was all about big tools like SQL and Python, I have come to appreciate that Excel is a source of clean datasets and can also be used at scale to generate insights that improve decision-making.

Git and Git Bash for Beginners

Ruto Kipkirui Robert — Sun, 25 Jan 2026 12:52:51 +0000

Git and Git Bash for Beginners
Introduction to Git Bash
Git Bash is a command-line tool that provides Git command-line functionality.
It enables developers to work in a Bash-like terminal environment while efficiently managing Git repositories.
It supports core Git operations such as cloning repositories, committing changes, pushing and pulling updates, and managing branches.
Overview of Git
Git is a distributed version control system (DVCS).
Git is a tool that helps you:
• save and manage different versions of your files and code.
• work with others, keep track of changes, and undo mistakes.
Git allows each developer to maintain a complete copy of a repository, including its full history, on their local machine.
This decentralized model improves performance, reliability, and collaboration.
Developers can work offline, experiment freely, and merge changes efficiently.
Why Use Git Bash?
Git Bash is widely used because of its compatibility, flexibility, and power.
It is fully compatible with Git and supports all Git commands.
Git Bash also offers a familiar environment for users transitioning from Linux or macOS to Windows, reducing the learning curve.
Installing Git Bash on Windows
Installing Git Bash involves downloading the Git for Windows installer and following a guided setup process. Users can select components, choose an installation directory, and complete the installation. Once installed, Git Bash can be launched from the Start menu or desktop shortcut.
Basic Git Bash Commands
Git Bash supports Git commands that help users navigate directories, manage files, and control version history.
Common Navigation Commands:

ls – Lists files and directories
cd – Changes the current directory
pwd – Displays the current working directory Common Git Commands:
git init – Initializes a Git repository
git status – Displays repository status
git add. – Stages all changes
git commit -m "message" – Commits changes
git log – Displays commit history Using Git Bash: Basic Workflow Using Git Bash begins by configuring Git with a username and email address. After configuration, users navigate to a project directory, initialize a repository, stage files, and commit changes. Key Commands: git config --global user.name "Your Name" git config --global user.email "you@example.com" Connecting Local Repositories to GitHub Git Bash allows users to link local repositories to remote GitHub repositories. This enables pushing local changes to GitHub and pulling updates from collaborators. Key Commands: git remote add origin git push origin master Branch Management in Git Bash Branches allow multiple developers to work on different features independently. Git Bash supports creating, switching, listing, and deleting branches. Key Commands:
git branch – Lists branches
git branch branch_name – Creates a new branch
git checkout -b branch_name – Creates and switches to a branch Merging and Cloning Repositories Merging combines changes from one branch into another, ensuring code integration. Cloning creates a local copy of a remote repository. Key Commands: git merge branch_name git clone Undoing Commits Git Bash allows users to modify the most recent commit using the --amend option. This is useful when files are missed or commit messages need correction. Key Command: git commit --amend Conclusion Git Bash is a powerful and flexible tool that enables. It supports version control, collaboration, automation, and branch management. With its combination of Git commands and Bash utilities, Git Bash remains an essential tool for developers seeking efficiency and control in modern software development environments.

DEV Community: Ruto Kipkirui Robert