How to random sort in Excel using dynamic array functions

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...
How to display the Excel Developer tab for using advanced features

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

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

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

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 creating Excel...
How to add Total row in Excel Tables

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

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

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