TOIT Training

Intermediate

Excel in 30 Minutes – Advanced PivotTables and Slicers

Overview
Curriculum

Learn to apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines in Excel 2019 or Excel 365—all in under 30 minutes!

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our “Excel in 30 Minutes” series can help you get started.

Objectives

• Format a PivotTable using built in Styles
• Refresh a PivotTable
• Change PivotTable options
• Create and modify PivotCharts based on PivotTables
• Filter a PivotTable or PivotChart using Slicers and Timelines



Curriculum

  • 5 Sections
  • 24m Duration
Expand All
Formatting a Pivot Table
    Changing Pivot Table Options
      Presenting Data With Pivot Charts
        Using Slicers
          Using Timeline Slicers

            Deleting Course Review

            Are you sure? You can't restore this back

            Course Access

            This course is password protected. To access it please enter your password below:

            Buy for group

            Excel in 30 Minutes – Advanced PivotTables and Slicers
            No groups Found

            You don't have any groups yet

            Create a group and add group members. Sync Group(s)