Print World

Professional Training

Live Workshop on Excel Pivot Table and Dynamic Dashboard

5
25 ratings
  • Date: 29 & 30 Dec 2023
  • Time: 08:30 PM - 10:00 PM
  • Total Hours: 3
  • Class Schedule: Fri-Sat
  • Registration Deadline: 29 Dec 2023
  • No. of Classes/Sessions: Total 2 Sessions
  • Venue: Online (Live Class on Zoom)
  • Price: BDT 599

    Enrol

    What you will learn

  • Convert large sets of data into simpler tables and charts.

  • Create statistical report in precise way using pivot table and charts.

  • Efficient techniques of Data analysis and representation from large datasets.

  • Sort through large data sets and consolidate into suitable summary.

  • Build easy to understand and customized reports that are visually smart, interdependent and dynamic in nature.

  • Real life case/problem solving relating to pivot table and dashboard creation.

  • Who should attend the program?

    The course is designed for any working professionals particularly - Data/business analysts, financial professionals, Sales Managers, Marketing executives who need to struggle through large datasets for analyzing, reporting, creating review reports on a regular basis. The course will help to reduce the amount of manual work by introducing the most valuable excel tool -pivot table.

    Training content

    Session 01

    Excel PivotTables and Pivot Charts

    • Understanding Excel Pivot Tables
    • Creating an Excel Pivot Table
    • Modifying Excel Pivot Table Calculations
    • Grouping Pivot Table Data
    • Formatting Pivot Table Data
    • Modifying Pivot Table Calculations
    • Drilling Down into Pivot Table Data
    • Creating Pivot Charts
    • Filtering Pivot Table Data
    • Filtering with the Slicer Tool
    Session 02

    Making a Dynamic Dashboard using Pivot Charts

    • Making a Dashboard
    • Formatting and changing Pivot Charts
    • Modification of Dynamic Dashboard
    • Question / Answer with real-life queries

    Instructor's Profile

    Mir Masud Uz Zaman

    Mir Masud Uz Zaman is a professional MS Excel...

    Mentor Details

    Certificate Preview

    Recommended Courses

    Mohammad Shariar Nafees

    5
    Content
    Total 2 Sessions
  • 10 & 11 Nov 2023
  • Digital Content for Business Growth

    BDT 1000

    Enrol

    Mir Masud Uz Zaman

    5
    MS Excel
    Total 1 Session
  • 15 Nov 2023
  • Conditional Formatting and Data Validation

    BDT 399

    Enrol

    Md. Towfiqur Rahman

    5
    MS Excel
    Total 1 Session
  • 18 Nov 2023
  • Data Analytics with Advanced Excel

    BDT 600

    Enrol

    Nusrat Huda

    5
    Email Writing
    Total 1 Session
  • 10 Mar 2022
  • Professional Email Writing

    BDT 600

    Enrol

    Md. Rashedul Islam

    5
    MS Excel
    Total 2 classes
  • 18 & 19 Feb 2022
  • মাইক্রোসফট এক্সেলে হাতেখড়ি

    BDT 400

    Enrol

    Asad Zaman

    5
    MS Excel
    Total 4 classes
  • 30 Dec 2021 & 01, 02, 04 Jan 2022
  • MS Excel - আপনার পেশাজীবনে এগিয়ে যাবার হাতিয়ার

    BDT 600

    Enrol