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.
- 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
- Your Day Rate: From Target Income to Day and Hourly RateFree
- Utilisation by Consultant: Who Is Billing Enough? Locked
- Engagement Budget: Hours × Rate by Role Locked
- Proposal Pricing: Discount and Margin Check Locked
- Timesheet to Invoice: Billable Hours × Rate Locked
- WIP and Realisation: What Was Billed of the Time Recorded Locked
- Budget Burn vs % Complete: Is the Project on Track? Locked
- Expenses Re-billing: Markup on Client Costs Locked
- Fixed Fee vs Time & Materials: Which Is Better for the Firm? Locked
- Client Profitability: Profit, Margin and Ranking Locked
- Pipeline: Weighted Revenue and the Gap to Target Locked
- Firm Dashboard: Fees vs Target, Chart and Utilisation Alerts Locked
- Monthly Retainers: Overage Hours, Total Billed and the Effective Hourly Rate Locked
- Subcontractors: Buy Rate, Sell Rate, Markup vs Margin and the Rate for a Target Margin Locked
- Estimating Better: Estimated vs Actual Hours by Type of Work and an Adjusted Proposal Locked
- Booking the Next Quarter: Working Days, Billable Capacity and Days Still to Sell Locked
- Unpaid Invoices: Due Dates, Days Overdue and an Ageing Table Locked
- Billing in Euros: Booked vs Received in Dollars, Bank Fees and the FX Result Locked
- Monthly Cash Flow: Clients Paying a Month Later, a Tax Set-Aside and the Lowest Balance Locked
- Final Project: Year-End Dashboard – Fees, Utilisation, Rate per Hour and Collections Locked
Learner reviews
Be the first to review this course.