Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Open your pivot table and select rows or columns that you want to format. Right-click on them and select Format cells. Select relevant formatting options from the following menu.