Excel 2000 Day 4

Working with Outlines

Applying an Outline

Expanding/Collapsing an Outline

Modifying Outline Settings

Clearing an Outline

Using Auto Outline

Working with Outlines

Using Macros

Defining Macros

Opening a Workbook Containing Macros

Running a Macro

Using a Shortcut Key

Using the Visual Basic Toolbar

Opening the Visual Basic Editor Window

Using the Visual Basic Editor Window

Using Macros

Recording Macros

Recording a Macro

Assigning a Shortcut Key

Using Relative References

Assigning a Macro to a Menu

Deleting a Macro from a Menu

Deleting a Macro

Recording Macros

Editing Macros

Writing a New Macro

Entering Macro Comments

Copying Macro Commands

Editing Macro Commands

Typing Macro Commands

Running a Macro from the Code Window

Editing Macros

Using Custom Toolbars and Buttons

Creating a Custom Toolbar

Adding a Button to a Toolbar

Adding a Custom Button

Assigning a Macro to a Button

Changing a Button Image

Displaying Button Text and Images

Attaching a Custom Toolbar

Deleting a Custom Toolbar

Using Custom Toolbars and Buttons

Creating a Macro Button

Using a Macro Button

Creating a Macro Button

Copying a Macro Button

Formatting a Macro Button

Moving/Sizing a Macro Button

Deleting a Macro Button

Creating a Macro Button

Consolidating Worksheets

Consolidating Worksheets

Consolidating by Category

Consolidating by Position

Consolidating Worksheets

Working with Data Series

Using the Series Command

Creating a Linear Series

Creating a Date Series

Using a Stop Value

Working with Data Series

Working with the Data Map

Using the Data Map

Organizing the Map Worksheet

Creating a Basic Map

Refreshing a Map

Changing the Map Format Type

Inserting Data into a Map

Deleting a Chart Format

Magnifying and Moving a Map

Printing the Data Map

Working with the Data Map

Modifying Charts

Adding and Removing Gridlines

Formatting Gridlines

Formatting an Axis

Changing the Axis Scaling

Formatting the Data Series

Adding Data - Different Worksheets

Using a Secondary Axis

Changing Data Series Chart Types

Adding a Trendline

Charting Non-adjacent Ranges

Creating an Exploded Pie Chart

Adjusting the 3-D View

Creating User-defined Charts

Applying User-defined Charts

Modifying Charts

Drawing an Object

Working with Drawing Objects

Drawing Enclosed Objects

Drawing a Line

Selecting Filled and Unfilled Objects

Moving an Object

Adding Text to an Object

Selecting Text in an Object

Resizing an Object

Formatting Lines

Changing and Removing the Fill Color

Changing the Font Color

Deleting an Object

Drawing an Object

Using Additional Effects and Objects

Adding a 3-D Effect

Applying a 3-D Setting

Adding a Shadow

Drawing a Text Box

Drawing an Arrow

Inserting Pictures

Formatting Graphics

Using Additional Effects and Objects

Using AutoShapes

Working with AutoShapes

Drawing a Callout

Drawing a Basic Shape

Drawing a Connector

Drawing a Flowchart Shape

Drawing a Block Arrow

Using AutoShapes

Using HTML Files

Previewing a Web Page

Creating a Hyperlink

Saving a Worksheet as a Web Page

Opening an HTML File

Using HTML Files