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)

fetchpriority="high" deco...

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 hurry.

How to calculate NZ GST using Excel?

Assuming you have the sale price in cel...

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.

fetchpriority="high" decoding="async" width="1321" height="611" src="ht...

Learn how to use Excel XLOOKUP function with two sheets in this step-by-step tutorial.

fetchpriority="high" decoding="async" width="824" height="664" src="https://chandoo.org/wp/wp-content/uploads/2025/06/SNAG-0152.png" alt="xlookup across two sheets" class="wp-image...

In this article, learn all about the XLOOKUP Excel function, it’s syntax, parameters and how to use it with real-world xlookup examples.

fetchpriority="high" decoding="async" width="1316" height="630" src="https://chandoo.org/wp/wp-content/uploads/2024/03/SNAG-0041.png" alt="Xlookup example with syntax =XLOOKUP(lookup_vaule, lookup_array, return_array)" class="wp...