Excel’s XLOOKUP – 5 Examples

Excel's XLOOKUP 5 Examples By now, you may have read about Excel’s new super lookup function called XLOOKUP. XLOOKUP has the promise of becoming the only lookup function you’ll ever need for virtually any lookup problem you encounter.  This will be a

Excel Lookup to the Left with XLOOKUP

Left Lookup in Excel with XLOOKUP (made easy) When users learn to perform a lookup in Excel, it doesn’t take long before a situation arises that causes the user to ask… “How do I perform a lookup to the LEFT?” Because most

Excel XLookup Explained

Excel XLOOKUP Explained (Goodbye VLOOKUP!) In this post, we will examine Excel’s BEST function for performing a lookup… We’re going to look at how the new (upcoming) XLOOKUP function solves common lookup problems typically solved by older functions like… LOOKUP VLOOKUP HLOOKUP

Excel Functions for Accounting

Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

Excel SPILL Error

What is the Excel Spill error and how can you fix it? Sometimes it's obvious but sometimes it's not clear why you get this error. Find out why and how to fix it in this article.

Excel Functions Office 365

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

Excel vs. Google Sheets

Let's take a look at 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

Excel IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

Excel Hidden Dashboard Tips

You can spend a lot of time on design and formatting when you create dashboards in Excel. Discover 4 hidden tips that will make the process a lot easier.

Multiple Searchable Drop-Down Lists in Excel

Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it easier to find an item from a large data validation list. We finally get to make this with simple formulas.