Data Analytics with Excel Pivot Tables

Course Overview

• Course Title: Data Analytics with Excel Pivot Tables
• Instructor: Navya Kannan
• Target Audience:
  • Individuals with little or no prior knowledge of Microsoft Excel
  • Anyone interested in gaining an in-depth understanding of Excel Pivot Tables
• Prerequisites:
  • Basic know-how of Excel
  • Microsoft Excel installed on your desktop

Curriculum Highlights

• Key Topics Covered:
  • Importance of Data Analytics in Business
  • Types of Business Analytics and Real-Life Examples
  • Using Excel PivotTables for Reporting and Data Visualization
  • Features of PivotTables: Grouping, Calculated Field, Calculated Item, Slicers, PowerPivot, and Charts
• Key Skills Learned:
  • Performing Data Analytics using Excel Pivot Tables
  • Creating and Customizing Pivot Tables
  • Manipulating Data to Gain Business Insights
  • Presenting Data in a Visually Appealing Manner

Course Format

• Duration: 1 hour on-demand video
• Format: Self-paced online course
• Resources:
  • 9 downloadable resources
  • Access on mobile and TV
  • Closed captions
  • Audio description in existing audio
  • Certificate of completion