Level curriculum

Level 5: Analyze with Pivot Tables

Summarize data with PivotTables, slicers, and Excel tables.

1 course
60 modules
240 lessons

Courses in this level

1 of 1 course

Level 5PivotTables & Real-World Business Data Analysis

Comprehensive 60-chapter professional masterclass in Excel PivotTables, data preparation, real-world business analysis (Sales, HR, Finance, Operations, Inventory, Auditing), Power Pivot, and the VertiPaq Data Model with DAX.

₹799

60 modules240 lessons

Show 60 modules

Module 1: Introduction to PivotTables (Core Concepts & Business Purpose)4 lessons

Module 2: Understanding Raw Business Data (Granularity, Grain & Tabular Hygiene)4 lessons

Module 3: Preparing Data for PivotTables (Cleaning, Deduplication & Validation)4 lessons

Module 4: Excel Tables as PivotTable Sources (Dynamic Expansion & ListObjects)4 lessons

Module 5: Creating Your First PivotTable (Layout, Fields Pane & Interpretation)4 lessons

Module 6: PivotTable Field Areas in Detail (Rows, Columns, Values, Filters & Nesting)4 lessons

Module 7: Value Field Settings (Sum, Count, Average, Min, Max & Distinct Count)4 lessons

Module 8: Sorting and Filtering PivotTables (Top 10, Label Filters & Value Filters)4 lessons

Module 9: PivotTable Layout and Formatting (Tabular Form, Styles & Subtotals)4 lessons

Module 10: PivotTable Foundations Capstone Project (Comprehensive Regional Sales Report)4 lessons

Module 11: Working with Dates (Grouping, Hierarchies & Fiscal Periods)4 lessons

Module 12: Time-Based Analysis (Monthly Trends, QoQ, YoY & Pacing)4 lessons

Module 13: Show Values As (% of Total, Running Totals, Differences & Ranks)4 lessons

Module 14: Calculated Fields and Items (Syntax, Rules & Limitations)4 lessons

Module 15: Distinct Counts and Unique Entities (Unique Customers & Invoices)4 lessons

Module 16: Ranking and Top-N Analysis (Revenue vs Profit Pareto Filters)4 lessons

Module 17: Variance and Target Analysis (Actual vs Budget & Threshold Formatting)4 lessons

Module 18: Customer Analysis (Frequency, AOV, Repeat Buyers & Concentration)4 lessons

Module 19: Product and Category Analysis (Product Mix, Contribution & Margin)4 lessons

Module 20: Advanced Analysis Capstone Project (Comprehensive Sales Performance Engine)4 lessons

Module 21: Multiple PivotTable Reports4 lessons

Module 22: PivotCharts4 lessons

Module 23: Slicers4 lessons

Module 24: Timelines4 lessons

Module 25: Drill-Down and Details4 lessons

Module 26: GETPIVOTDATA Function4 lessons

Module 27: PivotTable Dashboard Design4 lessons

Module 28: Refresh and Source Management4 lessons

Module 29: Troubleshooting PivotTables4 lessons

Module 30: Interactive Dashboard Capstone Project4 lessons

Module 31: Business Data Grain and Dimensionality4 lessons

Module 32: Sales Analysis4 lessons

Module 33: Profit & Margin Analysis4 lessons

Module 34: Customer & Order Analytics4 lessons

Module 35: Inventory Analysis4 lessons

Module 36: Procurement & Supplier Analysis4 lessons

Module 37: HR Analytics4 lessons

Module 38: Attendance & Workforce Productivity4 lessons

Module 39: Finance & Expense Analysis4 lessons

Module 40: Operations & Production Analytics4 lessons

Module 41: Project Management Analytics4 lessons

Module 42: Marketing & Campaign Analytics4 lessons

Module 43: Customer Service & Support Analytics4 lessons

Module 44: Reconciliation & Audit Analytics4 lessons

Module 45: Real-World MIS Reporting Capstone Project4 lessons

Module 46: Multiple Related Tables4 lessons

Module 47: Data Model Fundamentals4 lessons

Module 48: Power Pivot Introduction4 lessons

Module 49: DAX Fundamentals4 lessons

Module 50: Advanced Data Model Analysis4 lessons

Module 51: Power Query for PivotTables4 lessons

Module 52: Large Dataset Analysis4 lessons

Module 53: Reporting Automation4 lessons

Module 54: Advanced Calculations and Modeling4 lessons

Module 55: Executive Storytelling4 lessons

Module 56: Capstone Project One: Sales Analytics4 lessons

Module 57: Capstone Project Two: Inventory & Procurement4 lessons

Module 58: Capstone Project Three: HR & Attendance4 lessons

Module 59: Capstone Project Four: Finance & Operations4 lessons

Module 60: Final Professional Analytics Capstone4 lessons

Clear all filters

Excel PivotTables & Real-World Data Analysis (Hinglish)

Open course