Excel Pivot Tables & Charts: A Step By Step Visual Guide

click here 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