Excel Pivot Tables: Basic Beginners Guide to Learn Excel Pivot Tables for Data Analysis and Modeling

✍ Scribed by Martin, MG

• Year: 2019
• Tongue: English
• Leaves: 167
• Category: Library

✦ Synopsis

Most organizations and businesses use Excel to perform data analysis. These organizations also use it for modeling. There are numerous features and add-ins that Excel offers which make it easier to perform data analysis and modeling. A Pivot Table is one such feature provided by Excel.

You can analyze a million rows of data within a few clicks, show the required results, create a pivot chart or report, drag the necessary fields around and highlight the necessary information. It is imperative that people who use excel are well versed with using pivots. If you are looking to learn more about what a pivot table is and how you can use it for data analysis, you have come to the right place.

Over the course of the book, you will learn more about what a Pivot Table

• Insert A Pivot Table
• Drag Fields In A Pivot
• Sort Data In A Pivot
• Working With Tables
• Focus On Auditing The Data
• Refreshing The Pivot
• Accessing The Data
• Source Data Fields

And many more….

✦ Table of Contents

Chapter One : An Introduction to Pivot Tables
Chapter Two : Advantages and Disadvantages of Pivot Tables
Chapter Three : What Can You Do With Pivot Tables ?
Chapter Four : Manipulating Data for a Pivot Table

✦ Subjects

Excel Pivot Tables, Basic Beginners Guide, Learn Excel Pivot Tables for Data Analysis and Modeling