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 with Excel Pivot Tables: Become an Awesome Analyst in 1 Week!

Course Summary

 The Complete Excel Pivot Table Guide for Excel 2007, 2010 & 2013. Become an Advanced Excel user & get that Dream Job you deserve!!


  • +

    Course Syllabus

    • CUSTOMISE YOUR PIVOT TABLE
    • VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
    • VALUE FIELD SETTINGS > SHOW VALUES AS
    • GROUPING
    • SORT
    • FILTER
    • SLICERS (NEW IN EXCEL 2010)
    • CALCULATED FIELDS & ITEMS
    • PIVOT CHARTS
    • CONDITIONAL FORMATTING PIVOT TABLES
    • GETPIVOTDATA formula
    • MACROS
    • DATA MANAGEMENT
    • BONUS VIDEOS

  • +

    Recommended Background

      No matter if you are a Beginner or an advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010 or 2013.


Course Fee:
USD 149

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 5 hours / week

This course is listed under Data & Information Management and Digital Media & Games 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