This book is for every Excel user. It is widely agreed that close to 60 percent of Excel users leave 80 percent of Excel untouched. That is, most users do not tap into the full potential of Excel's built-in utilities. Of these utilities, the most prolific by far are the pivot table and pivot charts. Despite the fact that pivot tables and charts have been a cornerstone of Excel for more than 16 years, they remain one of the most underutilized tools in the entire Microsoft Office Suite.
Having discovered this book, you are savvy enough to have heard of pivot tables and charts or even have used them on occasion. You have a sense that pivot tables and charts have some power that you are not using, and you want to learn how to leverage that power to increase your productivity quickly.
With only this book, you will be able to create basic pivot tables and charts, increase your productivity, and produce reports in minutes instead of hours. Within the first 3 chapters, you will be able to output complex pivot reports with drill-down capabilities accompanying charts. By the end of the book, you will be able to build a dynamic pivot table reporting system.
Author(s): Wright, A.J.
Year: 2019
Language: English
Commentary: Excel 2016-2013 Pivot Tables & Charts - A Step By Step Visual Guide
Pages: 129
Tags: Excel 2016-2013 Pivot Tables & Charts - A Step By Step Visual Guide
How to Use This Book
Download Link for Exercise Files
1. Introduction to Pivot Tables
What is A Pivot Table?
Basic Concepts
Conditions to Create a Pivot Table
Limitations of a Pivot Table
2. Creating A Pivot Table
Source of Data
Structure of the Pivot Table
Creating Your First Pivot Table
3. Creating A Pivot Chart
How to Drill-Down Pivot Table Data
Adding More Rows (categories) to Pivot Table
How to Create A Pivot Table Chart
4. Slicers & Advanced Filtering
Timeline Slicer
Practice Project 1
Slicer
Additional Information
Advanced Filtering
5. Calculations in Pivot Tables
Calculated Fields
Practice Project 2
Adding A Basic Calculated Field
Removing Or Changing Calculated Fields
Inserting Logic Fields (if...then)
6. Customizing Pivot Tables
Making Major Cosmetic Changes
Making Minor Cosmetic Changes
7. Using VBA Macro Language to Create Pivot Tables
Introduction to VBA
Why Use Macros with Your Pivot Table Reports?
Recording Your First Macro
Using VBA to Create Pivot Tables
Visual Basic Editor
Visual Basic Tools
Understanding Object-Oriented Code
Writing Code to Handle Any Size Data Range
Using Super-Variables: Object Variables
Using With and End With to Shorten Code
Building a Pivot Table in Excel VBA
Practice Project 3
Adding Fields to the Data Area
8: Advanced Tips, Tricks & Techniques
