Beginners guide to Pivot Tables: learn the basics and overcome common issues (+follow along file)
This guide to Pivot Tables is a beginners tutorial running through lots of useful information on how to insert, format and display data in your Pivot Table. It also covers how to fix some common issues:
0:00 Introduction
1:00 Inserting a Pivot Table
1:50 Common error with inserting Pivot table "The PivotTable field name is not valid"
2:40 Issues adding new data to an existing table
4:13 Formatting column widths
5:20 Number formatting in a Pivot Table
5:59 Headings in Pivot Tables
7:33 Displaying total values
8:48 Blank fields in your data
9:39 Pivot Cache - what is it and tricks you can use
The file is also available to download from our Google Drive - so you can follow along or use it for reference in your own time.
Download the file here: https://drive.google.com/file/d/1vK5h...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other videos and playlists, such as our other Pivot table videos:
Introduction to Pivot Tables: • Learn Pivot Tables in 7 Minutes | Int...
Issues with PIVOT TABLES - fixing common errors: • Issues with PIVOT TABLES - fixing com...
Pivot Charts: • Introduction to PIVOT CHARTS. Learn t...
