Master PivotTables in Excel to get better at analyzing and presenting data!
As a data analyst, you’re likely tasked with making sense of large data sets, leaving little time to summarize it into reports and dashboards. Join me as I share my advanced PivotTable techniques to make your data more interactive, enabling you to more quickly glean trends and insights from your data. 
What you'll learn
<ul><li>Create and set up PivotTables in order to better visualize your data </li>
<li>Filter, sort, and slice your data within a PivotTable </li>
<li>Add calculated fields to your PivotTables </li>
<li>Create PivotCharts to better visualize your data </li>
<li>Create and save PivotChart templates to match brand guidelines </li>
<li>Use GetPivotData for custom reports to get data and apply custom formatting </li>
<li>Refresh PivotTable with Macros to automatically update different layouts and views of your PivotTables </li>
</ul>Whether you're looking to become more efficient and proficient in Excel or other data analysis platforms, this class will allow you to more quickly understand and present data. You'll be actively using the Excel workbook I created for this class (see <a href="https://www.skillshare.com/classes/Excel-PivotTables-Advanced-PivotTable-Techniques-for-Analyzing-and-Presenting-Data-Faster/1925210346/projects" rel="nofollow noreferrer noopener" target="_blank">Projects &amp; Resources</a>).
<img src="https://static.skillshare.com/uploads/discussion/tmp/ea7a65da.png" class="zoomable rounded-image-wrapper" alt="ea7a65da.png">
Who is this class for?
Intermediate to advanced data analysts, 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>
</ul>Some classes to consider taking as a prerequisite:
<iframe src="https://www.skillshare.com/embed/video?sessionId=652596&amp;width=600&amp;height=337.07865168539&amp;authToken=" height="497" width="600"></iframe>
<iframe src="https://www.skillshare.com/embed/video?sessionId=3644992&amp;width=600&amp;height=337.07865168539&amp;authToken=" height="497" width="600"></iframe>
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 and Setting Up PivotTables

Filtering, Sorting, and Slicing

Adding Calculated Fields

Creating PivotCharts

GetPivotData for Custom Reports

Refreshing PivotTables with Macros

Final Thoughts

AdvancedPivotTables_SkillshareWorkbook.xlsx

HR_Employee_Attrition.xlsx

Excel PivotTables: Advanced PivotTable Techniques for Analyzing and Presenting Data Faster

Al Chen gave you 1 free month of Skillshare

Get 1 free month of Skillshare

Excel PivotTables: Advanced PivotTable Techniques for Analyzing and Presenting Data Faster

Creative Learning Made Easy

Company

Work With Us

Teach with Us

Shop

Mobile

English

English