Browse to the Custom Office Templates folder that’s under My Documents. Click your template, and click Open. Make the changes you want, then save and close the template. Use your template to make a new document. To start a new file based on your template, click File > New > Custom, and click your template.

Use slicers to filter data. Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed. Windows macOS Web.

Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.