Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Book Overview
Cut the Learning Curve
About the Author
Getting Started
Multi Touch
Study Guide
Learning Tools
First Pivottables
What is a PivotTable?
Preparing data for pivottable
Use the PivotTable Wizard
Define a name for the source?
Auto Formatting the PivotTable
Refreshing the PivotTable
My Favorite
Structure of a PivotTable
Available Fields - Field List
Page Fields – Report Filters
Pivot Fields - Rows/Columns
Data Fields - Values shown
Field Properties
PivotTable Properties
My Favorite
Filter & Sort PivotTables
Auto-sorting a pivottable
Sorting a pivottable manually
Filtering PivotItems by Label
Filtering PivotItems by Value
Filtering with Page Fields
Exclude page items manually
My Favorite
Twist data with PivotTables
Subtotals & Grand Totals
Drag & Drop Analysis
Drilling down in a pivottable
Insert a Slicer
Show PageItem Reports
Calculating Field differences
My Favorite
Analysis in Practice
Analyze list of Orders
Analyze Product Sales
Read Content in a Text-file
Create Top-10 reports
Count Orders in Database
Analyze Invoice Data
My Favorite
Dynamic PivotCharts
How to make a PivotChart?
Filter data in PivotCharts
Formatting a PivotChart
PivotChart Slicers
Copy PivotChart to PowerPoint
Make PivotChart Scorecards
My Favorite
Summary
Mind Map
Glossary
Quiz
Thanks!
Next Step
What Next?
Microsoft Excel Books
Copyright
Quiz Answers
← Prev
Back
Next →
← Prev
Back
Next →