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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0! This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text. To activate this you need to Right Click in any Value i...
5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...