Project Management with Excel
Plan, schedule, budget and track one real project end to end: PERT estimates, workday schedules, critical path, S-curve, earned value, risk register and RAG status in 8 labs.
Business & Operations · 9 courses
Business and operations courses in Excel
Running a business is a stream of number questions: what to charge, how much stock to hold, whether a project is on budget, what a company is worth. These business courses answer them in Excel, with one realistic company per course and every cell checked as you work, so the result is a method you can reuse on your own data.
Business Plan Financials builds the projections lenders ask for, Startup Finance covers SaaS metrics, burn and the cap table, and Valuing & Buying a Small Business goes from SDE to deal structure. Pricing & Profitability covers price waterfalls, elasticity and customer profitability, and Sales & Marketing Analytics covers funnels, pipeline forecasts, commissions and RFM. Operations & Supply Chain teaches EOQ, safety stock and OEE, Project Management with Excel runs from PERT estimates to earned value, HR & People Analytics measures turnover and pay, and Economics for Business turns elasticity, inflation and exchange rates into numbers. The courses suit founders, managers, operations and sales staff, and business students.
Courses in Business & Operations
Operations & Supply Chain in Excel
Inventory KPIs, ABC, EOQ, safety stock, forecasting, capacity, landed cost and Lean metrics: 8 labs on one distributor's real-looking data.
Startup Finance & SaaS Metrics
Work out unit economics, MRR, churn, LTV:CAC, runway, a seed-round cap table and scenarios the way founders and investors do, with every cell checked as you go.
Sales & Marketing Analytics in Excel
Measure funnels, campaign ROI, pipeline forecasts, commissions, discounts, RFM segments, A/B tests and shop KPIs in real spreadsheets, with every cell checked as you go.
HR & People Analytics in Excel
Turn HR data into answers: headcount and FTE, turnover, tenure bands, pay analysis, payroll, recruiting and absence KPIs, every cell checked as you go.
Economics for Business in Excel
Supply and demand, elasticity, costs and profit, market power, inflation, interest rates, GDP and exchange rates: 8 labs that turn economics into numbers.
Pricing & Profitability Analysis
Price-volume trade-offs, price waterfalls, value-based pricing, elasticity, product and customer profitability, promotions and tiered pricing, in graded labs.
Valuing & Buying a Small Business
Value a $3.2m plumbing business from normalised SDE to multiples, working-capital peg, deal structure, DSCR, earn-out and a DCF cross-check, every formula checked live. Educational only, not investment advice.
Business Plan Financials in Excel
Build the numbers behind a real business plan for a café-roastery: startup costs, sales forecast, margins, staffing, P&L, cash flow, break-even and the ratios banks ask for – 8 labs, every cell checked instantly.
Guides with worked examples
EOQ Formula: Economic Order Quantity Example in Excel
The EOQ formula √(2DS/H) with a worked example in Excel: holding cost, orders per year, the cost curve, and why rounding to a pack size is fine.
Earned Value Formulas: CPI, SPI, EAC Worked Example
Earned value management formulas with one consistent example: PV, EV, AC, CV, SV, CPI, SPI, EAC, ETC, VAC and TCPI, calculated step by step in Excel.
LTV:CAC Ratio: How to Calculate It, With Example
How to calculate the LTV:CAC ratio: fully loaded CAC, LTV from gross margin and churn, CAC payback and the churn limit, in a worked Excel example.
Compa-Ratio: Formula, Excel Example and How to Read It
The compa-ratio formula (salary ÷ band midpoint) with an Excel example: lookups to the salary band, range penetration, group compa-ratio and review flags.
Break-Even Analysis in Excel: Formula and Example
Break-even analysis in Excel: break-even units and revenue, contribution margin, margin of safety and the volume for a profit target, with an example.
XLOOKUP vs VLOOKUP: Differences and When to Use Each
XLOOKUP vs VLOOKUP side by side: exact match defaults, lookups to the left, not-found values, approximate matches and compatibility, with a worked example.
Frequently asked questions
Are these courses useful for a small business owner?
Yes. The business plan, pricing, small business valuation and supply chain courses use small-company examples and produce numbers you can rebuild for your own business.
How much Excel do I need?
Basic formulas such as SUM, IF and percentages are enough. Lookups and SUMIFS are explained when they appear, and Excel for Finance is a free refresher.
Do the courses cover project management certifications?
Project Management with Excel teaches the calculations behind PERT, the critical path and earned value, which also appear in certification exams, but it is not an official exam preparation course.
More categories
Open your first lab in under a minute
Free lessons work without an account. Sign up to save your progress.