AppShopper

Discover Excel 2007 - Part I (Lite)

       iOS iPhone

Discover Excel 2007 (Lite) 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.

UPGRADE:
• The full version of this title includes our "Glossary Hotlink" feature! Jump to related training directly from the Glossary!

Discover Excel 2007 - Part I (Lite) 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

Screenshots

	Screenshot 1 of 2

Share with Others

Last changed:

May 20, 2010

Category:

Business

Developer:

Last Syllable Systems Inc.

Version:

1.0.0

Average Rating:

No data

Size:

147 MB

Other Apps By This Developer

• Discover Access 2007 - Part I
• Discover Access 2007 - Part II
• Discover Access 2007 HD - Part I
• Discover Access 2007 HD - Part II
• Discover Excel 2007 - Part I
• Discover Excel 2007 - Part II
• Discover Excel 2007 - Part II (Lite)
• Discover Excel 2007 HD - Part I
• Discover Excel 2007 HD - Part II
• Discover Outlook 2007 - Part I
• Discover Outlook 2007 - Part I (Lite)
• Discover Outlook 2007 - Part II
• Discover Outlook 2007 - Part II (Lite)
• Discover Outlook 2007 HD - Part I
• Discover Outlook 2007 HD - Part II
• Discover PowerPoint 2007
• Discover PowerPoint 2007 HD
• Discover Word 2007 - Part I
• Discover Word 2007 - Part II
• Discover Word 2007 HD - Part I
• Discover Word 2007 HD - Part II
• Learn Vista & PC Basics Part I