How to Analyze Data using Excel Pivot Tables

Do you know how easy it is to use the Pivot Tables in Excel, for Data Analysis?

To demonstrate this, I went to the Internet, and  found some travel data. It belongs to an unnamed Travel Company. The travel company collects the amount of ticket sales, the age of the passenger, and their gender only.

Based on this, how do we analyze the data, and find some hidden gems of information that can make the data come alive, and aid us in doing some real life Marketing.

Watch this step by step video on analyzing this data, using the Pivot Table technique in Microsoft Excel. I am using Excel 2010 version for this demonstration.

As you can see, many hidden insights can be found by using the Pivot Tables in Excel. So get started… Use them in your day to day work, and become a Data Analyst, rather than a Data Gatherer or Data Reporter…

Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training
!


Have you subscribed to the ExcelChamp.Net Email Newsletter, where we send you such tips by email?

Additional Resources

Cheers,
Vinai Prakash, PMP, ITIL, MBA, GAP
Founder: ExcelChamp.Net – Providing Everyday Tips for Improving Productivity, Using Excel!

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!

<div class=”ml-form-embed”
data-account=”3112195:l6l5i4i1x0″
data-form=”5497493:o9q9a8″>
</div>

Additional Resources for Learning Excel & Become A Pro

  1. Top 12 Most Important Excel Functions You Absolutely Must Know
  2. Excel Beginners Guide
  3. Excel Essentials: From Beginner To Pro in Just 6 Weeks

Leave a Comment