Pinterest Pixel

Insert a Pivot Table

Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks. ... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Insert a Pivot Table | MyExcelOnline Insert a Pivot Table | MyExcelOnline

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!

Insert a Pivot Table | MyExcelOnline

Download excel workbookInsert-a-Pivot-Table.xlsx

 

STEP 1: Click in your dataset.  Make sure your data does not have any blank cells, columns or rows!

See also  Use One Slicer for Two Excel Pivot Tables

Insert a Pivot Table

 

STEP 2: Go to Insert > Pivot Table

Insert a Pivot Table

 

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

Insert a Pivot Table

 

STEP 4: Drag and Drop the fields

Insert a Pivot Table

You now have your Pivot Table!

Insert a Pivot Table

 

Helpful Resource:

728x90

 

 

If you like this Excel tip, please share it
Insert a Pivot Table | MyExcelOnline Insert a Pivot Table | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...