Learn advanced PivotTable techniques to create a dynamic and automated dashboard in Excel!
PivotTables are more than just tools for analyzing your dataset. You can use PivotTables to create charts that update dynamically when your raw data updates. This class is all about creating an integrated dashboard with PivotCharts, Sparklines, and more. The best part is that your dashboard can update automatically if set up correctly with PivotTables.
Alongside Al, you'll learn how to:
<ul><li>Create a variety of visualizations like Sparklines, Data Bars, and Map charts</li>
<li>Organize your charts on a dashboard</li>
<li>Add Slicers to make it easy for your teammates to filter the data shown on the dashboard</li>
<li>Connect PivotTables to your dashboard to make updating your dashboard a breeze</li>
</ul>Set up your dashboard with PivotTables, Slicers, and more so that your teammates can interact with your dashboard easily. You'll also save time by automating your dashboard which prevents manual updates. You'll be actively using the Excel workbook I created for this class (see <a href="https://www.skillshare.com/classes/Advanced-Excel-PivotTable-Techniques-for-Creating-a-Cohesive-Dashboard/780163869/projects" rel="nofollow noreferrer noopener" target="_blank">Projects &amp; Resources</a>).
<img src="https://static.skillshare.com/uploads/discussion/tmp/a8a43336.png" class="zoomable rounded-image-wrapper" alt="a8a43336.png">
Who is this class for?
Advanced Excel users, but all students are encouraged to participate and enjoy. 
Prerequisites:
This class moves fast. You should have a basic understanding of Excel including:
<ul><li>Navigating around Excel</li>
<li>Writing basic formulas (including VLOOKUP)</li>
<li>Creating basic charts</li>
<li>Creating PivotTables</li>
</ul>Some classes to consider taking as a prerequisite:
<ul><li><a href="https://www.skillshare.com/classes/Excel-PivotTables-Advanced-PivotTable-Techniques-for-Analyzing-and-Presenting-Data-Faster/1925210346?via=user-profile" rel="nofollow noreferrer noopener" target="_blank">Excel PivotTables: Advanced PivotTable Techniques for Analyzing and Presenting Data Faster</a></li>
<li><a href="https://www.skillshare.com/classes/Intermediate-Excel-for-the-Real-World-Cleaning-Data-for-Analysis-and-Forecasting/912733650?via=user-profile" rel="nofollow noreferrer noopener" target="_blank">Intermediate Excel for the Real World: Cleaning Data for Analysis and Forecasting</a></li>
</ul>Software
I’ll be using Mac Excel 2016 for Office 365. You can use any of the following versions of Excel for this class:
<ul><li>Windows: Excel 2019, Excel 2016, Excel 2013  </li>
<li>Mac: Excel 2016, Excel 2011</li>
</ul>

Introduction

Creating Multiple Pivot Reports

Creating Dynamic Data Bars

Utilizing the Timeline Filter 

Creating a Map Chart

Viewing Quick Trends with Sparklines

Customizing Data Labels 

Consolidating to One Dashboard

Linking Interactive Slicers 

Updating Your Dashboard 

Final Thoughts

Advanced_PivotTables_Dashboard_SkillshareWorkbook.xlsx

Airbnb_Data_PivotTables_Project.xlsx

Excel: Advanced PivotTable Techniques for Creating a Cohesive Dashboard

Al Chen gave you 1 free month of Skillshare

Get 1 free month of Skillshare

Excel: Advanced PivotTable Techniques for Creating a Cohesive Dashboard

Creative Learning Made Easy

Company

Work With Us

Teach with Us

Shop

Mobile

English

English