Instructor Based Class Outline for
Introduction to Excel

Table of Contents

Instructor Based Class Outline for
Intermediate Excel

Table of Contents

Instructor Based Class Outline for
Advanced Excel

Table of Contents

1. Getting Started

·      Understanding Excel

·      Examining The Projects

·      Examining The Excel Window

·      Opening A Workbook

·      Follow-up

2. Entering Text And Formulas

·      Entering And Editing Data

·      Working With Columns And Rows

·      Understanding Formulas

·      Using Paste Function

·      Entering More Formulas

·      Follow-up

3. Moving And Copying Data

·      Looking At The Office Clipboard

·      Cutting, Copying, And Pasting

·      Moving Cells

·      Using Fills

·      Follow-up

4. Exploring Formula Construction

·         Understanding Cell References

·         Using Relative References

·         Using Absolute References

·         Using More Functions

·         Follow-Up

5. Formatting Worksheet Appearance

·         Adjusting Rows And Columns

·         Formatting Numbers

·         Aligning Text

·         Formatting Text

·         Applying Borders and Shading

·         Follow-Up

6. Working With Charts

·         Understanding Charts

·         Creating Charts

·         Modifying Charts

·         Finishing the Chart

·         Follow-Up

7. Printing Worksheets

·         Understanding Printing

·         Adjusting Page Setup

·         Setting Up Headers And Footers

·         Setting Print Titles And Options

·         Setting Print Areas

·         Follow-Up

8. Application Project

·         Corporate Sales Forecast

9. Using Help Appendix

·         Using The Help Window

·         Using The Contents Card

·         Using The Answer Wizard

·         Working With The Index

·         Using Context-sensitive Help

·         Follow-up

10. Common Tools And Shortcuts Appendix

11. Standard Tools

12. Formatting Tools

13. Navigation Shortcuts

14. Index

1. Exploring Excel

·      Looking At This Course

·      Examining The Projects

·      Setting Up Excel

·      Renaming Worksheets

·      Moving Worksheets

·      Follow-up

2. Using Lists

·      Working With Databases

·      Working In Lists

·      Sorting Lists

·      Using Auto-Correct

·      Follow-up

3. Working With Functions

·      Understanding Paste Function

·      Using Logical Functions

·      Using Financial Functions

·      Using Date Functions

·      Follow-up

4. Formatting Worksheets

·      Auto-Formatting Worksheets

·      Formatting Worksheets

·      Using Page Breaks

·      Working With Objects

·      Follow-Up

5. Using 3-D References

·      Understanding 3-D Workbooks

·      Linking Worksheets

·      Showing Formulas and References

·      Follow-Up

6. Using Excel And The Web

·      Understanding The Web

·      Saving As Different File Types

·      Working With Web Pages

·      Looking At Web Pages

·      Follow-Up

7. Using Templates

·      Understanding Templates

·      Using A Template

·      Customizing The Template

·      Entering Data

·      Follow-Up

8. Using Microsoft Map

·      Understanding Microsoft Map

·      Working With Data Maps

·      Adding Data To Data Map Objects

·      Reconfiguring Data Maps

·      Follow-up

1. Getting Started

·      Looking At This Course

·      Examining The Projects

·      Setting Up Excel

·      Using Templates

·      Follow-up

2. Working With Records and Ranges

·      Using Data Forms

·      Using Named Ranges

·      Formatting Numbers

·      Using Custom And Conditional Formatting

·      Follow-up

3. Sorting, Outlining, And Filtering Lists

·      Sorting Lists

·      Using Macros

·      Using Grouping And Outlines

·      Applying Data Filters

·      Understanding Advanced Filters

·      Follow-up

4. Importing And Exporting Data

·      Understanding Importing

·      Importing from Text Files

·      Querying Databases

·      Importing From HTML Files

·      Exporting To Other Applications

·      Follow-up

5. Using Pivot Tables and Pivot Charts

·      Creating Pivot Tables

·      Adjusting Pivot Tables

·      Showing and Hiding Information

·      Using Pivot Table Pages

·      Using Pivot Tables And The Web

·      Creating Pivot Charts

·      Follow-up

6. Using Data Analysis Tools

·      Understanding Solver

·      Using Solver

·      Understanding Scenarios

·      Understanding Goal Seek

·      Auditing A Worksheet

·      Follow-up

7. Protecting And Sharing Workbooks

·      Understanding Shared Workbooks

·      Applying Protection And Sharing

·      Setting File Passwords And Properties

·      Follow-up

8. Managing Workbooks

·      Using Data Validation

·      Using Comments

·      Tracking Changes

·      Merging Workbooks

·      Linking Workbooks

·      Printing Worksheets And Reports

·      Follow-up