Tutorials

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

Automating emails from Excel: The easiest way for HR to send employee bonus emails

Published: 2021/4/20 | 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 | 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

Updated: 2020/9/11 | Andrew Childress

When it comes to maximizing productivity and saving time, automated reports in Excel with Power Query are key. That’s why ...

Read more

Excel Power Query: The 5 Hacks for Business Intelligence You Should Have in Your Arsenal

Published: 2020/4/7 | Richard Shepherd

What is Excel Power Query? Using Power Query in Microsoft Excel opens up the possibility of unlocking invaluable Business Intelligence ...

Read more

The Complete Guide to Annual Compensation Reviews Using Google Sheets

Published: 2020/2/19 | Andrew Childress

Annual compensation reviews are a must. Reviewing and resetting employee salaries help you ensure that your employees are paid fairly. ...

Read more

How to Automate Employee Cell Phone Data Usage Analysis with Google Sheets (Free Template)

Published: 2019/12/3 | Brian Wochele

There’s no arguing the importance of having a good handle on your employee cell phone data usage, nor the many ...

Read more