Key Takeaways. Open your Excel spreadsheet and input your data. Click on the “Data” tab in the ribbon. Select “Data Analysis” from the Analysis group.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Excel Online won’t support the VBA procedure in this article. Download the demonstration .xlsm, .xls, and .cls files to easily access the code. What is InputBox?