What’s everyone talking about? Learn about one of the most powerful features of Excel? Pivot Tables. Learn how to easily summarize tens of thousands of rows of data in a few seconds! Organize into a grid, like sales by regions by month, for example, Learn the myriad ways of summarizing data. To name a few:
• % of Grand Total
• % of Column Total
• % of Parent Row Total
• Difference From…
• Rank
• Calculated items and calculated fields
Course Objectives:
Learn about summarizing data in so many possible ways that your presentation makes a statement, rather than simple showing a list of data. To make the analysis of your data become a trivial task. Make it presentable to management with a few clicks
Course Outline:
• Learn about how to start making a pivot table
• Using Excel’s “recommended” pivot table as a start
• Putting the data you want into one (or more) of the four sections of a pivot table
o Rows
o Columns
o Values
o Filter
• Formatting the results
• Using subtotals or grand totals (or not)
• Setting the layout (compact, tabular, outline)
• Pivoting the data by dragging from one section to another
• Field settings (how to calculate the field)
• Various options
• Explode the data onto several sheets based on the items in the report area
• Adding slicers and timelines
• Grouping fields
• Calculated items and calculated fields
• Making Pivot Charts
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient
Mastering Excel Pivot Tables: The Ace Analytical Tool of Excel
Get Instant Access 90 Minutes View Program |
Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More
LIVE : Scheduled on
19-November-2026 :01:00 PM EST 60 Minutes View Program |
2 Hours Virtual Seminar on MS Excel Pivot Tables 101
Get Instant Access 120 Minutes View Program |
Analyzing Data using Microsoft Excel Pivot Tables
Get Instant Access 90 Minutes View Program |
Excel Pivot Tables , Pivot Charts, Slicers, and Timelines
Get Instant Access 75 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry