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 File Tab and Backstage View
8. The Microsoft Office Button
9. The Quick Access Toolbar
10. Scroll Bars
11. The Formula Bar
12. The Workbook Window
13. The Status Bar
14. The Task Pane
15. 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 Excel training available.

• e-Learning is simply web-based training. There are no CDs or software to install on your computer. All you need is an internet connection and a web browser (such as Internet Explorer). Watch, listen and learn as training professionals demonstrate each lesson right on your computer screen. No long-term commitments. Cancel anytime.
• Always available. All of our courses are available 24 hours a day, 7 days a week. Once you purchase your subscription, simply login for instant access to your courses.
• Our courses are designed by software training professionals with years of classroom training experience.
• Learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in classroom trainings.
• FREE access to e-manuals. Your subscription includes access to classroom e-manuals (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 your software, making it the most realistic practice available.
• The best, most convenient way to learn on your own - at a fraction of the price of classroom training.
• The confidence in knowing your training was created by software training professionals.

Back to Top

All Courses | Samples | FAQs | About Us | Contact Us | Buy Now

© TeachUcomp, Inc. All Rights Reserved.