🗓️ Mock Practice — Excel Analysis (October 7, 2025) Demonstrates end-to-end Excel workflows for data formatting, lookup functions, and cleaning.
Date: October 7, 2025
Focus: Conditional Formatting, Lookup Functions, and Data Cleaning
This practice project simulates real-world Excel data analysis and cleaning workflows.
It covers three key skill areas:
- Conditional Formatting — visualizing data with heat maps, icon sets, and rules.
- Lookup Functions — using
VLOOKUPandINDEX-MATCHfor data referencing. - Data Cleaning — applying formulas and logical rules to create a final, analysis-ready dataset.
| File | Description |
|---|---|
raw_data.xlsx |
Original unprocessed dataset used as the base for all exercises. |
conditional_formatting_practice.xlsx |
Conditional formatting drills including top 10% highlights, heat maps, icon sets, and combined rules. |
cleaned_data_final.xlsx |
Final cleaned dataset after applying logical rules, standardizing formats, and fixing missing values. |
_cleaning_log.xlsx |
Step-by-step documentation of the cleaning process with reflections on formulas and transformations. |
-
Conditional Formatting
- Top 10% rules and icon sets
- Combined logical rules using formulas (
AND,OR) - Custom 3-color heat maps
-
Lookup Functions
VLOOKUPfor vertical referencingINDEX+MATCHfor flexible lookups
-
Data Cleaning
- Case normalization (
PROPER,UPPER,LOWER) - Date standardization (
TEXT,DATEVALUE) - Logical replacements for missing values (
IF,ISBLANK)
- Case normalization (
This exercise improved my ability to:
- Combine multiple Excel functions in realistic cleaning scenarios.
- Structure workbooks into professional pipelines (raw → cleaned → log).
- Document cleaning steps clearly for reproducibility.
excel · data-cleaning · vlookup · index-match · conditional-formatting · mock-practice · excel-analysis
This repository is part of my ongoing Excel practice series documenting my daily learning progress and skill development in data analysis.