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

Excel 2013 - Pivot Table

Course Summary

This course provides details of how Pivot Tables work. Use an Excel pivot table to summarize, analyze & present data


  • +

    Course Syllabus

    • Basics of Pivot Table
      • Data Formatting
      • Creating Pivot Table
      • Recommended Data Table
      • Pivoting Pivot Table
      • External Data
      • Consolidation Sheets
      • Managing Pivot Table
      • Basics of Pivot Table Without Solution
      • Basics of Pivot Table With Solution
    • Summarizing Data Using Pivot Table
      • Totals Display
      • Summary Display
      • Multiple Data Field
      • Data Grouping
      • Drill Down Data
      • Calculated Field
      • Summarizing Data Using Pivot Table Without Solution
      • Summarizing Data Using Pivot Table With Solution
    • Data Filtering
      • Pivot Data Sorting
      • Customised Sorting
      • Limited Data Display
      • Rule Based Sorting
      • Data Slicer
      • Slicer Formatting
      • Filter Area
      • Removing Filters
      • Data Filtering Without Solution
      • Data Filtering With Solution
    • Basics Pivot Table Formatting
      • Formatting Pivot Table
      • Layouts In Pivot Table
      • Basics Pivot Table Formatting Without Solution
      • Basics Pivot Table Formatting With Solution
    • Advanced Pivot Table Formatting
      • Rule Based Conditional Formatting
      • Top Bottom Rule Based
      • Data Bars
      • Adding Color Scales
      • Icon Indicators
      • Conditional Formatting
    • Session 6-Introduction of Pivot Chart
      • Basic Pivot Chart
      • Pivoting Pivot Chart
      • Filter Pivot Chart Data
      • Formatting Pivot Chart
      • Different Chart Types
      • Pivot Chart without Solution
      • Pivot Chart with Solution
    • How to Print the Pivot Table
      • Print Table Part 1
      • Print Table Part 2
      • Print Separate
      • Print Headers
      • Printing Table With Headers
      • Print Table
    • Using Macros In Pivot Tables
      • First Macro
      • Executingthe Macro
      • Using Macros In Pivot Tables Without Solution
      • Using Macros In Pivot Tables With Solution
    • Introduction of Power Pivot
      • Starting With Power Pivot
      • Why Use Power Pivot
      • Adding Table To Power Pivot
      • Creating Relationships Between Tables
      • Pivot TableIn Power Pivot
      • Get External DataIn Power Pivot
      • Introduction of Power Pivot Without solution
      • Introduction of Power Pivot With solution
    • DAX in Power Pivot
      • Introduction To DAX
      • Reference To Dax Functions
      • Adding Calculated Column
      • Adding Calculated Field
      • ​Power Pivot Calculated Field Without Solution
      • ​Power Pivot Calculated Field With Solution
      • Power Pivot Calculated Column with solution
    • Introduction of Power View
      • Introduction To Power View
      • Displaying Data Using Different Controls Part 1
      • Displaying Data Using Different Controls Part 2
      • Formatting Of Controls
      • Filters In Power View
      • Data Display Using Charts In Power View
      • Data Display Using Maps
      • Introduction of Power View Without Solution
      • Introduction of Power View With Solution


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

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