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 2007: Pivot Tables for Data Analysis

Course Summary

In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Exercise files accompany this course.


  • +

    Course Syllabus

    1. Creating and Pivoting PivotTable Reports
    2. Summarizing PivotTable Data
    3. Sorting and Filtering PivotTable Data
    4. Formatting PivotTable Reports
    5. Emphasizing Data Using Conditional Formatting
    6. Creating and Manipulating PivotChart Reports
    7. Printing PivotTable and PivotChart Reports
    Conclusion


Course Fee:
USD 19.99

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