Excel Pivot Tables & Charts by A. J. Wright

A Step By Step Visual Guide

Step by Step Excel Practice Projects & Solutions for Beginners

Excel pivot tables & charts

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 Processing

Secondary Genre: COMPUTERS / Data Modeling & Design

Language: English

Keywords: excel, pivot tables, pivot chats, Excel pivot tables, Visual basic application, spreadsheet, data processing, a. j. wright, excel 2022 for beginners, excel 2022 from beginner to expert, excel 2022 cheat sheets

Word Count: 12643

Sales info:

The book has sold about a 100 copies in English language on Scribd.com, Barnes & Noble, Apple, Google Play, etc


Sample text:

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...


Book translation status:

The book is available for translation into any language except those listed below:

LanguageStatus
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.

Would you like to translate this book? Make an offer to the Rights Holder!



  Return