Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Introduction to Pivot Tables in Excel Part 2: How to Use Pivot Charts

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
11 Videos (54m)
    • Intro to Pivot Charts

      2:26
    • PivotChart Demo: Column Chart

      4:13
    • PivotChart Demo: Pie/Donut Chart

      5:46
    • PivotChart Demo: Clustered Bar Chart

      3:25
    • PRO TIP: Prevent Charts from Resizing with Cells

      4:45
    • Changing Chart Types on the Fly

      3:18
    • PivotChart Demo: Stacked Area Chart

      5:46
    • PivotChart Layouts & Styles

      4:03
    • Moving PivotCharts to New Sheets

      2:09
    • Applying Slicers & Timelines to Multiple Charts

      5:01
    • Building a Dynamic Dashboard

      13:22

About This Class

This class is Part 2 of a three-part series (Microsoft Excel - Data Analysis with PivotTables) 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!)

3 of 3 students recommendSee All

I have previously take an advance excel course where they explained pivot tables but that course can not compare to this great material with exercises, tips and tricks. I did the 1st part, the 2nd and I will be doing the 3rd. Looking fwd more courses from this instructor.

18

Students

--

Projects

Chris Dutton

Founder, Excel Maven

Chris Dutton is a Certified Microsoft Expert and Analytics Consultant with more than a decade of experience in the B.I and data science fields. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to clients and students across 130+ countries.

See full profile