๐ข Level 1
Beginner Sheets
Focus: Data entry, basic formatting, standard arithmetic, and essential functions (SUM, AVERAGE, COUNT).
Sheet 01
Personal Daily Expense Tracker
Logs daily spending categories and calculates total monthly expenditure.
Open โ
Sheet 02
Simple Student Marksheet
Records subject marks, computes total marks, and finds maximum and minimum scores.
Open โ
Sheet 03
Basic Contact / Address Directory
Formats and organizes clean tabular lists of contacts.
Open โ
Sheet 04
Shopping & Grocery List
Keeps track of items, unit quantities, unit prices, and overall total cost.
Open โ
Sheet 05
Time Log / Simple Hours Tracker
Records start and end times and calculates total hours worked.
Open โ
๐ต Level 2
Intermediate Sheets
Focus: Conditional logic (IF), data aggregation (COUNTIF, SUMIF), lookups (VLOOKUP, XLOOKUP), data validation, and basic formatting rules.
Sheet 06
Automated Student Grade Sheet
Uses nested IF or IFS formulas to automatically calculate letter grades and pass/fail statuses.
Open โ
Sheet 07
Monthly Employee Attendance Sheet
Uses Data Validation drop-downs (P/A/L), COUNTIF functions, and Conditional Formatting for visual highlights.
Open โ
Sheet 08
Basic Payroll / Salary Sheet
Computes gross salary, allowances (HRA, DA), statutory deductions (PF, ESI), and final net pay.
Coming soonSheet 09
Inventory Stock Control Tracker
Tracks opening stock, stock-in, stock-out, current balance, and triggers Reorder warnings using IF.
Coming soonSheet 10
Invoice & Billing Generator
Combines customer details and product catalogs using VLOOKUP/XLOOKUP, with tax calculations (GST/VAT) and automated sub-totals.
Coming soon๐ฃ Level 3
Upper-Intermediate Sheets
Focus: Data modeling, dynamic aggregation, multi-sheet linking, PivotTables, and statistical analysis.
Sheet 11
Interactive Sales Performance Dashboard
Uses PivotTables, PivotCharts, and Slicers to filter sales by region, product, and sales rep.
Coming soonSheet 12
Budget vs. Actual Variance Sheet
Compares projected monthly budgets against actual spending, calculating variance values and percentages.
Coming soonSheet 13
Loan EMI & Amortization Schedule
Uses PMT, IPMT, and PPMT to break down monthly principal vs. interest payments.
Coming soonSheet 14
Task & Project Tracker
Uses TODAY(), conditional formatting, and formula logic to build dynamic progress status bars and milestone trackers.
Coming soonSheet 15
Leave & Paid Time Off (PTO) Tracker
Tracks accrued employee leave balances, taken leaves, and remaining quota across multiple months.
Coming soon๐ด Level 4
Advanced Sheets
Focus: Power Query (ETL), Power Pivot (DAX), advanced scenario modeling, dynamic arrays (FILTER, SORT, UNIQUE), and Macros/VBA.
Sheet 16
Dynamic Executive Financial Dashboard
Consolidates multi-departmental data into a high-level summary with interactive dynamic array controls.
Coming soonSheet 17
Comprehensive P&L & Cash Flow Statement
Connects balance sheets, income statements, and cash flows using multi-table data modeling.
Coming soonSheet 18
Financial Sensitivity & Scenario Sheet
Uses Goal Seek, Data Tables, and Scenario Manager for financial forecasting and risk modeling.
Coming soonSheet 19
Automated Data Cleaning & ETL Pipeline
Uses Power Query to automatically import, clean, unpivot, and transform external raw files (CSV/Database exports).
Coming soonSheet 20
VBA/Macro Automated Form System
Uses user forms, custom buttons, and VBA macros to automate data entry, file saving, and report generation.
Coming soon