Excel PivotTables Part 2: PivotCharts & Dashboards
Offered By: Skillshare
Course Description
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
Related Courses
Excel Skills for Business: Intermediate IMacquarie University via Coursera Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Access 2016: Building Dashboards for Excel
LinkedIn Learning Excel 2016: Setting Up a Database
LinkedIn Learning Excel PivotTables: Mastering PivotTables and PivotCharts
LinkedIn Learning