دانلود کتاب Excel 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