Project
1 Advanced Formatting
Lesson 1 Apply Number Formats
Lesson 2 Create Custom Formats
Lesson 3 Use Styles and AutoFormats
Lesson 4 Using Conditional Formatting
Project
2 Using Charts and Maps
Lesson 1 Creating a Chart
Lesson 2 Formatting Text in a Chart
Lesson 3 Changing the Chart Type
Lesson 4 Enhancing a Chart
Lesson 5 Printing a Chart
Lesson 6 Creating a Data Map
Project
3 Creating More Complex Charts
Lesson 1 Formatting a Chart with Predefined Formats
Lesson 2 Creating a Custom Chart Format
Lesson 3 Adding a Trend Line to a Chart
Lesson 4 Adding a Data Table to a Chart
Lesson 5 Grouping Charts together
Project
4 Managing Multiple Worksheets and Workbooks
Lesson 1 Editing Multiple Worksheets Simultaneously
Lesson 2 Building and Organizing a Multiple-Sheet Workbook
Lesson 3 Moving and Copying Worksheets between Workbooks
Lesson 4 linking Cell Data across Workbooks
Lesson 5 Annotating a Worksheet with Comments
Lesson 6 Annotating a Worksheet with Text Boxes
Lesson 7 Previewing and Printing Workbooks
Lesson 8 Managing Multiple Workbooks
Projects
5 Personalizing the Excel Workplace
Lesson 1 Changing Excel's Default Settings
Lesson 2 Viewing and Moving Toolbars
Lesson 3 Customizing a Toolbar
Lesson 4 Creating a New Toolbar
Lesson 5 Adding Menus to Toolbars and Buttons to Menus
Lesson 6 Zooming In and Out on a Worksheet
Lesson 7 Splitting and Freezing Window Panes
Lesson 8 Arranging Multiple Windows
Lesson 9 Using Summary Information
Project
6 Using Excel with Other Programs
Lesson 1 Switching Among Applications
Lesson 2 Copying Data between Applications
Lesson 3 Linking Data between Applications
Lesson 4 Working with Embedded Data
Lesson 5 Saving Files in Other Formats
Lesson 6 Importing Data from Other Applications
Project
7 Automating Tasks with Macros
Lesson 1 Preparing to Record a Macro
Lesson 2 Recording a Macro
Lesson 3 Playing a Macro
Lesson 4 Recording a Macro to the Personal Macro Workbook
Lesson 5 Playing a Macro from the Personal Macro Workbook
Lesson 6 Unhiding and Editing the Personal Macro Workbook
Lesson 7 Creating a Macro Button in a Workbook
Lesson 8 Adding a Macro Button to a Toolbar
Project
8 Managing Data
Lesson 1 Naming a List
Lesson 2 Adding Records
Lesson 3 Sorting Records
Lesson 4 Finding and Deleting Records
Lesson 5 Extracting Records Using AutoFilter
Project
9 Designing Forms with Excel
Lesson 1 Adding a Check Box to Worksheet
Lesson 2 Adding an Option Button to a Worksheet
Lesson 3 Adding a Combo Box and Link to a Worksheet
Lesson 4 Adding a Spinner to a Worksheet
Lesson 5 Enhancing a Form Lesson Protecting a Form
Lesson 6 Saving a Form as a Template
Lesson 7 Using a Form Template
Lesson Editing Templates
Project
10 Creating Summary Reports
Lesson 1 Creating an Outline from an Existing Report
Lesson 2 Charting an Outline
Lesson 3 Creating Subtotal Reports
Lesson 4 Creating Multiple Subtotal Rows
Lesson 5 Consolidating Your Worksheets
Project
11 Creating Custom Reports with Pivot Tables
Lesson 1 Using the Pivot Table Wizard
Lesson 2 Rearranging Data in the Pivot table
Lesson 3 Adding Data to a Pivot Table
Lesson 4 Adding and Changing a Pivot Table Summary Function
Lesson 5 Hiding and Showing Pivot Table Details
Lesson 6 Formatting Your Pivot Table
Project
12 Comparing Data with Advanced Pivot Tables
Lesson 1 Updating a List
Lesson 2 Refreshing Pivot Tables
Lesson 3 Adding Fields to a List
Lesson 4 Editing a Pivot Table
Lesson 5 Grouping Data in a Pivot Table
Lesson 6 Creating a Chart from Pivot Table Data
Lesson 7 Changing the Pivot Table View and Updating a Chart
Project
13 Using Advanced Data Analysis Techniques
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Project
14 Sharing Workbooks on the Network
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Appendices
Working with Windows
95 Glossary
Student Exam Preparation Guide