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