To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the …

Apply a style to format your PivotTable, turn on banded rows to make a lot of data easier to scan, or highlight important information.

To get started, go to File > Options > Data > Click the Edit Default Layout button. Edit Default Layout options: Layout Import - Select a cell in an existing PivotTable and click the Import …

Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for …

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in …

In the Power Pivot window, select the column for which you want to change the data type. On the Home tab, in the Formatting group, choose a data type from the Data Type list.

To see a sort of the grand totals for products—from largest to smallest—choose any number in the Grand Total column, and sort on it. Tip: To quickly find what you need, you can group, …

With the Mark as Date Table dialog box, you specify a unique date column, which enables the use of advanced date filters against Power Pivot data in Excel pivot reports.

One of the coolest things you can do with Power Pivot is give your data model real power for working with dates and time. Use the following resources to learn how you can include dates …

To remove all report filters, labels, values, and formatting from a PivotTable, and to start designing the layout all over again, use the Clear All command.