Tutorials

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

How to Calculate Project Profitability Using Time Tracking Data: Everything You Need to Know [Excel Tutorial]

Published: 2022/7/19 | Updated: 2022/9/1 | 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

Budget vs Actuals Template: How to Effectively Manage a Budget in Microsoft Excel

Published: 2021/11/10 | Updated: 2022/9/1 | Tony De Jonker

As a financial controller, accountant, or CFO, you’re likely familiar with the concept of budget vs. actuals. You know that ...

Read more

Better Reporting: How to Use Google Sheets Pivot Tables, Column Stats, Explore, & QUERY Function to Wow Your Team

Published: 2021/9/15 | Updated: 2022/12/20 | 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

Automating Emails from Excel: The Easiest Way for HR to Send Employee Bonus Emails

Published: 2021/4/20 | Updated: 2022/9/1 | Szilvia Juhasz

“Annual compensation and bonus planning is easy, ” said no Human Resource professional, ever. That’s precisely why we’re going to ...

Read more

Excel Formulas Not Working: 5 Critical Examples of Checking & Fixing Workbooks

Published: 2021/3/16 | Updated: 2022/6/3 | Oz du Soleil

When it comes to working with data in Microsoft Excel, especially if it wasn’t your data to begin with, things ...

Read more

How to Build An Automated Report in Excel with Power Query: The Time Tracking Dashboard

Published: 2020/9/10 | Updated: 2022/12/20 | Andrew Childress

When it comes to maximizing productivity and saving time, automated reports in excel with Power Query are key. Reporting automation ...

Read more