Course Outline

1. Getting Started

• Spreadsheet terminology
• The Excel environment
• Navigating a worksheet
• Using a template

2. Entering and Editing Data

• Entering and editing text and values
• Entering and Editing formulas
• Saving and updating workbooks

3. Modifying a Worksheet

• Moving and copying data
• Moving, copying, and viewing formulas
• Absolute and relative references
• Inserting and deleting ranges, rows and column

4. Functions

• Entering functions
• AutoSum
• Other common functions

5. Formatting

• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options

6. Charts

• Chart basics
• Formatting charts

7. Graphics

• Working with pictures
• Conditional formatting with graphics
• SmartArt graphics

8. Printing

• Preparing to print
• Page Setup options
• Printing worksheets

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Course Outline

1. Managing Workbooks and Worksheets

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
• Linking worksheets with 3-D formulas
• Using multiple workbooks
• Linking workbooks

2. Advanced formatting

• Using Special number formats
• Working with themes
• Other advanced formatting

3. Outlining and Subtotals

• Outlining and consolidating data
• Creating subtotals

4. Cell and Range Names

• Creating and using names
• Managing names

5. Data Structure and Tables

• Sorting and filtering data
• Working with tables

6. Web and Sharing Features

• Saving workbooks as Web pages
• Using hyperlinks

7. Documenting and Auditing

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

8. Application Settings and Templates

• Application settings
• Working with templates

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Course Outline

1. Advanced Functions and Formulas

• Logical functions
• Conditional functions
• Financial functions
• Text functions
• Date and time functions
• Array formulas
• Calculation options

2. Lookups and Data Tables

• Using lookup functions
• Creating data tables

3. Advanced Data Management

• Validating cell entries
• Advanced filtering

4. Advanced Charting

• Chart formatting options
• Combination charts
• Graphical objects

5. PivotTables and PivotCharts

• Working with PivotTables
• Modifying PivotTable data
• Formatting PivotTables
• Using PivotCharts
• PowerPivot

6. Exporting and Importing data

• Exporting and importing text files

7. Analytical Tools

• Goal Seek
• Scenarios
• Instant data analysis

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Course Outline

Module 1: Developing Macros

• TOPIC A: Create a Macro Using the Macro Recorder
• TOPIC B: Edit a Macro
• TOPIC C: Debug a Macro
• TOPIC D: Customize the Quick Access Toolbar and Hotkeys
• TOPIC E: Set Macro Security

Module 2: Formatting Worksheets Using Macros

• TOPIC A: Insert Text
• TOPIC B: Format Text
• TOPIC C: Sort Data
• TOPIC D: Duplicate Data
• TOPIC E: Generate a Report

Module 3: Creating an Interactive Worksheet

• TOPIC A: Determine the Dialog Box Type
• TOPIC B: Capture User Input

Module 4: Working with Multiple Worksheets

• TOPIC A: Insert, Copy, and Delete Worksheets
• TOPIC B: Rename Worksheets
• TOPIC C: Modify the Order of Worksheets
• TOPIC D: Print Worksheets

Module 5: Performing Calculations

• TOPIC A: Create User-Defined Functions
• TOPIC B: Automate SUM Functions