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…

To quickly combine text and numbers from multiple cells in Excel, use the TEXTJOIN Excel function. I’ll show you two examples, and you can scroll down to watch the video…

1. Introduction Insurance is a perfect industry for data analysis. There is plenty of data – right from lead generation to to underwriting to policy issuance to administration to claims…