Everything Desktop Training

Our curriculum combines proven instructional design techniques, realistic simulation and unparalleled interactivity with challenges, tests and feedback. Master the world's leading productivity tools today

Microsoft Excel 97 Training

Excel 97 Training provides the learner with the fundamental skills and advanced techniques needed for Excel 97, Microsoft's premiere spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 97 Training covers topics such as

Entering and editing cell content
Inserting and copying cells
Formatting numbers
Using basic functions
Working with named ranges

Demystify the world's leading spreadsheet application, Microsoft Excel 97. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. Microsoft Excel 97 Training takes the guesswork out of using Excel 97.

Learn exactly what you need to know with our interactive, multimedia courseware. Our animations and simulations teach fundamental techniques and let you apply what you have learned in a realistic application environment. Microsoft Excel 97 Training prepares you for the Microsoft Office User Specialist

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Working with cells » Working with files
» Formatting worksheets » Working with worksheets and workbooks
» Working with formulas and functions » Using charts and objects
» Importing and exporting data » Using templates
» Using multiple workbooks » Formatting numbers
» Printing workbooks » Working with named ranges
» Using editing tools
Course Description
Excel 97 Training will provide the learner with fundamental skills and advanced techniques
needed for Excel 97, Microsoft's premiere spreadsheet program. It is also excellent
preparation for the Microsoft Office User Specialist (MOUS) certification exam.
Audience Definition
Designed for learners who currently use or are beginning to use Microsoft Excel 97.
Prerequisites
Familiarity with the Microsoft Windows environment, and ability to use a keyboard and mouse.
Estimated Length
Each Learning Object is approximately 15-20 minutes in duration with a total
approximate time of 9.5 hours.
Course Outline
Getting Started
Entering and Editing Cell Content
Clearing Cells
Navigating in a Workbook
Inserting and Copying Cells
Working with Files
Opening and Saving Workbooks
Formatting Text
Formatting Numbers
Formatting Cells
Printing
Setting up Pages
Working with Rows and Columns
Working with Worksheets
Using Formulas
Using Basic Functions
Using Date, Financial, and Logical Functions
Working with Charts
Working with Objects
Importing and Exporting Data
Using Multiple Workbooks
Using Templates
Formatting Numbers
Using Conditional Formatting
Printing Worksheets and Reports
Working with Named Ranges
Displaying Data
Formatting Data
Using Editing Tools

Media Selection
Contextual Simulations: 87 Audio: Yes
Graphics display the user interface and key concepts
Rollovers let users interact with and view supplemental information
Animations illustrate processes
Advanced simulation technology allows users to practice skills and gauge their proficiency
Assessment Description
Pre-assessment Challenge
(3-4 standard questions and a performance-based simulation)
Lesson Review
(2 standard questions)
Final Test
(3-4 standard questions and a performance-based simulation)
Detailed Course Outline and Objectives
The objectives in the following Learning Objects cover the Microsoft Office User Specialist
(MOUS) requirements.
Getting Started
» Use the Menu bar, the Standard toolbar and the Formatting toolbar
» Use the Name box, the Formula bar, cell referencing, and sheet tabs
» Choose options in a dialog box
» Save and close a workbook
» Close Excel
Entering and Editing Cell Content
» Enter text and numbers
» Revise text and numbers
» Work with series
Clearing Cells
» Use Undo and Redo
» Delete cell contents
» Clear and format ranges
Navigating in a Workbook
» Go to a specific cell in a worksheet
» Use Find and Replace to locate and change cell content
» Prepare and print envelopes and labels
Inserting and Copying Cells
» Insert and delete cells in a worksheet
» Copy and move data
» Use the Paste Special feature to link or embed copied cells
Working with Files
» Save an Excel workbooks
» Use a template to create a new workbook
» Use the Office Assistant to get help
» Check spelling
Opening and Saving Workbooks
» Open electronic workbooks
» Use Save As to save a workbook with a different name or file format, or in a different location
» Save spreadsheets as HTML documents
Formatting Text
» Apply font formats
» Define, apply, and remove a style
» Use the Format Painter
» Rotate and indent text
Formatting Numbers
» Apply predefined numbers formats
» Adjust the decimal places
» Modify cell content alignment
Formatting Cells
» Modify the size of columns and rows
» Apply cell borders and shading
» Merging cells
» Apply an AutoFormat to cells
Printing
» Preview and print worksheets and workbooks
» Print the screen and ranges
» Print headers and footers
» Set, print, and clear a print area
Setting up Pages
» Change the orientation and scale of a page
» Set page margins and center worksheet data
» Insert and remove page breaks
» Set up headers and footers
» Set print titles options such as print titles, gridlines, print quality, and row & column headings
Working with Rows and Columns
» Insert and delete rows and columns
» Hide and unhide rows and columns
» Freeze and unfreeze rows and columns
» Change the zoom setting
Working with Worksheets
» Move between worksheets in a workbook
» Rename a worksheet
» Insert and delete worksheets
» Move and copy worksheets
Using Formulas
» Enter a range within a formula by dragging
» Enter formulas in a cell and using the formula bar
» Revise formulas
» Use absolute, relative and mixed cell references
Using Basic Functions
» Use AutoSum to add the values in a group of cells
» Use Paste Function to insert a function
» Use the Average, Min, and Max functions
» Enter Excel functions using the Formula Bar
Using Date, Financial, and Logical Functions
» Use date functions - NOW and DATE
» Use financial functions - FV and PMT
» Use logical functions - IF
Working with Charts
» Preview and print charts
» Create, format and modify charts
Working with Objects
» Insert, move, and delete an object
» Create and modify lines and objects
» Create and modify 3-D shapes
Importing and Exporting Data
» Import data from text files
» Import from other applications
» Export to other applications
Using Multiple Workbooks
» Link Workbooks
» Using a workspace
Using Templates
» Apply templates
» Edit templates
» Create templates
Formatting Numbers
» Apply built-in number formats
» Create custom number formats
Using Conditional Formatting
» Use conditional formatting with numbers
» Apply conditional formats
Printing Worksheets and Reports
» Print and preview multiple worksheets
» Use the Report Manager
Working with Named Ranges
» Create and name ranges
» Use a named range in a formula
» Copy and move ranges
Displaying Data
» Perform single and multi-level sorts to organize data
» Use grouping and outlining to summarize data
» Use subtotals to a list of data
Formatting Data
» Use data forms to assist data entry
» Apply data validation rules to a range of cells
» Use data filters to focus on specific data on a worksheet
Using Editing Tool
» Create, edit, and remove a comment
» Track changes in an Excel workbook