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

Filter a Pivot Table by Dates There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation.You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...
Insert Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total.How about if you want to remove this Grand Total or show it only for a row or column?Well you have that flexibility and this is how...DOWNLOAD EXCEL...
How To Fix Pivot Table Empty Cells I am sure that you have come across a Pivot Table which has empty cell values and thought "What the hell is happening here?"This is because your data source has blank cells for certain items, which happens from time to time.This can be fixed in your Pivot Table and you ca...