Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002]
This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or no AI help on this one. Mandatory Training at Awesome Chocolates You are the head of L&D department at Awesome Chocolates. As part of employee induction, every new hire at […]
FREE Calendar & Planner Excel Template for 2026
Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for 2025.
Who is my boss’s boss? [Data Analytics Challenge – 001]
Let’s try something different. I will share a data analytics challenge here. Post your solutions in the comments. Our first challenge involves Employee Data Analysis. You can score maximum of 35 points. Imagine you have employee data in this “staff” table (in Excel / Power BI / SQL / Python or whatever tool you fancy) […]
New Zealand GST Calculation with Excel [Free Template]
If you operate a business in New Zealand (NZ) like me, chances are you too need to calculate GST on purchases & sales. Today, let me share the excel formulas needed to calculate GST as per NZ laws. I have also attached a free GST calculator template to help you if you are in a […]
Make a Pivot from Another Pivot Table in Excel
Recently, a client shared data with me that is clearly a pivot table and wanted me to make another pivot from it using Excel. This is a common and annoying problem we all face when working with Excel. Today, let me share my approaches for creating a pivot from another pivot report using Excel. Option […]
How to use XLOOKUP with two sheets?
Learn how to use Excel XLOOKUP function with two sheets in this step-by-step tutorial. Why you may want to use XLOOKUP with two sheets? If you have data in two places (sheets or Excel workbooks) like depicted above, you may want to use XLOOKUP to combine data from both places to get the full picture. […]
How to use XLOOKUP in Excel?
Think of XLOOKUP as an improved version of VLOOKUP. In this article, learn all about the XLOOKUP function, it’s syntax, parameters with real-world xlookup examples.