Excel Projects Portfolio

Welcome to my Excel Projects Portfolio — a curated collection of practical projects built in Microsoft Excel. These projects highlight my skills in advanced spreadsheet design, formula logic, data visualization, and automation using Excel's built-in features.

Each folder contains a real-world scenario, ranging from payroll calculations to performance grading systems. These projects apply key Excel functions like conditional logic, absolute referencing, and data visualization to solve tasks efficiently and accurately.

---

Projects

1. Payroll Project

Folder: /payroll/   A complete payroll management system built in Excel.

• Calculated employee pay using Hourly Wage × Hours Worked
• Applied IF statements to compute overtime hours and bonuses.
• Used absolute referencing for formula consistency across multiple days.
• Generated summary statistics: MAX, MIN, AVERAGE, and TOTAL
• Scaled for the entire month of January.
• Screenshots and documentation included.

See full project →

---

2. Gradebook Project

Folder: /gradebook/   An employee grading system with performance tracking and chart visualizations.

• Used orientation to rotate column headers.
• Applied conditional formatting (Highlight Rules + Icon Sets).
• Used the OR function to determine termination conditions.
• Created charts to visualize test results and trends.
• Identified top and bottom performers at a glance.

See full project →

---

Skills Demonstrated

• Excel formulas: IF, OR, AND
• Absolute and relative cell referencing
• Conditional formatting
• Summary statistics
• Data visualization using charts
• Spreadsheet design and layout optimization

---

How to View

Each folder contains:

• The Excel file (.xlsx)
• A project-specific README.md with details and screenshots.
• A .assets/ folder containing visual resources.

---

3. Sales Database Project

Folder: /salesdatabase/   A data-driven solution to manage and analyze sales records. Includes structured cleanup using text functions, conditional logic for totals, and pivot tables and charts for business insights.

• Text to Columns for splitting combined entries
• IF and SUMIF for sales logic and conditions
• Dynamic sorting, filtering, and formatting
• Pivot tables and pie charts for visualization

See full project →

---

How to View

Each folder contains:

• The Excel file (.xlsx)
• A project-specific README.md with details and screenshots.
• A .assets/ folder containing visual resources.

---

About

Author: @skiosmith   Focus Areas: Excel automation, data reporting, and real-world business analysis using Microsoft Excel.

This repository is actively maintained. More Excel projects and enhancements (including screenshots and advanced formula breakdowns) will be added soon.

---

Feel free to explore the projects, leave feedback, or connect with me on GitHub!