OptimaTrain

Course Curriculum

Files to Use
Exercise Files 00:00:00
Introduction to Course
Welcome to Pivot Tables and Pivot Charts Course FREE 00:00:00
Why Pivot Tables?
What Pivot Tables Do for You FREE 00:00:00
Life Without Pivot Tables 00:00:00
Creating a Pivot Table
Data Structure for Pivot Tables 00:00:00
Creating a Pivot Table 00:00:00
Excel Tables 00:00:00
Pivot Tables Based on a Table 00:00:00
Basic Pivot Table Tools
Pivot Table Field List Options 00:00:00
Placing Fields in a Pivot Table 00:00:00
Multiple Fields in the Values Area 00:00:00
Pivot Table Layouts 00:00:00
Value Field Settings for a Numeric Field 00:00:00
Displaying Counts in a Pivot Table 00:00:00
Show Values As Options 00:00:00
Filtering and Collapsing on Row and Column Fields 00:00:00
Field Settings for a Categorical Field 00:00:00
Sorting in Pivot Tables 00:00:00
Sorting with a Custom List 00:00:00
More Filters for Row and Column Fields 00:00:00
Slicers for Filtering 00:00:00
Pivot Charts 00:00:00
Styles for Pivot Tables and Charts 00:00:00
Grouping by Category 00:00:00
Other Pivot Table Tools
Pivot Cache 00:00:00
Converting a Pivot Table to Static Values 00:00:00
More on Grouping by Dates 00:00:00
Grouping by Selection 00:00:00
Showing Report Filter Pages 00:00:00
Displaying Cells with No Data 00:00:00
PivotTable Options Dialog Box 00:00:00
Selecting, Copying, Moving, Clearing, and Deleting a Pivot Table 00:00:00
Refreshing a Pivot Table 00:00:00
Avoiding Pivot Cache Sharing 00:00:00
Conditional Formatting in Pivot Tables 00:00:00
Calculated Fields 00:00:00
Calculated Items 00:00:00
Formulas Referencing Pivot Table Cells 00:00:00
Using GetPivotData for Custom Reports 00:00:00
Efficiency Tips for Pivot Tables 00:00:00
Selected Uses of Pivot Tables
Finding Unique Values with a Pivot Table 00:00:00
Creating a Histogram with a Pivot Table 00:00:00
Using Pivot Tables for Classification 00:00:00
Conclusion to Course
Conclusion to Pivot Tables and Pivot Charts Course 00:00:00