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

Microsoft Excel Pivot Tables - In-Depth Excel Training

Course Summary

Learn How To Manipulate Your Excel Data With Pivot Tables. An Essential Course For All Excel Users


  • +

    Course Syllabus

    • Preparing For Pivot Tables
      • Important - Download These First - Working Files
      • 0101 Series Introduction
      • 0102 What You Will Learn
      • 0104 How To Access Your Working Files
      • 0105 Using The Working Files
    • Getting Started With Pivot Tables
      • 0201 Getting Started
      • 0202 Why Use Pivot Tables
      • 0203 Identifying Parts
      • 0204 Preparing Data
      • 0205 What Has Changed With Pivot Tables
      • 0206 Creating Pivot Tables - The Quick Analysis Tool
      • 0207 Using Recommended Pivot Tables
      • 0208 Creating Pivot Tables Manually
      • 0209 Reviewing Summary Calculation Details
      • 0210 Using General Pivot Table Tools
    • Managing Pivot Table Data
      • 0301 Managing Data
      • 0302 Working With The Data Source
      • 0303 Controlling Pivot Table Refresh
      • 0304 Understanding The Pivot Cache
      • 0305 Working With The Pivot Cache
      • 0306 Pivoting Data In A Pivot Table
    • Formatting Pivot Tables
      • 0401 Formatting
      • 0402 Applying Basic Formatting
      • 0403 Modifying Pivot Table Design Using Layout Options
      • 0404 Renaming Pivot Table Fields
      • 0405 Repeating Row Labels In Pivot Tables
      • 0406 Formatting Numbers In Pivot Tables
    • Sorting And Filtering Pivot Tables
      • 0501 Sorting And Filtering - Part 1
      • 0502 Sorting And Filtering - Part 2
      • 0503 How To Sort Pivot Tables
      • 0504 How To Filter Pivot Tables
      • 0505 Using Data Slicers To Filter Pivot Tables
      • 0506 Applying Timelines To Filter By Date
      • 0507 Grouping Data
      • 0508 Grouping By Date
    • Manipulating Pivot Table Calculations
      • 0601 Manipulating Calculations
      • 0602 Changing Summary Calculations
      • 0603 Transforming Calculations With Show As
      • 0604 Creating Calculated Fields And Items
    • Visualizing Data With Pivot Charts
      • 0701 Visualizing Table Data With Charts
      • 0702 Creating Charts
      • 0703 Manipulating Charts
    • Course Closing
      • 0801 What You Now Know


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

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