Excel 2000 --

Beginning - - Charting - - Intermediate/Advanced - - Advanced - - Macros

Excel 2000 - Beginning Level-Worksheets

Full Day

Students will learn how to create a basic worksheet, navigate in an existing worksheet, use built-in functions and format the worksheet. Participants should be familiar with Microsoft Windows 95/98. No knowledge of Excel is assumed.
Getting Started
• The paper spreadsheet
• The Excel program
• The workbook environment

Entering Data and Navigating in a Worksheet

• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file
• Navigation and movement techniques

Modifying a Workbook

• Working with ranges
• Working with functions
• Editing cell contents

Moving and Copying Data

• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature

Formatting a Worksheet

• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting

Printing a worksheet

• Checking spelling
• Using Print Preview
• Printing the entire worksheet
• Printing specified ranges
• Additional Print options

Introduction to the workbook environment

• Using a multiple-sheet workbook
• Creating a chart
• Outlining
• Spreadsheet solutions

Creating Excel Web pages

• Using Excel as a Web tool

Top

Excel 2000 - Charting and Organizing Data

Course Outline

Full Day

Students will learn how to create charts to graphically represent worksheet data, and how to maintain and manage lists. Participants in this course should understand the basic concepts involved in using Excel for Windows worksheets and the use of the menu system for copying data and for opening and saving files. Excel Beginning Level course or equivalent knowledge is required.


Creating charts

• Creating a chart sheet
• Creating an embedded chart
• Comparing chart sheets and embedded charts

Modifying a chart sheet

• Chart types
• Adding and deleting chart items
• Moving and sizing chart items

Modifying an embedded chart

• Selecting and editing
• Moving and sizing
• Printing

Formatting a chart

• Formatting chart text
• Formatting numbers
• Formatting the chart
• Printing a chart sheet

Autoformats

• Built-in autoformats
• User-defined autoformats

Using graphic objects

• Working with graphic objects
• Using graphic objects to enhance worksheets and charts

Advanced charting topics

• Experimenting with series
• Changing the scale
• Adding a trendline and creating an overlay chart
• Protecting charts

Sorting data

• Single-level sorting
• Multiple-level sorting
• Sorting options
• Using the Data, Subtotals command
• Design considerations

AutoFilter

• Filtering a list
• Custom criteria
• Managing a filtered list

Advanced filter

• Multiple-condition criteria
• Copying filtered data

Data form

• Maintaining a list by using the data form
• Appendix
• Answer keys


Top

Excel 2000 - Intermediate/Advanced

Course Outline

Full Day

Students will learn the skills and concepts necessary to work with advanced capabilities of Excel. Students should have a basic knowledge of the concepts involved in using Excel for Windows worksheets. For example, they should be familiar with data types (labels and values), copying data, basic formulas and functions, and opening and saving files. The Excel Beginning Level course is required or equivalent knowledge.


Sorting Data

• Single-level sorting
• Multiple-level sorting
• Sorting options
• Using the Data, Subtotals command
• Design Considerations

AutoFilter

• Filtering a list
• Custom criteria
• Managing a filtered list

Advanced Filter

• Multiple-condition criteria
• Copying filtered data

Data form

• Maintaining a list by using the data form

Customizing the work area

• Working with existing toolbars
• Creating a new toolbar
• Creating and using styles
• Creating templates

Advanced formula construction

• Nested functions
• The IF function
• The VLOOKUP function
• Error handling and the Auditing Features

Pivot tables

• Creating Pivot tables
• Working with Pivot tables
• Viewing Pivot tables at different levels

Mutliple file linking

• Working with workbooks
• Linking individual cells
• Workbooks versus links and Workspaces

Outlining and consolidating Information

• Outlining
• Consolidating worksheets

Protect and display options

• Notes
• Protecting the worksheet
• Hiding information
• View manager


Top

Excel 2000 - Advanced Level

Course Outline

Full Day

Students will learn various advanced techniques for analyzing and manipulating data. Participants should be familiar with Microsoft Windows 95/98 or Excel 2000 beginning and intermediate levels, or equivalent knowledge.

Customizing the Work Area
• Working with built-in toolbars
• Using custom toolbars
• Creating and using styles
• Using templates

Advanced Formula Construction

• Using names
• Using the IF function
• Using the VLOOKUP function
• Using IS functions and the Auditing features

Using Pivot Tables

• Creating pivot tables
• Modifying pivot tables
• Grouping and summarizing data in a pivot table

Working with Multiple Worksheets

• Working with workbooks
• Linking cells in different workbooks
• Workbook verses links and workspaces

Consolidating and Analyzing Data

• Consolidating data from more than one worksheet
• Using the Goal Seek and Solver utilities
• Using Scenario Manager to view a worksheet with different input values

Using Protection and Display Options

• Using comments
• Protecting workbooks
• Using custom views

Introduction to Macros

• Running macros
• Recording a macro
• Viewing and editing VBA code

Working with Interactive Excel Web Documents

• Saving Excel worksheets as Web documents
• Spreadsheet Web components

Top

Excel 2000 - Customizing and Creating Macros

Course Outline

Full Day

Students will learn the skills to customize the Excel workspace by setting options, customizing toolbars, and customizing startup options.  They will examine sample code, learn how to create macros from scratch, and add to previously created macros, and create custom functions.  Students should have a strong knowledge of Excel.
Customizing Excel Workspaces
• Working with built-in toolbars
• Setting Options
• Customizing Toolbars
• Adding and Deleting Toolbar Buttons
• Resetting and Deleting Toolbars
• Arranging and Saving Workspaces

Customizing Startup

• Opening Workbooks at Startup
• Opening Custom Workspaces at Startup
• Creating Desktop Icons

Collaborating with Workgroups

• Creating Templates
• Editing Templates
• Creating Auto Templates
• Collaborating with Workgroups

Using AutoFormats in Worksheets and Charts

• Using Built-in AutoFormats
• Creating Custom Chart Formats

Controlling Macros

• Controlling Macro Cell References
• Saving Macros for Selective Use

Editing Macros

• Opening the Visual Basic Environment
• Inserting Procedures
• Finding and Replacing Code
• Deleting and Copying Code
• Adding Comments

Running Macros from Menus and Buttons

• Assigning Macros to the Menu Bar
• Assigning Macros to Toolbar Buttons
• Assigning Macros to Worksheet Buttons
• Changing the Assigned Macro

Making Macros Interactive

• Displaying Dialog Boxes in Macros
• Displaying Message Boxes in Macros

Using Break Mode

• Inserting Breakpoints
• Inserting Stop Statements

Stepping Through Macros

• Stepping Over Procedures
• Stepping Into Procedures

Top