General 

InformationCourse Duration: 4 hours

Audience: First-time users of Excel 97; those aiming to become certified as Proficient Users of Excel 97 

Prerequisites: Basic familiarity with the Windows 95 or Windows NT 4.0 user environments

Topics Covered

• Starting Excel 
• Worksheets and workbooks 
• Hands-on: Saving a workbook 
• Previewing and printing 
• Hands-on: Printing a worksheet 
• The Help facility 
• Entering and changing data 
• Hands-on: Entering data 
• Working with rows and columns 
• Hands-on: Inserting a column 
• Copying and moving data 
• Hands-on: Copying a column 
• Adjusting column widths and row heights 
• Formatting numbers 
• Hands-on: Formatting numbers 
• Formatting text 
• Hands-on: Formatting text 
• Creating formulas 
• Hands-on: Entering a formula 
• Automatic features and filling formulas 
• Hands-on: Using AutoSum 
• Date formulas 
• Hands-on: Using a date formula 

Course Aim

Learning Objectives

• work comfortably in the Excel environment 
• create new workbooks and manipulate data in existing ones 
• format rows, columns, and numbers 
• create and use formulas 

General Information

Course Duration: 5 hours

Audience: First-time users of Excel 97; those aiming to become certified as Proficient Users of Excel 97 

Prerequisites: Basic familiarity with the Windows 95 or Windows NT 4.0 user environments and thorough understanding of the content of the preceding course Microsoft Office 97: Beginning Excel 97

Topics Covered

• Using ranges 
• Defining names 
• Hands-on: Naming a range 
• Using functions 
• Hands-on: Using the Max functions 
• Sorting 
• Hands-on: Sorting data 
• Chart basics 
• Modifying charts 
• Hands-on: Changing a chart type 
• Formatting and printing charts 
• Hands-on: Formatting a chart 
• Working with maps 
• Creating lines and objects 
• Hands-on: Annotating a chart 
• Creating 3-D shapes 
• Hands-on: Changing a 3-D shape 
• Customizing toolbars 
• Hands-on: Removing a toolbar 
• Using styles 
• Customizing headers and footers 
• Hands-on: Customizing a header 
• Navigating the Internet 
• Creating an HTML spreadsheet 
• Hands-on: Saving an HTML spreadsheet 
• Using hyperlinks 
• Hands-on: Creating a hyperlink 

Course Aim

Learning Objectives

• perform operations on ranges and use functions 
• sort data 
• create, format, and modify charts and graphics 
• use the Drawing tools 
• customize the Excel 97 environment and workbooks 
• create and use HTML spreadsheets 

General Information

Course Duration: 3 hours

Audience: Users already proficient in the use of Excel 97; users aiming for Expert User certification 

Prerequisites: Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in the preceding course Microsoft Office 97: Intermediate Excel 97

Topics Covered

• Using templates 
• Hands-on: Creating a template 
• Group editing 
• Hands-on: Editing a group 
• Editing shared workbooks 
• Hands-on: Sharing a workbook 
• Protecting worksheets 
• Hands-on: Protecting a worksheet 
• Protecting workbooks 
• Tracing dependents 
• Hands-on: Tracing dependents 
• Tracing and correcting precedents 
• Hands-on: Precedents 
• Creating and modifying outlines 
• Consolidating data 
• Hands-on: Consolidating data 
• Managing large sheets 

Course Aim

Learning Objectives

• perform advanced editing tasks 
• implement security and auditing procedures 
• create and modify outlines 
• consolidate data 
• manage large sheets 

General Information

Course Duration: 4 hours

Audience: Users already proficient in the use of Excel 97; users aiming for Expert User certification 

Prerequisites: Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in the preceding course Microsoft Office 97: Advanced Excel 97

Topics Covered

• Recording and running macros 
• Hands-on: Recording a macro 
• Hands-on: Running a macro 
• Editing macros 
• Hands-on: Editing a macro 
• Lists as databases 
• Hands-on: Using data forms 
• Sorting and filtering lists 
• Hands-on: Sort and Custom AutoFilter 
• Querying a database 
• Hands-on: Running a Web query 
• Data analysis with PivotTables 
• Linking data 
• Hands-on: Creating a data link 
• Importing and exporting between Excel and other applications 
• Hands-on: Embedding an object 
• Defining custom views and scenarios 
• Hands-on: Defining a scenario 
• Creating reports 
• Hands-on: Creating a report 

Course Aim

Learning Objectives

• record, run, and edit macros 
• use database functions and run Web queries 
• share data with other workbooks and other applications 
• use Report Manager to create custom reports