BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

PivotTables & Slicers - Create Dashboards & Summary Reports

ExcelIsFun via YouTube

Start learning Write review

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
India: 75% Off World: 40% Off
This course teaches how to utilize PivotTables, Slicers, and Dashboards in Excel for data analysis and business intelligence. The learning outcomes include creating Cross Tab Reports, Frequency Distributions, and a CPA Pass Rate Report. Students will learn to use Group By feature, Summarize Values By, and Show Values As to manipulate data effectively. The course employs a tutorial video format and is intended for individuals interested in mastering Excel Power Tools for data analysis.

Syllabus

) Introduction.
) What is a PivotTable? What is a Cross Tab Report..
) Build a Cross Tab Report with a PivotTable.
) PivotTable Cached Data.
) Building a Standard PivotTable as Part of Dashboard.
) Standard PivotTable vs. Data PivotTable.
) What is a Dashboard?.
) Use Group By Feature to group Monthly and Yearly Amounts.
) Summarize Values By to Change Aggregate Function.
) Use Slicers to Filter Entire PivotTable.
) Cell Phone Data Examples from Video to Build Frequency Distribution:.
) Show Values As to Change to Specific Calculations.
) CPA Data Examples from Video to Build CPA Pass Rate Report.
) Practice Problems, Homework.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of PivotTables & Slicers - Create Dashboards & Summary Reports

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.