The Complete Excel Pro Tips Certification Bundle

16 Reviews
2441 Enrolled
6 Courses & 11 Hours
$19.00$294.00
You save 93% -

What's Included

Excel Pro Tips: PivotTables
  • Certification included
  • Experience level required: Intermediate
  • Access 20 lectures & 2 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

20 Lessons (2h)

  • Getting Started
    Course Structure & Outline1:41
    DOWNLOAD: Course Resources
    Setting Expectations1:45
  • PivotTable Tips
    Introduction0:18
    Customizing the Field List4:07
    Autofitting Column Width4:21
    Outline & Tabular Layouts7:46
    Counting Non-Numerical Fields6:05
    Grouping Dates8:03
    Enabling Multiple Filters5:00
    Grouping Values6:50
    Adding Value Calculations9:01
    Showing Empty Items6:22
    Configuring Slicers & Timelines10:23
    Conditional Formatting8:23
    Removing & Reviving Source Data8:19
    Adding Custom Sort Lists5:23
    Solve Order & List Formulas6:16
    QUIZ: PivotTable Tips
  • Wrapping Up
    Resources & Next Steps

Excel Pro Tips: PivotTables

EM
Excel Maven

Instructor

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

This Excel Pro Tips: PivotTables course will be focusing on one of Excel's most powerful and flexible analytic tools—PivotTables. The 2-hour course will start with some common topics like slicers, table layouts, and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from a cache, defining custom sort lists, and more. This course will help you work smarter and not harder. By the end of this course, you'll be ready to slice, dice, and filter your data like a PivotTable pro.

  • Access 20 lectures & 2 hours of content 24/7
  • Understand the use of Excel slicers, table layouts & field list options
  • Learn grouping values, enabling multiple filters, reviving source data from the cache, defining custom sort lists & more
  • Slice, dice & filter data like a PivotTable pro
  • Practice & master PivotTables techniques used by professionals

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.