Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

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

Skillshare

Excel PivotTables Part 2: PivotCharts & Dashboards

via Skillshare

Go to class Write review

This course may be unavailable.

Overview

This class is Part 2 of a three-part series covering data analysis with Excel PivotTables and PivotCharts.

PivotTables are an absolutely essential tool for anyone working with data in Microsoft Excel. Pivots allow you to quickly explore and analyze raw data, reveal powerful insights and trends otherwise buried in the noise, and provide fast, accurate and intuitive solutions to even the most complicated questions.

In this part of the course we'll focus on data visualization techniques using PivotCharts, slicers, timelines, and custom, interactive dashboards. 

Finally we'll wrap up with Part 3, where we'll tie it all together and explore several advanced, real-world case studies!

Requirements: 

  • Microsoft Excel (2010, 2013, 2016), ideally for PC
  • Mac users are welcome, but note that the PivotTable interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)

Syllabus

  • Intro to Pivot Charts
  • PivotChart Demo: Column Chart
  • PivotChart Demo: Pie/Donut Chart
  • PivotChart Demo: Clustered Bar Chart
  • PRO TIP: Prevent Charts from Resizing with Cells
  • Changing Chart Types on the Fly
  • PivotChart Demo: Stacked Area Chart
  • PivotChart Layouts & Styles
  • Moving PivotCharts to New Sheets
  • Applying Slicers & Timelines to Multiple Charts
  • Building a Dynamic Dashboard

Taught by

Chris Dutton

Reviews

Start your review of Excel PivotTables Part 2: PivotCharts & Dashboards

Go to class

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.