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).

Yearly Calendar in Excel with Formula

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

Excel Filter Function Trick Using Non-Adjacent Columns

Are you up for a really cool trick with Excel's new FILTER function? With this, you can get multiple match results from non-adjacent columns in a simple, dynamic way! You can also use it to get unique values from different columns. Check out the full article.

Excel Top N with FILTER function

Create an Excel report with the top values and categories. What makes this impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number they choose.

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.

Excel FILTER Function

Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when

Practical Excel Dashboard (Excel Hash 2019)

A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given

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 Get External Links

Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost.  In this case,