Resources
How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...
How to create an Excel dynamic list or a table without helper columns using SEQUENCE
A common way to populate lists or tables in Excel is using the INDEX function. However, you need to create a helper column or row, to define row and column numbers for the INDEX function. This way, the INDEX can populate return the values into the corresponding cells....
How to random sort in Excel using dynamic array functions
Excel doesn't have a built-in method to sort data randomly. Instead, you need to rely on formulas to sort a list of values randomly. Before dynamic array formulas, you needed to build a structure of formulas and helper columns to achieve this. Thanks to the dynamic...
How to create a macro in Excel
Macros in Excel are code blocks that you can run in your workbooks to process a batch of commands. Macros are great for automating repetitive tasks such as copying or removing data from specific cells. However, macros can be daunting for new users. Creating a macro is...
How to display the Excel Developer tab for using advanced features
The Excel Developer tab is a Ribbon tab which contains a number of tools aimed towards advanced features of Excel such as VBA, add-ins, form and ActiveX controls. Although you can access the VBA Editor with the shortcut (Alt+F11), the Developer tab in the Ribbon also...
How to refresh stock data in Excel
Excel can get the stock market data from 60 different stock exchanges around the world. However, this information will not refresh automatically, and currently you need to refresh stock data manually, or write a VBA code to automate the process. In this article, we...
How to monitor formulas using the Watch Window Excel feature
Do you have large datasets or dashboards with formulas scattered along multiple sheets? Are you navigating back and forth between sheets to check what the formulas return after changing values on the different sheets? Excel has a solution for you: the Watch window. In...
How to Filter a Table in Excel
Data filters are essential for reporting and decision making. In Excel, you will get filter arrows by default when you create a new table. In this guide, we're going to show you tips about how to filter Excel Tables. For more information about...
How to add Total row in Excel Tables
Excel Tables are very useful for organizing and reporting data in a tabular format. Furthermore, you can also add a dynamic row to your table to display aggregate data while still utilizing the Excel Table features, like using the same styling and automatically...