DATA INSIGHT TRAINING
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog

Complete Introduction to Excel Pivot Tables

2/12/2019

0 Comments

 
In my opinion, Pivot Tables are the most powerful feature in Microsoft Excel.  They make aggregating, summarising and performing powerful data analysis quick and easy.

Sadly, most seasoned Excel users have very little or no understanding of what Pivot Tables can do so the most powerful feature in Excel is also the most under-utilised.  There seems to be a widespread misconception that Pivot Tables are difficult to work with, but this couldn’t be further from the truth. In this video I will show you how easy Pivot Tables are to use.  You will see there are no complicated formulas and all I do is use drag and drop techniques to create management reports in a few clicks of the mouse.
​

One of my most popular classroom training courses is a two days course on Pivot Tables and the amount of joy I see in people's eyes when they realise how much time they can save by simply changing the way they work is indescribable!
In this video I have tried to summarise some of the “better” functions into a lot shorter time period but if you’re interested in finding out more, I really recommend signing up for one of my online or classroom courses.

​
I hope you enjoy the video!
0 Comments



Leave a Reply.

    Categories

    All
    Business Data Analysis
    Complete Introduction To
    Data Skills
    DAX
    Excel Dashboards
    Excel Formulas
    Gartner Report
    Inspiration & Motivation
    Pivot Tables
    Power BI
    Power BI Desktop
    Power BI Query Editor
    Power BI Services
    Power Map
    Power Pivot
    Power Query
    Power View
    Tables & Reports

    Archives

    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog