They work best with data presented in a tabular format, with no empty rows ... no names in the income column. To create a PivotTable in Microsoft Excel, follow the steps below: Pivot tables ...