Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel 7: Pivot Tables and Pivot Charts - Hands-on

Microsoft Excel 7: Pivot Tables and Pivot Charts

Description

The Pivot Table is one of the most intuitive and powerful tools in Excel. With any list or table in your workbook, you can create a summary analysis and a chart highlighting insights in just seconds. Taking more time than that, you can build an interactive dashboard with multiple charts and filters.

Topics include:

  • Designing and controlling lists and tables as the Pivot Table source
  • Creating Pivot Tables to analyze data populations
  • Adding Slicers and Timelines to Pivot Tables for interactivity
  • Visualizing insights with Pivot Charts
  • Making multiple-chart dashboards

Similar events

Microsoft Word 1: Navigation, Selection, and Editing - Hands-on

Microsoft Word 1: Navigation, Selection, and Editing

More Information
Microsoft Word 2: Essential Formatting and Structures - Hands-on

Micosoft Word 2: Essential Formatting and Structures

More Information
Microsoft Word 3: Tabs and Tables - Hands-on

Microsoft Word 3: Tabs and Tables

More Information
Microsoft Word 4: References and File Structure - Hands-on

Microsoft Word 4: References and File Structure

More Information
Microsoft Word 5: Forms and Mail Merge - Hands-on

Microsoft Word 5: Forms and Mail Merge

More Information
Microsoft Word 6: Automation - Hands-on

Microsoft Word 6: Automation

More Information
Microsoft Word for Legal Practices - Hands-on

MS Word for Legal Practices

More Information
Microsoft Excel 1: Essential Spreadsheet Skills - Hands-on

Microsoft Excel 1: Essential Spreadsheet Skills

More Information
Microsoft Excel 2: References and Calculations - Hands-on

Microsoft Excel 2: References and Calculations

More Information
Microsoft Excel 3: ETL with Power Query in Excel

Microsoft Excel 3: ETL with Power Query

More Information
Microsoft Excel 4: List and Table Management - Hands-on

Microsoft Excel 4: List and Table Management

More Information
Microsoft Excel 5: Text, Date, and Management Functions - Hands-on

Microsoft Excel 5: Text, Date, and Management Functions

More Information
Microsoft Excel 6: Lookup and Logical Functions - Hands-on

Microsoft Excel 6: Lookup and Logical Functions

More Information
Microsoft Excel 8: Power Pivot and Modern Excel - Hands-on

Microsoft Excel 8: Power Pivot and Modern Excel

More Information
Microsoft Excel 9: Data Visualization Essentials - Hands-on

Microsoft Excel 9: Data Visualization Essentials

More Information
Microsoft Excel 10: Forecasting and Analysis - Hands-on

Microsoft Excel 10: Forecasting and Analysis

More Information
Microsoft Excel 11: Professional Polish for Spreadsheet - Hands-on

Microsoft Excel 11: Professional Polish for Spreadsheets

More Information
Microsoft Excel 12: Automation in Excel - Hands-on

Microsoft Excel 12: Automation in Excel

More Information
Microsoft PowerPoint 1: Essential Slide Creation and Formatting

Core PowerPoint Techniques

More Information
Microsoft PowerPoint 2: Theme and Template Foundation - Hands-on

Microsoft PowerPoint 2: Theme and Template Foundation

More Information
Microsoft PowerPoint 3: Images, Icons, and Diagrams - Hands-on

Microsoft PowerPoint 3: Images, Icons, and Diagrams

More Information
Microsoft PowerPoint 4: Charting in PowerPoint - Hands-on

Microsoft PowerPoint 4: Charting in PowerPoint

More Information
Microsoft PowerPoint 5: Media and Motion - Hands-on

Microsoft PowerPoint 5: Media and Motion

More Information
Microsoft PowerPoint 6: Advanced Theme Development - Hands-on

Microsoft PowerPoint 6: Advanced Theme Development

More Information
Microsoft PowerPoint 7: Nonlinear Presentations - Hands-on

Microsoft PowerPoint 7: Nonlinear Presentations

More Information
Microsoft PowerPoint 8: Presentation Structure and Best Practices - Hands-on

Microsoft PowerPoint 8: Presentation Structure and Best Practices

More Information
Microsoft Outlook 1: Outlook Essentials - Hands-on

Microsoft Outlook 1: Outlook Essentials

More Information
Microsoft Outlook 2: Inbox Management - Hands-on

Microsoft Outlook 2: Inbox Management

More Information
Microsoft Outlook 3: Calendar Management - Hands-on

Microsoft Outlook 3: Calendar Management

More Information
Microsoft Outlook 4: Tasks and Contacts - Hands-on

Microsoft Outlook 4: Tasks and Contacts

More Information
Microsoft OneNote 1: Information Management - Hands-on

Microsoft OneNote 1: Information Management

More Information
Microsoft OneNote 2: Integrations and Workflows - Hands-on

Microsoft OneNote 2: Integrations and Workflows

More Information
Microsoft Visio 1: Essential Diagram Design - Hands-on

Microsoft Visio 1: Essential Diagram Design

More Information
Microsoft Visio 2: Data-Driven Diagrams - Hands-on

Microsoft Visio 2: Data-Driven Diagrams

More Information
Microsoft 365 1: Understanding Microsoft 365 - Seminar

Microsoft 365 1: Understanding Microsoft 365

More Information
Microsoft 365 2: Integrations Between Teams and SharePoint - Seminar

Microsoft 365 2: Creating and Modifying Microsoft 365 Groups

More Information
Teams 1: Understanding Microsoft Teams - Hands-on

Teams 1: Understanding Microsoft Teams

More Information
Teams 2: Chat and Meetings - Hands-on

Teams 2: Chat and Meetings

More Information
Teams 3: Creating Teams and Channels - Hands-on

Teams 3: Creating Teams and Channels

More Information
Teams 4: Integrations - Hands-on

Teams 4: Integrations

More Information
SharePoint 1: Understanding SharePoint - Hands-on

SharePoint 1: Understanding SharePoint

More Information
SharePoint 2: Personalization - Hands-on

SharePoint 2: Personalization

More Information
SharePoint 3: Site Access Management - Hands-on

SharePoint 3: Site Access Management

More Information
SharePoint 4: Content Mangement - Hands-on

SharePoint 4: Content Management

More Information
SharePoint 5: Experience Mangement - Hands-on

SharePoint 5: Experience Management

More Information
SharePoint 6: Integration Management - Hands-on

SharePoint 6: Integration Management

More Information
OneDrive: OneDrive for Individual Projects - Hands-on

OneDrive: OneDrive for Individual Projects

More Information
Tasks: Planner, To-Do, and Microsoft Lists - Hands-on

Tasks: Planner, To-Do, and Microsoft Lists

More Information
Data Handling with Forms and Flows - Hands-on

Data Handling: Microsoft Forms and Flows

More Information
Design 1: Essential Design Principles for Business Professionals - Hands-on

Design 1: Essential Design Principles for Business Professionals

More Information
Design 2: Customizing a Corporate Design Theme - Hands-on

Design 2: Customizing a Corporate Design Theme

More Information
Design 3: Preattentive Attributes in File Construction - Hands-on

Design 3: Preattentive Attributes in File Construction

More Information
Design 4: Gestalt Principles in Visual Design - Hands-on

Design 4: Gestalt Principles in Visual Design

More Information
Office 1: Creating a Corporate Office Theme - Hands-on

Office 1: Creating a Corporate Office Theme

More Information
Office 2: Templatizing Word and Excel Files - Hands-on

Office 2: Templatizing Word and Excel Files

More Information
Office 3: Creating a Corporate Presentation Layout - Hands-on

Office 3: Creating a Corporate Presentation Layout

More Information
Office 4: Customizing a Presentation Theme - Hands-on

Office 4: Customizing a Presentation Theme

More Information
PowerPoint 1: Presentation Planning - Hands-on

PowerPoint 1: Presentation Planning

More Information
PowerPoint 2: Presentation Design - Hands-on

PowerPoint 2: Presentation Design

More Information
PowerPoint 3: Design Principles in Visual Design - Hands-on

PowerPoint 3: Design Principles in Visual Design

More Information
PowerPoint 4: Data-Rich Presentations - Hands-on

PowerPoint 4: Data-Rich Presentations

More Information
PowerPoint 5: Presentation Experience Design - Hands-on

PowerPoint 5: Presentation Experience Design

More Information
PowerPoint 6: Virtual Presentations - Hands-on

PowerPoint 6: Virtual Presentations

More Information

Press enter to see more results