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 […]

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. […]

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.

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? Method 1: Merge CSV Files using Power Query (Recommended) This is by far […]

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: This opens the Excel Options. From here, Check the “Developer” option in the right side panel Step 4: Click ok. Your developer ribbon is now […]

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 […]

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 […]