Core Training for Microsoft Office Excel 2007 (Exam 77-602): Online Course

Table of Contents:
Getting Started with Microsoft Office Excel 2007; Getting Started with Excel 2007; Module Introduction; Exploring the Excel 2007 Environment; Lesson Introduction; Elements of the Excel 2007 User Interface; Features of Excel 2007; Self Test; Creating and Modifying a Workbook; Lesson Introduction; Create a Workbook; Lab: Setting up a Workbook; Create and Rename a Worksheet in a Workbook; Lab: Modifying a Workbook; Customise a Workbook; Self Test; Modifying a Worksheet; Lesson Introduction; Modify Columns and Rows in a Worksheet; Lab: Inserting and Modifying Columns and Rows; Data Entry Options; Lab: Entering a Data Series; Self Test; Editing Data in a Workbook; Lesson Introduction; List the Paste Options Available in Excel 2007; List the Find and Replace Dialog Box Controls; Lab: Moving, Finding, and Replacing a Value in a Workbook; Lab: Finding a Cell in the Workbook with a Particular Format; Use the Dictionary and Thesaurus; Self Test; Module Summary; Glossary; Performing Calculations on Data in Microsoft Office Excel 2007; Performing Calculations on Data in Excel 2007; Module Introduction; Managing Groups of Data; Lesson Introduction; Create and Rename a Table; Lab: Adding and Modifying a Row in a Table; Lab: Naming Groups of Data; Self Test; Using Formulas for Performing Calculations on Data; Lesson Introduction; Create and Edit a Formula; Use the Function Library; Lab: Using Relative and Absolute References to Create a Formula; Create a Conditional Formula; Self Test; Identifying Errors in a Formula; Lesson Introduction; Identify Error Codes; Trace the Precedents and Dependents of a Cell; Evaluate Parts of a Formula; Use the Watch Window; Lab: Auditing a Worksheet; Self Test; Module Summary; Glossary; Formatting and Printing Worksheets in Microsoft Office Excel 2007; Formatting and Printing Worksheets in Excel 2007; Module Introduction; Changing Workbook Appearance; Lesson Introduction; Format a Cell; Lab: Creating and Applying Styles to Cells; Workbook Themes and Styles; Create and Apply a Table Style; Lab: Applying Themes and Styles; Self Test; Enhancing the Readability of a Workbook; Lesson Introduction; Format Numeric Data; Conditional Formatting; Lab: Creating and Applying Conditional Formats; Add Images to a Worksheet; Self Test; Printing Worksheets; Lesson Introduction; Headers and Footers; Lab: Creating a Custom Header for a Workbook; Set the Workbook Properties; Lab: Printing a Worksheet; Self Test; Filtering and Summarising Data in Microsoft Office Excel 2007; Filtering and Summarising Data in Excel 2007; Module Introduction; Filtering Data; Lesson Introduction; Identify Filters in Excel 2007; Lab: Creating and Using Filters; Summarise List of Data; Lab: Performing Calculations on Filtered Data; Self Test; Reordering Data; Lesson Introduction; Sorting Options in Excel 2007; Lab: Sorting a Data List in Excel 2007; Organise Data into Levels; Find Data by Using VLOOKUP; Self Test; Validating Data; Lesson Introduction; Data Validation in Excel 2007; Lab: Creating a Validation Rule; Self Test; Module Summary; Working with Pivot Tables and Charts in Microsoft Office Excel 2007; Working with Pivot Tables and Charts in Excel 2007; Module Introduction; Creating and Manipulating PivotTable Reports; Lesson Introduction; PivotTable Reports in Excel 2007; Organise 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 Customising a Chart; Lesson Introduction; Create and Manipulate a Chart; Chart Styles Gallery in Excel 2007; Customise and Save a Chart as Chart Template; Lab: Customising a Chart; Self Test; Module Summary; Collaborating with Others in Microsoft Office Excel 2007; Collaborating with Others in Excel 2007; Module Introduction; Allowing Multiple Users to Access a Workbook; Lesson Introduction; Share a Workbook; Save a Workbook as a Web Document; Lab: Sharing a Workbook; Self Test; Managing a Shared Workbook; Lesson Introduction; Add Comments to a Cell in a Workbook; Manage Changes in a Shared Workbook; Lab: Tracking Changes in a Workbook; Self Test; Protecting and Authenticating Workbooks; Lesson Introduction; Access Protection; Lab: Password-Protecting a Workbook; Digital Signatures and Certificates; Authenticating a Workbook; Self Test; Module Summary; Glossary.