Getting Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. The Ribbon
7. The Microsoft Office Button
8. The Quick Access Toolbar
9. Scroll Bars
10. The Formula Bar
11. The Workbook Window
12. The Status Bar
13. The Task Pane
14. The Mini Toolbar

Creating Basic Spreadsheets
1. Creating a New Workbook
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Selecting Cells
6. Entering Text Into Cells
7. Entering Numbers Into Cells
8. AutoComplete
9. Pick From List
10. Using the "Window" Command Group
11. Zooming the Spreadsheet
12. Managing Multiple Workbooks
13. Renaming Workbooks
14. Working with Excel File Formats

Using Ranges
1. Using Ranges
2. Selecting Ranges
3. Selecting Multiple Non-Adjacent Ranges
4. Entering Information Into a Range
5. Using AutoFill

Creating Formulas
1. Using Formulas
2. Formula Functions
3. Using AutoSum
4. Inserting Functions
5. Editing a Range
6. Using the Formula Palette
7. Using the Paste Function
8. Editing a Range
9. Formula AutoCorrect
10. AutoCalculate

Copying & Pasting Formulas
1. Absolute References and Relative References
2. Cutting, Copying & Pasting
3. AutoFilling Cells
4. Drag & Drop Cutting, Copying & Pasting
5. Using Undo
6. Using Redo

Columns & Rows
1. Selecting Columns & Rows
2. Changing Column Width & Row Height
3. AutoFitting Columns & Rows
4. Hiding/Unhiding Columns & Rows
5. Inserting & Deleting Columns & Rows

Formatting Spreadsheets
1. Using the Formatting Toolbar
2. Using the Format Cells Dialog Box
3. The Number Tab
4. The Alignment Tab
5. The Font Tab
6. The Border Tab
7. The Patterns Tab
8. Clearing All Formatting from Cells
9. Copying All Formatting from Cells to Another Area

Conditional Formatting & AutoFormatting
1. Conditional Formatting
2. AutoFormatting

Setting Spreadsheet Layout
1. Working with Page Breaks
2. Viewing the Header and Footer
3. The Page Setup Dialog Box

Printing Spreadsheets
1. Using Print Preview View
2. Printing Your Spreadsheet

Helping Yourself
1. Using Screen Tips
2. Using the Office Assistant
3. Using the Help Pane

Creating 3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References

Named Ranges
1. Naming Ranges
2. Moving to a Named Range
3. Using Named Ranges in Formulas
4. Creating Names from Headings
5. Deleting Range Names

Spreadsheet Tools
1. Moving between Spreadsheets
2. Selecting Multiple Spreadsheets
3. Inserting and Deleting Spreadsheets
4. Renaming Spreadsheets
5. Coloring Spreadsheet Tabs
6. Switching to Full Screen View
7. Splitting the Screen
8. Freezing Panes
9. Copying and Moving Entire Worksheets
10. Cutting, Copying and Pasting Data between Spreadsheets
11. Printing Multiple Spreadsheets
12. Hiding Spreadsheets

Using Workspaces
1. Creating Workspaces
2. Opening and Closing Workspaces
3. Selecting Workbooks in a Workspace
4. Organizing a Workspace

Paste Special
1. Paste Special Options
2. Pasting Linked Formulas

Sharing and Reviewing Workbooks
1. Sharing Workbooks
2. Highlighting Changes
3. Reviewing Changes
4. The Reviewing Toolbar
5. Inserting Comments
6. Managing Comments
7. Reviewing Comments
8. Printing Comments
9. Sending Spreadsheets for Review
10. Compare and Merge Workbooks

Auditing Spreadsheets
1. Auditing Spreadsheets
2. The Formula Auditing Toolbar
3. Tracing Precedent and Dependent Cells
4. Tracing Errors
5. Error Checking
6. Using the Watch Window
7. Cell Validation

Outlining Spreadsheets
1. Using Outlines
2. Applying and Removing Outlines

Consolidating Spreadsheets
1. Using Data Consolidation
2. Consolidation Types

Creating Spreadsheet Charts
1. Creating Charts
2. Moving and Resizing Charts
3. The Chart Toolbar
4. Formatting Chart Objects
5. Changing the Chart Type
6. Showing and Hiding the Legend
7. Showing and Hiding the Data Table
8. Shifting the Data Series
9. Angling Chart Text
10. Choosing a Chart Layout
11. Choosing a Chart Style
12. Printing Charts
13. Deleting Charts

Editing and Formatting Charts
1. Changing Chart Sub-types
2. Changing the Data Range
3. Changing Chart Titles
4. Repositioning the Legend
5. Adding Data Labels
6. Adding Free-standing Text
7. Time-Scale Data Plotting
8. Formatting a Data Series
9. Changing the Data Series Plot Order
10. Chart Axis Formatting
11. Formatting Data Markers
12. Adjusting Perspective in 3D Charts
13. Custom Chart Types

PivotTables
1. Creating PivotTables
2. Manipulating a PivotTable
3. Using the PivotTable Toolbar
4. Changing Data Field Properties
5. AutoFormatting PivotTables
6. Displaying a PivotChart
7. Setting PivotTable Options
8. Page Display Options
9. Adding Subtotals to PivotTables
10. Sorting and Filtering Fields

Lists
1. Creating a List
2. Adding and Editing Records
3. Inserting Records and Fields
4. Deleting Records and Fields

The Data Form
1. Using the Data Form
2. Adding and Deleting Records in the Data Form
3. Finding Records in the Data Form

Sorting Data
1. Sorting Data
2. Custom Sort Orders
3. Sorting Options

AutoFiltering Data
1. AutoFilter
2. Using the Top 10 AutoFilter
3. Using the Custom AutoFilter
4. Turning Off the AutoFilter

Advanced Filtering of Data
1. Creating Advanced Filters
2. Using 'And' and 'Or" Conditions in Criteria
3. Using Wildcard Characters in Criteria
4. Copying Filter Results to a New Location
5. Using Database Functions

Data Tables
1. Data Tables
2. The Formula Reference Table
3. Structuring a Single-variable Data Table
4. Structuring a Double-variable Data Table
5. Creating the Data Table

Lookup and Logical Functions
1. Lookup and Logical Functions
2. Lookup Functions
3. Logical Functions
4. Nesting Logical Functions
5. Masking Error Display in Worksheets
6. Using the AND and OR Functions

Scenarios
1. Creating and Displaying Scenarios
2. Editing and Deleting Scenarios
3. Merging Scenarios
4. Creating Scenario Reports
5. Using Goal Seek

Security Features
1. Unlocking Cells
2. Worksheet Protection
3. Workbook Protection
4. Password Protecting Excel Files

Making Macros
1. Recording Macros
2. Running Macros
3. Deleting Macros
4. The Personal Macro Workbook

Customizing Toolbars
1. Setting Toolbar and Menu Bar Options
2. Creating Custom Toolbars
3. Adding Buttons to Toolbars
4. Adding Macro Buttons to Toolbars
5. Adding Button Dividers to Toolbars
6. Removing Toolbar Buttons
7. Resetting and Deleting Toolbars

Back to Top

The best CPE Excel tutorial available.

• Designed by software training professionals.
• Earn your CPE hours and learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in a three-day classroom training.
• Includes the same three classroom manuals our students receive (in PDF), along with practice exercises & keyboard shortcuts!
• Customize your training with the easy-to-use menu.
• Clear, easy-to-follow, step-by-step instruction.
• Watch the training sessions as many times as you want while you practice in Excel.
• No messy set-up, no internet connections needed. Simply insert the first CD into your computer. The menu will launch automatically and you will be on your way to learning!
• The best way to earn your CPE hours and learn Excel on your own.
• The confidence in knowing your Excel tutorial was created by software training professionals.

Back to Top

All Products | Samples | FAQs | About Us | Contact Us

© TeachUcomp, Inc. All Rights Reserved.