Download and follow along with the course files ⏩https://www.simonsezit.com/excel-2021-intermediate-chapters-course-files-3-videos/

⬇️ Free exercise files ⏩https://www.simonsezit.com/excel-2021-intermediate-chapters-exercise-files-3-videos/

In this Microsoft Excel 2021/Excel 365 training tutorial video, learn all about Excel PivotTables. We'll go over creating a PivotTable from scratch and discuss the different elements of a PivotTable! Learn how to pivot a field, add totals, format numbers and errors, choose a report layout, apply formatting styles, and more! We finish off with an exercise to test what you just learned.

We've even included downloadable Excel files from our paid-for course which means you can complete the exercises in this Microsoft Excel 2021/365 Tutorial and put what you are learning into practice.

Download and follow along ⏩https://www.simonsezit.com/excel-2021-intermediate-chapters-course-files-3-videos/

⬇️Exercise Files ⏩https://www.simonsezit.com/excel-2021-intermediate-chapters-exercise-files-3-videos/

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Intro
0:00:21 - PivotTables Explained
0:02:31 - Creating PivotTables from Scratch
0:07:21 - Pivoting the PivotTable Fields
0:12:52 - Subtotals and Grand Totals
0:16:07 - Number Formatting
0:19:07 - Show Values As and Summarize Values By
0:24:59 - Grouping PivotTable Data
0:30:37 - Formatting Error Values and Empty Cells
0:35:44 - Choosing a Report Layout
0:40:15 - Applying PivotTable Styles
0:45:06 - Exercise 06

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

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

Watch more free popular training tutorials from Simon Sez IT:

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

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)