Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks.  It is the most powerful tool within Excel due to its speed and output and I will show you just how easy it is to create one.

If you are using a table or data set to analyze your information, then you should always use a Pivot Table which will enhance your analytical capabilities as well as save you heaps of time off your daily routine.

Pivot Tables are used by Project Managers, Finance Analysts, Auditors, Cost Controllers, Sales Analysts, Financial Controllers, Human Resources, Doctors and Statisticians just to name a few.  Heck, I even created an in depth online course on Pivot Tables, that’s how in demand this Excel tool is in right at this moment!

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Click in your dataset.

 

STEP 2: Go to Insert > Pivot Table

 

STEP 3: Place the Pivot Table in a New or Existing Worksheet

 

STEP 4: Drag and Drop the fields

You now have your Pivot Table!

Insert a Pivot Table

Helpful Resource:

728x90

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year.Grouping these would take a ton of effort using Formulas:Extracting the month and year from each transactional date; Th...
Top 3 Excel Pivot Table Issues Resolved I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.I want to put these issues to bed so you can go o...
Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column.Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet.The best layout to use is either the Outli...
GETPIVOTDATA Function What does it do?A formula that extracts data stored in a Pivot TableFormula breakdown:=GETPIVOTDATA(data_field, pivot_table, , ,...)What it means:=GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...) T...