Online Training Courses - Course 5429: Working with Pivot Tables and Charts in Microsoft® Office Excel® 2007

    View Video Demo
    Price
    £
    (excl. VAT)
    Call to Buy 0870 145 1600
    Publisher Name: MICROSOFT LEARNING
    ISBN: 5038470001345
    User Level: Intermediate/Advance
    This online course covers the skills and knowledge you will need to create and format PivotTable and PivotChart reports in Microsoft® Office Excel® 2007. This includes editing and formatting PivotTable reports, as well as inserting charts into your worksheets.

    This course is 1 hour long.

    Objectives:
    At the end of this course, students will be able to:

    Create and manipulate PivotTables.
    Edit and Format PivotTables
    Create and customize a chart

    System Requirements:
    Pentium II 400 MHz;
    256MB RAM;
    Microsoft Internet Explorer 6.0 or higher;
    256k connection (broadband recommended);
    Windows XP, 2000 or higher;
    Flash Player 7.0 or higher;
    Speakers and soundcard.

    Subscription: 1 year

    You will need Excel 2007 installed on your machine to use some of the local labs in this course.

    Course 5429: Working with Pivot Tables and Charts in Microsoft® Office Excel® 2007

    Course Overview
    Module Introduction
    Navigation Overview
    Lab Information
    Course Information

    Working with Pivot Tables and Charts in Excel 2007
    Module Introduction

    Creating and Manipulating PivotTable Reports
    Lesson Introduction
    PivotTable Reports in Excel 2007
    Organize Data in a PivotTable Report
    Lab: Creating and Pivoting a PivotTable Report
    Filter a PivotTable Report
    Show and Hide PivotTable Report Details
    Self Test

    Editing and Formatting PivotTable Reports
    Lesson Introduction
    Edit a PivotTable Report
    Change the Summary Function in a PivotTable Report
    Apply Formats to a Field
    Lab: Formatting a PivotTable Report
    Create a PivotTable Report from External Data
    Self Test

    Creating and Customizing a Chart
    Lesson Introduction
    Create and Manipulate a Chart
    Chart Styles Gallery in Excel 2007
    Customize and Save a Chart as Chart Template
    Lab: Customizing a Chart
    Self Test
    Module Summary
    Glossary
    Module Introduction