Tutorials

Dive into our tips and how-tos on spreadsheets, Excel and more. For finance controllers, accountants and HR managers.

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 […]

Python for finance: Unlocking the power of data analysis

Are you exploring the intriguing world of python for finance? Whether you aspire to work in the financial industry, or wish to advance your existing career, mastering Python is a key step forward. In today’s fast-paced financial arena, Python programming is a crucial skill that top institutions seek in their professionals. Dive into this article […]

Contractor payments and pay reports made easy with Beebole

If you have a team of contractors, paying them in a timely manner is a must. You need a speedy workflow to review submitted hours, analyze your contractors’ work, and set up a payment to them. Many contractors work on hourly arrangements. That means it’s important to not only measure their time, but pay them […]

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 […]

How to use Google Sheets’ pivot tables, column stats, explore, & QUERY function

As a manager, perhaps you’ve wondered how to take your financial reporting to the next level or how to amp up your data analysis skills. Maybe you’ve got an important meeting coming up, or you’d simply like to wow the executives on your next run-through. Whatever the reason, this tutorial is sure to help. We’re […]