|
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
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.
Objective
Upon completion of this course, the student will be able to:
- Work with cells
- Work with files
- Format worksheets
- Work with worksheets and workbooks
- Work with formulas and functions
- Use charts and objects
- Import and export data
- Use templates
- Use multiple workbooks
- Format numbers
- Print workbooks
- Work with named ranges
- Use editing tools
Topics Include
Getting Started
- Use the Menu bar, the Standard toolbar and the Format
- 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
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
Enter Excel functions using the Formula Bar
- Enter Excel functions using the Formula Bar
- Enter Excel functions using the Formula Bar
- Enter Excel functions using the Formula Bar
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
- Using Conditional Formatting
- Apply conditional formats
Printing Worksheets and Reports
- Print and preview multiple worksheets
- Use the Report Manager
Working with Named Ranges
- Create and name ranges
- SUBTOPIC
- 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
Duration
10 hrs
Minimum Requirements
Shockwave 8.0, 200 MH Pentium CPU (266 recommended), 32 MB of available RAM, (64 recommended), Windows 95, 98, 2000 or NT; (Windows 2000 or NT require 64MB of RAM)
Media
Web Based Training
|
