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…

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…

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…

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…

Do you want to enable developer ribbon and use VBA in Excel? Follow these simple steps: Step 1: Right click any ribbon name Step 2: Select “Customize Ribbon” Step 3:…

You want to check two conditions with Excel IF function? You’ve come to the right place. IF is one of Excel’s most popular and versatile functions. But things get exciting…

Which student got the top score? If you have test results, or another list of numbers in Excel, you could sort them to see which scores are at the top.…

Ever wanted to get a set of dates, but don’t want to manually type? Here are three ways to insert dates in Excel automatically. Option1: Enter a start date and…

SVG (Scalable Vector Graphics) is a great way to add a bit of flavor and pizzazz to your boring Power BI reports. I have been using them for a while…

In the olden days of computing, some programs, including Excel, had hidden features called Easter eggs, so here’s a quiz for you. Quick Quiz: Which version of Excel had a…