In this Pivot Table Excel tutorial, we start at the very beginning and teach you how to create your first Pivot Table in Excel.

If you've not created a Pivot Table before, then this Excel tutorial is for you. In under 1 hour, we take some raw data, start to analyze it using a Pivot Table, create a Pivot Chart from it to summarise and display that data, and then add filters and Slicers.

Follow along and download the accompanying Excel file here ️ https://www.simonsezit.com/pivot-tables-instructor-files/

Pivot Tables Tutorial Markers:

0:00:19 - Introduction
0:04:25 - Understanding Dataset
0:05:23 - The Importance of Cleaning Data
0:07:09 - Formatting Data as a Table
0:08:57 - Creating a PivotTable
0:11:21 - Analyzing Data by Pivoting Table Fields
0:19:20 - Grouping Data
0:21:32 - Value Field Settings
0:25:32 - Number Formatting
0:27:44 - Sub-totals and Grand Totals
0:29:25 - Report Layouts
0:30:51 - PivotTable Styles
0:33:58 - Creating Pivot Charts from PivotTables
0:44:15 - Filtering with Slicers
0:48:52 - Updating Data

Follow along and download the accompanying Excel file here ️ https://www.simonsezit.com/pivot-tables-instructor-files/

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first-month-free

Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Check out our FREE 300+ hour training course playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Level up your Excel skills with free training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

Watch additional popular Microsoft Office tutorials from Simon Sez IT:

Microsoft Office 365 Hacks and Tips::https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iYkOPsV0q-xU1hmUMN8Jfe

Microsoft Teams playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iCI8GDXZgLEvLPPWcJ2b4z

Pivot Table training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

Please SUBSCRIBE https://www.youtube.com/simonsezittraining?sub_confirmation=1
️ We appreciate your support!