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.

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 sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Excel tables automatically update with new data, simplifying updates for pivot tables and charts. Slicers offer an interactive way to filter data more intuitively than traditional filter buttons.

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