This course is not currently offered by Global Knowledge. Information here is provided for reference only.

This course The following topics are also covered: the application of templates and conditional and custom formats, the use of Paste Special, how to customize preferences and to share workbooks. It also addresses worksheet protection and the handling of multiple workbooks.

For this course, training is performed on student's equipment. We provide the software and data files for the training.

What You'll Learn

• Working with Tables
• Working with Advanced Filters
• Exporting and Importing Data
• Working with Outlines
• Using Advanced Charting Features
• Using Conditional and Custom Formats
• Using TemplatesUsing Paste Special
• Customizing Excel Preferences
• Using Worksheet Protection
• Using Multiple Workbooks
• Sharing Workbooks

Who Needs to Attend

Business users who have taken Excel 2007 - Level 2 (Course 6605) or have equivalent knowledge

Prerequisites

There are no prerequisites for this course.

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Working with Tables

• Using Tables
• Creating a Table from Existing Data
• Changing the Table Name
• Changing the Table Style
• Changing Table Style Options
• Creating a Total Row
• Adding Table Rows and Columns
• Inserting/Deleting Table Rows/Columns
• Creating a Calculated Column
• Selecting Parts of a Table
• Moving a Table
• Sorting Data by Multiple Levels
• Using Text Filters
• Using Number Filters
• Using Data Validation
• Validating Data using a List
• Creating a Custom Error Message
• Removing Data Validation

2. Working with Advanced Filters

• Creating a Criteria Range
• Using a Criteria Range
• Showing All Records
• Using Comparison Criteria
• Using an Advanced 'And' Condition
• Using an Advanced 'Or' Condition
• Copying Filtered Data
• Using Database Functions
• Finding Unique Records
• Removing Duplicates from a Table

3. Exporting and Importing Data

• Exporting Data to Other Applications
• Importing Data from Access
• Importing Data from Text Files
• Changing External Data Range Properties
• Importing Data from Other Applications
• Removing the Query Definition
• Importing Dynamic Data from the Web
• Copying a Table from a Web Page

4. Working with Outlines

• Applying an Outline
• Collapsing/Expanding an Outline
• Modifying Outline Settings
• Using Auto Outline
• Clearing an Outline
• Creating Subtotals in a List
• Removing Subtotals from a List

5. Advanced Charting

• Adding and Removing Gridlines
• Formatting Gridlines
• Formatting an AxisChanging the Axis Scaling
• Formatting the Data Series
• Adding Data from Different Worksheets
• Using a Secondary Axis
• Changing Data Series Chart Types
• Adding a Trendline
• Creating a Chart Template
• Applying a Chart Template

6. Using Conditional and Custom Formats

• Applying Conditional Formats
• Changing a Conditional Format
• Adding a Conditional Format
• Creating a Custom Conditional Format
• Using Data Bars
• Deleting a Conditional Format
• Creating a Custom Number Format

7. Using Templates

• Working with Templates
• Saving a Workbook as a Template
• Using a Template
• Editing a Template
• Inserting a New Worksheet
• Deleting a Template
• Creating Default Templates
• Finding Online Templates

8. Using Paste Special

• Working with Paste Special
• Copying Values between Worksheets
• Copying Formulas between Worksheets
• Performing Mathematical Operations

9. Customizing Excel Preferences

• Setting Edit Options
• Setting Display Options
• Setting Manual Calculation
• Resetting Automatic Calculation
• Setting Popular Options

10. Using Worksheet Protection

• Unlocking Cells in a WorksheetProtecting a Worksheet
• Unprotecting a Worksheet
• Creating Allow-Editing Ranges
• Deleting Allow-Editing Ranges
• Protecting Workbook Windows
• Unprotecting Workbook Windows
• Assigning a Password
• Opening a Password-protected File
• Removing a Password

11. Using Multiple Workbooks

• Opening Multiple Workbook Windows
• Cascading Open Workbook Windows
• Activating Cascaded Workbook Windows
• Tiling Open Workbook Windows
• Activating Tiled Workbook Windows
• Comparing Workbooks Side by Side
• Copying Data between Workbooks
• Saving a Workspace
• Closing All Open Workbooks
• Opening a Workspace
• Linking Workbooks
• Opening Linked Workbooks

12. Sharing Workbooks

• Using Shared Workbooks
• Saving a Shared Workbook
• Viewing Users Sharing a Workbook
• Viewing Shared Workbook Changes
• Changing the Update Frequency
• Highlighting Changes
• Managing Conflicting Changes
• Resolving Conflicting Changes
• Setting Change History Options
• Adding a History Worksheet
• Reviewing Tracked Changes
• Merging Shared Workbook Files