Welcome!
This repository contains 80+ Excel practice files created by me while learning and mastering Microsoft Excel.
It covers everything from basic formulas to advanced data analysis, pivot tables, and dashboards.
| Category | Details |
|---|---|
| 📝 Formulas & Functions | SUM, IF, VLOOKUP, HLOOKUP, INDEX-MATCH, and more |
| 🎨 Formatting | Conditional formatting, number & text formatting |
| 📊 Charts & Graphs | Bar, Line, Pie, Combo charts |
| 🔄 Pivot Tables & Charts | Pivot analysis, Pivot charts, Data summarization |
| 🧹 Data Cleaning | Sorting, filtering, removing duplicates, text-to-columns |
| 📈 Dashboards | Interactive dashboards, KPI reports, visualizations |
| 📉 Data Analysis | Trend analysis, calculations, scenario testing |
| File Name | Description |
|---|---|
Sales_Data_Analysis.xlsx |
Analyzing sales data with formulas, charts, and pivot tables |
Employee_Performance.xlsx |
Employee performance tracking with conditional formatting & charts |
Budget_Planner.xlsx |
Personal/Project budget planning with formulas and summaries |
Dashboard_Project.xlsx |
Interactive dashboard with key metrics & graphs |
Data_Cleaning_Practice.xlsx |
Data cleaning exercises: duplicates, sorting, text-to-columns |
sales_dataset_10000_with_products (1).csv.xlsx |
Marketing campaign analysis with visualizations & formulas |
M.I.S project.xlsx |
Project tracking and timeline charts with conditional formatting |
- Practice Excel skills from beginner to advanced
- Explore data analysis and visual reporting
- Build a personal portfolio of Excel exercises
- Showcase hands-on Excel experience
- Excel files
- Covers all major Excel concepts
- Includes realistic exercises and mini-projects
- Created for self-learning and skill development
Ramesh Kumar
- Passionate about data analysis & Excel
- Constantly learning & improving technical skills
If you find this repository useful or inspiring, please star ⭐ it!
Your support motivates me to continue learning and sharing.