Chandoo.org – Learn Excel, Power BI & Charting Online

This week, let’s try something new.

Here is a fabulous New Year gift to you.

Let’s try something different.

If you operate a business in New Zealand (NZ) like me, chances are you too need to calculate GST on purchases & sales.

Recently, a client shared data with me that is clearly a pivot table and wanted me to make another pivot from it using Excel.

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

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