MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Pivot Tables for Excel 2016

Course Summary

This course is aimed at intermediate-level users of Excel 2010 and 2013 as well as 2016 for Windows and Mac who are unfamiliar with Pivot Tables and who need to summarize and analyze list-based data and make better business decisions based on that data.


  • +

    Course Syllabus

    Course Overview
    - 1m 35s

    —Course Overview 1m 35s
    Introduction to Pivot Tables
    - 33m 21s

    —Introduction 0m 34s
    —What Is a Pivot Table? 8m 23s
    —Creating a Basic Pivot Table 8m 45s
    —Using an Excel Table as a Data Source 6m 6s
    —Using an SQL Server Database as a Data Source 4m 18s
    —Creating a Pivot Table from Multiple Tables 4m 48s
    —Summary 0m 24s
    Customizations and Calculations
    - 30m 0s
    Sorting, Grouping, and Filtering
    - 36m 1s
    Pivot Charts and Data Visualizations
    - 17m 4s
    Creating a Basic Pivot Table Driven Dashboard
    - 25m 30s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top