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