Learn how to quickly explore and analyze raw data using Excel Pivot Tables and Pivot Charts.

This course is designed to give you a deep, comprehensive understanding of Excel PivotTable features and functionality, including:

• Table Layouts & Styles
• Conditional Formatting
• Sorting, Filtering & Grouping
• Calculated Values & Fields
• Visualization with Pivot Charts
• and more!

We'll show you when, why, and how to use core features, introduce advanced sorting, filtering, and formatting techniques, and guide you through hands-on demos and exercises each step of the way.

In the final section, you'll practice applying your skills to 10 real-world case studies, including burrito ratings, shark attack records, stock quotes, wine tasting scores, and more.

WHO SHOULD TAKE THIS COURSE?

• Excel users looking to extract meaningful insights, patterns and trends from raw data
• Anyone seeking to improve productivity and build core analytical thinking skills

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Excel 2010+ or Office 365 (ideally for PC/Windows)
• Mac users are welcome to join, but may have challenges following along
• No advance preparation is required