Pivot Table

Pivot Table

25th April 2018
9:30 am - 1:30 pm

Location:
James O'Keeffe Institute, Newmarket, Co. Cork

Places remaining: 9
Cost: €€60.00 (Plus booking fee)

Terms & Conditions - Click Here

Start Date: 25th April
Time: 9.30am – 1.30pm
Duration: Half Day
Venue: James O’Keeffe Institute, Newmarket
Tuition Fee: €60
Accreditation: Cert of Attendance

 

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

Keep this field blank:

Registration Form

First name *
Required field
Last name *
Required field
E-Mail *
Required field
Phone number *
Required field
Date of birth
Address
What target group do you fall under?
Seats *
Comments / Special Requirements