Excel – Switch Columns Multiple Values

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

Excel Remove Duplicates

These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.

Excel Generate Random Numbers

This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you're preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.

Excel Dashboards with Radio Buttons

Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick: How to control the results based on the radio button selection.

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.