Excel Pivot Tables Tutorial Point
Have you ever wanted to summarize a massive Database? Pivot Tables in excel are absolutely one of the best tools, the benefits of knowing how to create excel pivot tables are a lot, since in most is almost impossible to manually perform the work done by the Pivot Table.
Have you ever wanted to answer a lot of questions about your business? Have you ever needed to find out the important insights hidden in your ERP data? Within seconds an excel Pivot Table can give you all those answers.
DIFFERENTIATION FACTORS OF “EXCEL PIVOT TABLES CHAMPION”
Full of screenshots and examples
Includes for free 40 Practice excel spreadsheets
Includes for free the first chapter of 2 of my books: Vlookup Champion and Conditional Formatting Champion
You will learn how to create a pivot table in excel in many different ways within your job or business.
You will learn quickly and in an easy to understand way.
This book gradually increases your knowledge level
Author(s): Verma, Anjali
Year: 2021
Language: English
Commentary: Excel Pivot Tables Tutorial Point
Tags: Excel Pivot Tables Tutorial Point
About the Tutorial .................................................................................
Table of Contents ..................................................................................
1. PivotTable – Overview .........................................................................
PivotTable Layout - Fields and Areas ...............................................................
2. PivotTable – Creation .........................................................................
Adding Fields to the PivotTable ....................................................................
Creating a PivotTable from a Table .................................................................
Creating a PivotTable with Recommended PivotTables .................................................
3. PivotTable – Fields ...........................................................................
Moving PivotTable Fields Task Pane .................................................................
Resizing PivotTable Fields Task Pane ...............................................................
PivotTable Fields ..................................................................................
4. PivotTable – Areas ............................................................................
ROWS ...............................................................................................
∑ VALUES ...........................................................................................
FILTERS ............................................................................................
5. PivotTable – Exploring Data ...................................................................
6. PivotTable – Sorting Data .....................................................................
Sorting on Fields ..................................................................................
Sorting on Subtotals ...............................................................................
More Sort Options ..................................................................................
Sorting Data Manually ..............................................................................
Setting Sort Options ...............................................................................
Points to consider while sorting PivotTables .......................................................
7. PivotTable – Filtering data ...................................................................
Report Filters .....................................................................................
Manual Filtering ...................................................................................
Filtering by Text ..................................................................................
Filtering by Values ................................................................................
Filtering by Dates .................................................................................
Filtering Using Top 10 Filter ......................................................................
Filtering Using Timeline ...........................................................................
Clearing the Filters ...............................................................................
8. Filtering data using Slicers ..................................................................
Inserting Slicers ..................................................................................
Filtering with Slicers .............................................................................
Clearing the Filter in a Slicer ....................................................................
Slicer Tools .......................................................................................
Slicer Settings ....................................................................................
Report Connections .................................................................................
Selection Pane .....................................................................................
9. PivotTable – Nesting ..........................................................................
Changing the Nesting Order .........................................................................
10. PivotTable – Tools ...........................................................................
Grouping and Ungrouping Field Values ...............................................................
Grouping by a Date Field ...........................................................................
Active Value Field Settings ........................................................................
PivotTable Options .................................................................................
11. PivotTable – Summarizing Values ..............................................................
% of Grand Total ...................................................................................
