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

Published: 2023/9/5 | Andrew Childress

Today we’re talking project cost management with adjustable forecasting and the Excel OFFSET function. Follow along below, or watch the ...

Read more

Python for finance: Unlocking the power of data analysis

Published: 2023/7/4 | Yves J. Hilpisch

Are you exploring the intriguing world of python for finance? Whether you aspire to work in the financial industry, or ...

Read more

Contractor payments and pay reports made easy with Beebole

Published: 2023/2/28 | Andrew Childress

If you have a team of contractors, paying them in a timely manner is a must. You need a speedy ...

Read more

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

Published: 2022/7/19 | Andrew Childress

If you bill clients based on the time you spend, here’s a pop quiz: which projects make the most money? ...

Read more

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

Published: 2021/11/10 | Tony De Jonker

In this tutorial, learn how to create a budget vs. actuals report in Excel using Power Query. Gain insights and ...

Read more

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

Published: 2021/9/15 | David Benaim

As a manager, perhaps you’ve wondered how to take your financial reporting to the next level or how to amp ...

Read more