Course Overview
- Course Title: The Complete Microsoft Excel Data Analysis and Pivot Tables
- Instructor: Bright Path
- Target Audience: Students, professionals, business analysts
- Prerequisites: No prior Excel experience needed
Curriculum Highlights
- Key Topics Covered:
- Overview of Excel for Data Analysis
- Rearranging Fields: Rows, Columns, Values, Filters
- Grouping and Summarizing Data
- Using Slicers for Interactive Filtering
- Creating Calculated Fields and Items
- Customizing PivotCharts (titles, legends, axis)
- Dashboard Basics with PivotTables and PivotCharts
- Sorting and Filtering within PivotTables
- Key Skills Learned:
- Essential Data Analysis Techniques: Sorting, filtering, conditional formatting, and data validation
- Working with Tables: Creating and managing Excel Tables for structured data handling
- Mastering PivotTables: Creating, customizing, and analyzing data with dynamic PivotTables
- PivotCharts & Slicers: Visualizing and interacting with your data like a pro
- Advanced Features: Grouping, calculated fields, timelines, and multiple consolidation ranges
- Data Cleaning: Removing duplicates, handling blanks, and preparing data for analysis
- Data Tools: Using Flash Fill, Text to Columns, and What-If Analysis for deeper insights
Course Format
- Duration: 2 hours on-demand video
- Format: Self-paced online course
- Resources: Access on mobile and TV, Certificate of completion