Tabellab

Excel for Consultants & Freelance Advisors: Rates, Utilisation, Proposals & Billing

20 hands-on labs following one small advisory firm: day rate from target income, utilisation, engagement budgets, proposal pricing, timesheet to invoice, WIP and realisation, budget burn, expense re-billing, fixed fee vs T&M, client profitability, pipeline and a partner dashboard – then retainers and overage, subcontractor markup vs margin, estimate accuracy, next-quarter capacity, invoice ageing, euro invoices, a monthly cash flow and a year-end dashboard.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course follows one small fictional advisory firm through 20 hands-on Excel labs. You set a day rate from a target income, measure utilisation, build engagement budgets, price proposals and check the margin, turn timesheets into invoices, track WIP and realisation, budget burn, expense re-billing, fixed fee versus time and materials, client profitability, a weighted pipeline and a partner dashboard. The second half adds the day-to-day money questions: monthly retainers with overage hours, subcontractor markup versus margin, how far estimates usually run over, the working days and capacity of the next quarter, unpaid invoices in an ageing table, euro invoices and exchange-rate results, a monthly cash flow with a tax set-aside and a year-end dashboard with a combo chart. Every cell is checked instantly; all figures are fictional.

Lessons

  1. Your Day Rate: From Target Income to Day and Hourly RateLabFree
  2. Utilisation by Consultant: Who Is Billing Enough?Lab Locked
  3. Engagement Budget: Hours × Rate by RoleLab Locked
  4. Proposal Pricing: Discount and Margin CheckLab Locked
  5. Timesheet to Invoice: Billable Hours × RateLab Locked
  6. WIP and Realisation: What Was Billed of the Time RecordedLab Locked
  7. Budget Burn vs % Complete: Is the Project on Track?Lab Locked
  8. Expenses Re-billing: Markup on Client CostsLab Locked
  9. Fixed Fee vs Time & Materials: Which Is Better for the Firm?Lab Locked
  10. Client Profitability: Profit, Margin and RankingLab Locked
  11. Pipeline: Weighted Revenue and the Gap to TargetLab Locked
  12. Firm Dashboard: Fees vs Target, Chart and Utilisation AlertsLab Locked
  13. Monthly Retainers: Overage Hours, Total Billed and the Effective Hourly RateLab Locked
  14. Subcontractors: Buy Rate, Sell Rate, Markup vs Margin and the Rate for a Target MarginLab Locked
  15. Estimating Better: Estimated vs Actual Hours by Type of Work and an Adjusted ProposalLab Locked
  16. Booking the Next Quarter: Working Days, Billable Capacity and Days Still to SellLab Locked
  17. Unpaid Invoices: Due Dates, Days Overdue and an Ageing TableLab Locked
  18. Billing in Euros: Booked vs Received in Dollars, Bank Fees and the FX ResultLab Locked
  19. Monthly Cash Flow: Clients Paying a Month Later, a Tax Set-Aside and the Lowest BalanceLab Locked
  20. Final Project: Year-End Dashboard – Fees, Utilisation, Rate per Hour and CollectionsLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy