Getting Started with Excel for Data Analytics: From Basics to Data Cleaning.

Bonny Mark — Thu, 27 Aug 2026 06:57:51 +0000

Introduction to Microsoft Excel

Microsoft excel is used for storing, organizing, cleaning, analyzing and presenting data. It provides a structured environment where users can enter data into rows and columns, perform calculations using formulas and functions, create charts, and apply formatting to make information easier to understand.

The Excel Interface: Home Tab Breakdown

Quick Access Toolbar

Save icon- Save icon or you can Ctrl + S
Undo / Redo arrows-step backward or forward through your recent actions.
File name- shows the name of the current file in excel.
Search bar-lets you search for any Excel command by typing what you want to do.

Tabs
At the top holds most commomon tools used in excel: File, Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help.

Home Tab Groups

Clipboard part we have the Paste,cut and Format Painter.

Fonts part we have the font name needed to use and its font size,below it we have bold,italic,underline ,borders,Theme colors which helps change colors of the headings,we also can increase or reduce the size of the heading with the "A"

Alignment part we have Vertical alignment ** (top/middle/bottom),Horizontal alignment** (left/center/right),Wrap Text — makes long text fit into one cell and Merge & Center — combines multiple cells as one, often used with title headings.

Styles part we have Preset cell styles: Normal, Bad (red), Good (green), Neutral (yellow), Calculation, Check Cell,
Conditional Formatting — highlights cells automatically based on rules and Format as Table — turns a range into a structured, filterable table.

Cells we have the Insert, Delete, Format which add/remove rows, column or sheets and adjust row height/column width or lock cells.

Editing part we have AutoSum (Σ) — quick shortcut to insert SUM, AVERAGE,MIN, MAX, COUNT and more options, Fill ** extends a value or formula across a range, **Sort & Filter is a tool behind sorting data and removing blanks and duplicates, Find & Select — search the sheet, or jump to special cells.

GIT WORKFLOW

Bonny Mark — Wed, 26 Aug 2026 15:12:57 +0000

##How it all Operates

I worked a path from creating an empty folder to a live repository,using Git Bash,powershell and SHH authentication insted of typing in the password each time i'm pushing aproject to github.

Where this is going

steps followed in each order?

Create a GitHub account
Set up a project folder
Generate an SSH key
Register the key with GitHub
Create a repo and link your local folder to it

Get a GitHub account

If you don't already have one, head to github.com and sign up — email and your password.

Set up a project folder

Open git bash and enter this commands:

cd Desktop
mkdir my-project
cd my-project

once you're inside your project add a sub folder of data or scripts by running this command:

mkdir data

Inside the the folder we add a READNE.md file by running this command:

touch README.md

Generate an SSH key

Open PowerShell as Administrator first, just to confirm Git is actually installed:

git --version

You'll see averion of the git you have installed if you don't install one before moving to the next step.
Then switch to Git bash and generate the key:

ssh-keygen -t ed25519 -C "your_email@example.com"

We get where to save it and prompted to set a passphrase,you can add a passphrase or skip it and while adding you won't see it add it will be added once you type.

Back to powershell as Administrator:

Get-Service -Name ssh-agent

Start-Service ssh-agent

On powershell close that admin window and open a regular PowerShell window. Add your key to the running agent:

ssh-add C:/Users/YOUR_USERNAME/.ssh/id_ed25519

Add SSH key to GitHub account

copy it manually from you git bash.

On GitHub, go to Settings → SSH and GPG keys → New SSH key. Give it a descriptive title (your PC name) leave the key type as Authentication Key, paste in what you copied and save.

Back in Git Bash, inside your project folder run this commands:

git init

git remote add origin git@github.com

git add .

git commit -m " "

Meaning of each command that helps push a project to gitHub:

git init turns the folder into a Git repository.

git add . adds everything in the current directory for the next commit.

git commit -m "..." saves it with the message described.

git push -u origin main sends your commits to GitHub and links your local

DEV Community: Bonny Mark