Pivot table calculated field:
This video shows how to add calculated field in pivot table, and is the next in our Pivot Table series. This beginners' tutorial provides an overview of how to add a calculated field to your Pivot Table (how to add calculated rows and columns). Want your Pivot Table to do some automatic calculations on your base data? This easy beginners tutorial will show you how to get those calculations in pivot tables:
0:00 Introduction
0:24 Inserting a Pivot Table
0:38 Setting up your Pivot Table
1:14 Adding calculations into your Pivot Table
1:49 Calculated Item (adding a calculated row)
3:53 Calculated Field (adding a calculated column)
5:24 Other formulas in Calculated Fields (multiplication and division)
6:30 List Formulas
The file I have used is the same as for my Guide to Pivot Tables video ([ Ссылка ]) which available to download from my Google Drive if you want to follow along or use it for reference in your own time.
Download the file here: [ Ссылка ]
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! :-)
You can find all our Pivot Table videos in the following playlist: [ Ссылка ]
Or here are the links to individual videos; check them out!
Introduction to Pivot Tables: [ Ссылка ]
Issues with PIVOT TABLES - fixing common errors: [ Ссылка ]
Pivot Charts: [ Ссылка ]
Pivot Tables and Slicers: [ Ссылка ]
