Excel Projects for Practice (2026)

Excel practice projects built on real business problems: inventory planners, ad ROI trackers, loan schedules, risk registers and dashboards with XLOOKUP, pivots and dynamic arrays.

25 projects: 12 beginner, 8 intermediate, 5 advanced. Every step is checked as you go, an AI mentor helps when you are stuck, and you finish with a verifiable certificate.

Excel projects

Risk Register Dashboards in Power BI — Develop a robust understanding of Power BI's features and functionalities, including data transformation, visualization techniques, and best practices for dashboard creation. (beginner · $1)
Excel Foundations: Build a Café Expense Tracker — Learn Excel from zero by building a café's expense tracker and budget: formulas, references, Tables, SUMIF and charts. Then direct your own AI to do it, and catch what it gets wrong. (beginner · $1)
Data-Driven Decision Making: Excel and SQL for Business Analysts — Follow business analyst Renata Cruz as she uses Excel, pivot tables, and SQL to answer real Cobalt Bicycles questions - and catch the analysis mistakes that mislead decisions. (beginner · $1.25)
Building a Three-Statement Financial Model in Excel — Follow a corporate finance analyst building a linked 3-statement Excel model under a loan deadline -- driver-based forecasts, a debt schedule, circularity, and stress testing. (intermediate · $1.25)
Build a Payroll Register with PF, ESI and TDS in Excel — Learn Excel payroll by building a factory's register: loss of pay, PF, ESI, TDS and net pay with XLOOKUP, ROUND, MIN, IF and VLOOKUP. Then direct your own AI and catch what it gets wrong. (beginner · $1)
Loan EMI Schedule in Excel: A Delivery Van Loan with Prepayment — Model a van loan in Excel: EMI with PMT, a repayment schedule, interest by financial year, a prepayment and a flat-rate offer decoded with RATE. Then direct your AI and catch its mistakes. (beginner · $1)
Sales Pipeline Cleanup and Weighted Forecast in Excel — Clean a CRM export and build a weighted sales forecast in Excel: text amounts, duplicates, stage names, win rate, stale deals and coverage. Then direct your own AI to do it, and catch its mistakes. (beginner · $1)
Automating Excel with LAMBDA and VBA: A Month-End Reconciliation — Build a bank reconciliation that proves itself to zero with LET, LAMBDA and one-to-one matching, automate the auditors' report in VBA, then direct your own AI to close the next month. (advanced · $2)
Build a Clinic Attendance and Leave Tracker in Excel — Learn Excel for HR by building a clinic's attendance and leave tracker: COUNTIF, mixed references, NETWORKDAYS.INTL, SUMIFS and XLOOKUP. Then direct your own AI to do it, and catch what it gets wrong. (beginner · $1)
Build a Warehouse Shift Roster and Staffing Plan in Excel — Learn Excel for operations by building a warehouse timesheet, overtime pay and shift staffing plan. Then direct your own AI to do the same job, and catch what it gets wrong. (intermediate · $1.25)
Clean and Summarise Messy Sales Data in Excel — Help Maya turn a messy online-shop export into revenue, margin and channel numbers an investor can trust, then direct your own AI to do it again and catch what it gets wrong. (beginner · $1)
GST Sales Register and GSTR-3B Summary in Excel — Build a GST sales register in Excel: rates by lookup, place of supply, CGST and SGST or IGST, credit notes and a GSTR-3B Table 3.1 summary. Then direct your own AI and catch what it gets wrong. (intermediate · $1.25)
PivotTables and Dashboards: Build an Operations KPI Dashboard — Replace a hand-typed weekly KPI email with a refreshable Excel dashboard: PivotTables, calculated fields, slicers, timelines and GETPIVOTDATA, then hand next quarter to your AI and verify it. (intermediate · $1.25)
Power Query and the Data Model: Consolidate a Multi-Branch Business — Replace three days of copy-paste with a refreshable Power Query and Data Model report for four branches, then brief your AI to add July and catch what it gets wrong. (advanced · $2)
Ad-Campaign ROI Tracker in Excel: CPL, CAC and ROAS — Build a gym chain's ad-campaign ROI tracker in Excel: CPL, CAC, ROAS, ROI, break-even and profit per campaign. Then direct your own AI to do it, and catch its mistakes. (beginner · $1)
Asset Inventory and Exposure Review from Your Own Records — Reconcile a CMDB, DHCP leases and firewall rules in Excel to find unmanaged devices, unowned assets and internet exposure, then brief the IT lead. (beginner · $2)
Budget vs Actual in Excel: Variance Analysis for a Bakery — Build a bakery's monthly budget-vs-actual report from its ledger: lookups, SUMIFS, variance %, F/A flags, materiality and a flexed budget. Then direct your own AI and catch its mistakes. (beginner · $1)
DCF Valuation in Excel: A D2C Brand with Scenarios and a Sensitivity Table — Value a D2C skincare brand with a full DCF in Excel: clean base year, free cash flow, WACC, terminal value, scenarios and Data Tables. Then direct your AI and catch its mistakes. (advanced · $2)
Dynamic Arrays and What-If Analysis: Build an Inventory Reorder Planner — Build an Excel inventory reorder planner with FILTER, XLOOKUP, LET, Goal Seek and Data Tables, then direct your AI to do the same job and catch what it gets wrong. (intermediate · $1.25)
Plan a Store Launch in Excel: Schedule, Critical Path and Earned Value — Build a retail store-launch schedule in Excel with the critical path method, working-day dates and earned value. Then direct your own AI through a second launch and catch what it gets wrong. (advanced · $2)
Risk Register and Board Pack: Quantify Cyber Risk — Build a quantified cyber risk register (SLE, ARO, ALE), decide treatments with ROSI, cost the controls in Excel and brief the board in one page. (intermediate · $3)
Capstone: Secure Cloud Architecture Review — Review a cloud migration end to end: 6R strategies, BCDR patterns, a peer review, a target-architecture diagram, the cost case and a board-ready review. (advanced · $3)
Password Policy Audit Against NIST SP 800-63B — Audit a company's password settings and account metadata against NIST guidance in Excel, then write the remediation memo. No passwords, no hashes, no cracking. (beginner · $2)
Patch Priority Board: CVSS, KEV, SLAs and ATT&CK in Excel — Turn a vulnerability-management export into a ranked remediation plan: environmental adjustment, KEV first, SLA days left and ATT&CK mapping. (intermediate · $2)
Ransomware: Readiness, Response Decisions & Recovery — Assess a hospital group's ransomware readiness against NIST IR 8374 and CIS, plan backups and recovery, make the tabletop decisions (CERT-In, DPDP, payment) and write the communications. (intermediate · $3)

Practise Excel more

Free Excel lab: A spreadsheet in your browser for practice. No login.
Excel course: Excel from beginner to advanced: formulas, pivots, dynamic arrays and dashboards.
Data analyst job simulation: A simulated analyst workday: real requests, real data, scored work.

Frequently asked questions

Which Excel skills do these projects practise?

Lookups (XLOOKUP), pivot tables, conditional formatting, dynamic arrays, what-if analysis and charts, each in a workbook that is checked when you finish a step.

Do I need to install anything for these Excel projects?

Most projects run in labs inside your browser (SQL, Excel, Python, Power BI, Git and more). Cloud projects say up front when they use your own AWS account or a simulator instead.

How is a Bartman project different from a tutorial?

You do the work yourself, step by step. Each step is checked automatically, and an AI mentor helps when you are stuck, so you finish with work you can show rather than a video you watched.

Do I get a certificate?

Yes. Finishing a project earns a certificate with its own ID that anyone can verify on bartman.ai.

What is Bartman?

Bartman (bartman.ai) is a learning platform where you build real projects with an AI mentor, practise in free browser labs, take mock tests and practice exams, and run job simulations. It was founded in 2025 and is based in Hyderabad, India.