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 found 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.
Genre: COMPUTERS / Data ProcessingThe book has sold about a 100 copies in English language on Scribd.com, Barnes & Noble, Apple, Google Play, etc
Table of Contents
How to Use This Book
Download Link for Exercise Files
Chapter 1: Introduction to Pivot Tables
What is A Pivot Table?
Basic Concepts
Conditions to Create a Pivot Table
Limitations of a Pivot Table
Chapter 2: Creating A Pivot Table
Source of Data
Structure of the Pivot Table
Creating Your First Pivot Table
Chapter 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
Chapter 4: Slicers & Advanced Filtering
Practice Project 1
Timeline Slicer
Slicer
Additional Information
Advanced Filtering
Chapter 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)
Chapter 6: Customizing Pivot Tables
Making Major Cosmetic Changes
Making Minor Cosmetic Changes
Chapter 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
How to Use This Book
This book can be used as a tutorial or quick reference visual guide. It is intended for users who are comfortable with the basics of Microsoft® Excel® and are now ready to build upon this...
Language | Status |
---|---|
Dutch
|
Already translated.
Translated by Ingrid van Sichem
|
French
|
Already translated.
Translated by Michel Gambier
|
|
Author review: Very high quality work was produced in a timely manner. I highly recommend and will use Michel Gambier again for future translation to French. |
Spanish
|
Already translated.
Translated by Rafael Ayala
|
|
Author review: Very high quality work. He is very fast and dedicated. I will choose him again. |