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 […]
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 […]
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.
Excel IF Statement Two Conditions
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 when you start combining it with multiple conditions — especially using AND, OR, nested IFs, and even blending it with SUMIFS. In this article, let […]
How to insert dates in Excel automatically
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 Drag down This is the easiest option if you just want a handful of dates. Just type in your starting date in a cell. Click […]
How to find duplicate values in two columns in Excel using formula
Let’s say you have two lists of values in Excel and want to find out all the common values (ie duplicates) and extract them. In this article, let me explain the formulas for this. Formula for counting number of duplicate values in two columns: Here is the formula to count number of common values between […]