Discover Excel 2007 HD - Part I

Discover Excel 2007 HD is interactive multimedia training for users of Microsoft Office Excel 2007. The Discover products combine audio, animation, and software simulation to make the “discovery” of computer programs both effective and entertaining.

Discover Excel 2007 - Part I covers the following topics:

Introducing Excel 2007
• Office 2007 Overview
• Excel 2007 Overview

Screen Layout
• The Ribbon
• The Title Bar & Quick Access Toolbar
• The Office Button

Create & Open A WorkBook
• What Is A Workbook?
• Creating A New Workbook
• Use A Template
• Open An Existing Workbook

View A Workbook
• What Is A View?
• Use Page Layout View
• Page Break Preview
• Custom Views
• Show/Hide Options
• Zoom Command
• Splitting A Worksheet
• Freeze Rows & Columns
• View Workbooks Side By Side
• More Window Display Commands

Save A Workbook
• New Excel 2007 File Format
• Use The Save & Save As Commands
• Save A Workbook To Use In Earlier Versions Of Excel

File Compatibility
• Check Compatibility Between Excel Versions
• About File Converters

Print Workbooks
• Print Worksheets & Workbooks
• Modify Page Setup

Customize Excel [Expert]
• Excel Options
• Customize The Quick Access Toolbar
• Change Excel Options

Help in Excel 2007
• Microsoft Office Excel Help
• Working In The Excel Help Window
• Context Specific Help
• Office Diagnostics

Cell Basics
• What Is A Cell Reference?
• Select Cells
• Navigating A Worksheet

Enter Data
• Entering Data
• What Is A Value?
• What Is A Label?

Edit Data
• Edit Worksheet Data
• Find & Replace Data

Copy & Move Data
• Copying & Moving Data
• Copy & Move Data
• Use The Office Clipboard

Insert & Delete Cells
• Insert & Delete Cells

Modify A Worksheet
• Insert/Delete Rows & Columns
• About Resizing Rows & Columns
• Resize Rows & Columns
• Hide Rows & Columns

Modify A Workbook
• Insert & Delete A Worksheet
• Move/Copy A Worksheet To Another Workbook
• Rename A Worksheet
• Format Worksheet Tabs

Formulas
• What Is A Formula?
• Create A Formula
• Edit A Formula

Cell References
• Types Of Cell References
• Using Relative References
• Mixed References

Functions
• What Is A Function?
• Enter A Function Manually
• Insert A Function
• Use A Date Function
• Financial Functions
• Use A Financial Function
• Logical Functions
• Use A Logical Function

Work With Named Ranges
• Using Named Ranges
• Range Naming Rules
• Define A Range Name Using Labels
• Define Range Names For Data Without Labels
• Use A Named Range In A Formula

Use Lookup Functions [Expert]
• What Is A Lookup Function?
• The VLOOKUP Function
• Use The VLOOKUP Function

Find & Correct Errors [Expert]
• Auditing Worksheets
• Trace Errors
• Show Formulas
• Evaluate A Formula
• Use The Watch Window

Format Characters
• Formatting Text & Numbers
• Format Text
• Formatting Numbers
• Format Numbers
• Use A Custom Number Format

Format Cells
• Formatting Cells
• Aligning Cell Content
• Align Cell Content
• Merge Cells
• Apply Borders & Patterns
• Apply Color
• Format Painter
• Clear Cell Formatting
• Find & Replace Cell Formatting
• Cell Styles

Themes [Expert]
• Office 2007 Themes

Conditional Formatting [Expert]
• Conditional Formatting
• Apply Conditional Formatting