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.

Option 1: If you have access to “original” data

Ha, I know, but we...

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

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

What is XLOOKUP?

Using XLOOKUP, we can search for an item in a list using the lookup value and return a matching item. For example, you can lookup for salesperson “Jackie” and return their sales amount from the data below us...

Have a bunch of CSV files in a folder and want to merge or combine them to one big file? Follow these simple instructions to combine multiple CSV files in to one spreadssheet using Microsoft Excel (2016 or above).

What you need? A folder with CSV files (click here to download sample files, if you need some) Microsoft Excel (2016 or above version) Me...