Articles tagged as: "templates"

Project cost management: Adjustable forecasting and the Excel OFFSET function

Today we’re talking project cost management with adjustable forecasting and the Excel OFFSET function. Follow along below, or watch the tutorial on YouTube by clicking here. The first time you heard about a forecast, it probably had nothing to do with project cost management. The team of weather experts behind that forecast used a range […]

The true cost of employees: Calculate employee cost with this labor cost spreadsheet

Understanding the true cost of employees is crucial for any business looking to manage resources effectively. That’s why we’ve created this free spreadsheet download and video tutorial with detailed instructions and formulas to easily calculate employee cost at your company, as well as to forecast new hires. It’s more than just base salaries; it encapsulates […]

Finance controller KPIs that every professional should master [the webinar + the Excel]

The complete list of finance controller KPIs: Webinar + Formulas + Excel included. By The FP&A Guy, Paul Barnhurst.

How to calculate project profitability using time tracking data: Everything you need to know [Excel tutorial]

If you bill clients based on the time you spend, here’s a pop quiz: which projects make the most money? Or even more importantly: which projects aren’t profitable? If you don’t know the answer to these questions, it’s time to start thinking about project profitability, a measurement of revenue billed versus time and cost expended. […]

Mastering budget vs. actuals analysis: Excel Power Query tutorial + FREE template

In this tutorial, learn how to create a budget vs. actuals report in Excel using Power Query. Gain insights and track financial performance effortlessly. As a financial controller, accountant, or CFO, you’re likely familiar with the concept of budget vs. actuals. You know that reporting budget vs. actuals can be both cumbersome and time-consuming, given […]