Excel 2019 Pivot Tables

This course is included (as well as over 200 others) in every subscription!
Description
Materials

Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.

What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.

What you'll learn:  You’ll learn how to easily create, modify, and update Pivot Tables and charts.

Excel 2019 Pivot Tables

Sign up to view this video Video Description
  • Introduction
  • Data Mining
  • Adding Related Data Using VLOOKUP
  • Inserting Pivot Tables
  • Setting Up Pivot Tables
  • Building Pivot Tables
  • Filtering and Slicing Pivot Table Data
  • Changing Source Data and Refreshing Pivot Tables
  • Inserting Pivot Charts
  • Using Tables to Build Pivot Tables
  • Setting Default Layouts for Reports
  • Using Pivot Table Styles
  • Subtotals and Grand Totals
  • Creating Report Pages
  • Adding the Power Pivot Tab to Excel
  • Creating Tables for the Data Model
  • Adding Relantionships with Power Pivot
  • Using DAX Expressions with Power Pivot
  • Creating Pivot Tables with Power Pivot
  • When to Use Power Pivot
  • Conclusion
 
No Practice Files

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102