Microsoft Excel Pivot Tables: The Pivot Table Masterclass

Course Overview

• Course Title: Microsoft Excel Pivot Tables: The Pivot Table Masterclass
• Instructor: Click Learning
• Target Audience: Excel users, data analysts, business professionals
• Prerequisites: No experience needed. This course is compatible with any version of Excel

Curriculum Highlights

• Key Topics Covered:
  • Understanding Pivot Tables: Definition and Purpose
  • Advantages of Pivot Tables
  • Pivot Table Layout: Field List and Areas
  • Refreshing Pivot Table Data
  • Filtering Data in Pivot Tables
  • Using Slicers and Timelines
  • Formatting Pivot Table Layout
  • Conditional Formatting in Pivot Tables
  • Performing Calculations in Pivot Tables
  • Creating Pivot Charts
  • Adding Interactivity with Slicers and Timelines
  • Optimizing Pivot Table Performance
• Key Skills Learned:
  • Creating and managing Pivot Tables
  • Organizing and preparing data for Pivot Tables
  • Customizing Pivot Tables
  • Grouping, filtering, and sorting data
  • Using calculated fields and items
  • Working with multiple Pivot Tables
  • Drilling down into Pivot Table data
  • Formatting and styling Pivot Tables
  • Summarizing and analyzing data
  • Creating interactive dashboards

Course Format

• Duration: 2.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion

Special Offer (If Applicable)

• Limited Time Coupon Code: N/A