Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

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.

Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...

In short, the filter buttons make it easy to narrow your data to the most relevant information, saving you from having to search through your rows and columns manually.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

How to Use Radio Buttons in Excel. Radio buttons, which are also called option buttons, provide a quick way for users of your custom Excel forms to quickly answer questions with a small, clearly ...