Excel: Level 3
Overview: Students will customize their workbooks, work with
multiple data sources, collaborate with other users, and enhance their
spreadsheets using charts and graphic objects.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction,
Excel Level 2
Table of Contents
Lesson 1: Customizing Your Workbook
Applying
Conditional Formatting
Adding Data Validation Criteria
Customizing Menus
Customizing Toolbars
Creating a Macro
Editing a Macro
Grouping and Outlining Structured Data
Lesson 2: Working with Multiple Data Sources
Creating
a Workspace
Consolidating Data
Linking Cells in Different Workbooks
Editing Links
Create a Web Query
Lesson 3: Collaborating with Others Using Workbooks
Protecting
Your Worksheets
Protecting Your Workbook
Sharing Your Workbook
Setting Revision Tracking
Merging Workbooks
Lesson 4: Enhancing Your Worksheet Using Charts
Charting
Non-adjacent Data
Modifying Chart Items
Creating a Trend Line
Lesson 5: Using Graphic Objects to Enhance Your Worksheet
Creating
Graphic Objects
Resizing, Moving, and Copying Graphic Objects
Changing the Order of Graphic Objects
Grouping Graphic Objects
Formatting Graphic Objects
Inserting Clip Art
Modifying Clip Art