20 participants can join this course.

20 Reviews

Duration

6 hours

Lectures

3

Projects

1

Unleashing the power of Pivot Table

MS Excel Pivot Table Crash Course

COMPLETED

Training Start Date 31 Jul 2025      End Date    07 Aug 2025

Course Overview

The "MS Excel Pivot Table Crash Course" is a focused workshop designed to equip you with the skills to efficiently summarize, analyze, and visualize data using pivot tables. Whether you're managing large datasets or looking to enhance your reporting capabilities, this course covers everything from the basics of pivot table creation to advanced techniques like grouping, filtering, and customizing reports. By the end of the course, you'll be able to transform raw data into meaningful insights, streamline decision-making processes, and add value to your professional skillset. Perfect for anyone looking to unlock the power of Excel's data tools.

Class Schedule

Saturday and Friday

Class Time

8:00 PM to 10:00 PM

Course Fee

৳ 500
Registration Closed

Further communication.

[email protected]

+8809610961961

Course Curriculum

  • Pivot Table Essentials
  • A real-life Case Study with Advanced Pivot Table

    • Instructor Profile

    Course Content

    Pivot Table Essentials

    a. Convert data range / table to Pivot Table b. Understanding of Pivot Table fields c. (Filters, Columns, Rows & Values) d. Pivot Table Analyze option e. Slicer and Timeline f. Change source data g. Hide/unhide field lists, buttons & field headers h. Subtotals and grand totals in Pivot Table i. Change report layout in Pivot Table j. Insertion and removal of blank rows in Pivot Table k. Pivot Table stylish options

    A real-life Case Study with Advanced Pivot Table

    a. Create a custom PivotTable style b. Apply custom number formatting c. Sort using custom lists d. Apply multiple filters to data e. Adjust slicer settings f. Lock workbooks without locking slicers g. Create calculated field h. Create calculated item i. Solver order j. Use of GETPIVOTDATA formula k. Use GETPIVOTDATA for dependent data validation lists l. Create dynamic pivot chart title m. Add dynamic series to a pivot chart n. Add totals to a stacked column chart o. Combine data from multiple tables

    Pre-Requisites

    A basic understanding of Microsoft Excel, including navigating the interface, entering data, and performing simple calculations, is required for this course. No prior knowledge of pivot tables is necessary.

    Learning Outcomes

    By the end of this workshop, participants will be able to:

    1. Create and customize pivot tables to summarize large datasets.
    2. Use filtering, grouping, and sorting techniques for data analysis.
    3. Generate insightful reports and visualizations with pivot charts.
    4. Analyze trends, patterns, and key metrics efficiently.
    5. Apply advanced pivot table functions to solve real-world data problems.

    Benefits

    This workshop enhances your data analysis skills, saves time with efficient reporting, and boosts your professional value by mastering pivot tables—an essential tool for modern workplace productivity.

    Popular Courses

    A To Z IELTS

    Starting
    26 Feb, 2026

    A To Z IELTS
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    Lessons

    Enroll
    IELTS PREPARATION COURSE

    Starting
    27 Feb, 2026

    IELTS PREPARATION COURSE
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    30 Lessons

    Enroll
    Foundation Course

    Starting
    28 Feb, 2026

    Foundation Course
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    Lessons

    Enroll