Excel Tips and Tricks
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 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...
Slicers in Excel Tables
Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. An Excel Table contains...
How to Change Table Style in Excel
Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we're going to...