Pivot Tables Training Course
Microsoft Excel Training are delivering a half day course exclusively to the use of Pivot Tables. We adopt a flexible approach to training which means our comprehensive list of training courses can be tailored to suit your training needs. The Training team specialises in delivering a comprehensive range of customised Microsoft, bespoke IT courses. The trainers have practical and in-depth understanding of office software and expertise in how to effectively transition clients between all versions.
For more information please contact us training@microsoftexceltraining.ie
Creating Basic Pivot Tables
- Preparing your data
- Tabular Layout
- Removing Section Headings
- Removing Repeated Column Groups
- Eliminating Gaps
- Type Formatting
- Creating Pivot Tables
- Adding Fields
- Adding Layers
- Altering Structure
- Report Filters
- Managing Changes in Your Source Data
- Dynamic Named Ranges
- Dealing with Zeroes
- Subtotals
- Summary Calculations
- Running totals
- Differences (year on year, month on month)
- Percentages of Rows, Columns, Totals and other fields
- Running Totals and Top 10 reports
- Pivot Table Tools
- Layout Updates
- Refreshing & Restarting
- Moving Pivot Tables
Pivot Table Views
- Conditional formatting
- Sorting, Filtering and Re-ordering
- Slicers (2010 / 2013 only)
- Saving Custom Views
Pivot Table Calculations
- Calculated Fields and Items
- Managing & maintaining Pivot Table calculations
Pivot Charts
- What is a Pivot Chart?
- Creating a Pivot Chart
- Pivot Chart Rules
- Managing the underlying data
- Adding Layers
- Altering Structure
- Pivot Chart Alternatives
- Dynamic Charts
- Transition tables