Learn How To Create A Pivot Table With Fewer Clicks With This Microsoft Excel Tutorial

Problem: Even though pivot tables are the fastest way to summarize data, you are looking for an even faster way to create pivot tables.

By Mr Excel

Desk Tech

Reading time 1 min read

Word count 102

Quick Take

Problem: Even though pivot tables are the fastest way to summarize data, you are looking for an even faster way to create pivot tables.

On this page

Strategy:

This method is only available in Excel 2000 and newer versions.

Follow these steps.

Select a single cell in the original data, as shown in Fig. 911.
From the menu, select Data – PivotTable. Click Finish, as shown in Fig. 912.

Advertisement

You are given a blank pivot table on a new sheet, as shown in Fig. 913.

Summary:

This visual method for creating a pivot table is faster and more intuitive.

Commands Discussed:

PivotTable

Images

Fig. 912

Fig. 913

Fig. 914

Filed under