Excel Pivot Tables & Charts: A Step By Step Visual Guide
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 tables 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.
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
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.