AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Excel 2000

Print Version

This course has been designed to get you up and going quickly, easily, and painlessly with Microsoft® Excel, the most popular spreadsheet application in the marketplace today. The instructor guides you through the use of everything from basic spreadsheet functions to advanced techniques and functions ensuring your success and enhanced productivity.



3 levels - 103 modules - 9 learning hours

 

Available Options

SINGLE USER: Excel 2000 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$149.00Add To Cart
1 YR ONLINE, e-Study Guides$149.00Add To Cart
CD-ROMs, e-Study Guides$149.00Add To Cart
MULTI USER: Excel 2000 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$298.00Add To Cart
CD-ROMs, e-Study Guides$298.00Add To Cart
For additional licensing options. pricing and information, call 877-752-3529

Course Instructor: Dennis P. Taylor

Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.

Course Outline

Level 1

1.0 The Excel Screen
  • 1.1 The Excel Workbook and Worksheets
  • 1.2 Title Bar and Menu Bar
  • 1.3 Toolbars
  • 1.4 Formula Bar
  • 1.5 Columns and Rows
  • 1.6 Navigation
  • 1.7 Sheet Names and the Status Bar
  • 1.8 Mouse Pointers and Shortcut Menus
  • 1.9 Section Summary

2.0 Entering Data

  • 2.1 Data Entry Techniques
  • 2.2 AutoFill Entry Techniques
  • 2.3 Erasing Data
  • 2.4 AutoComplete and Pre-Selection
  • 2.5 Undo and Redo
  • 2.6 Section Summary

3.0 Working With Existing Documents

  • 3.1 Three Methods of Entering Formulas
  • 3.2 Repeating a Formula in Adjacent Cells
  • 3.3 Additional Formulas
  • 3.4 Section Summary

4.0 Basic Excel Functions

  • 4.1 Summation
  • 4.2 Recalculating & Hierarchy of Operations
  • 4.3 Other Functions
  • 4.4 Section Summary

5.0 Formatting

  • 5.1 The Formatting Toolbar
  • 5.2 Adjusting Column Widths & Row Heights
  • 5.3 Numeric Formatting
  • 5.4 Section Summary

6.0 Saving, Opening and Closing Files

  • 6.1 File Save or File Save As
  • 6.2 Opening and Closing a File
  • 6.3 Creating a New Workbook
  • 6.4 Section Summary

7.0 The Excel Help System

Level Summary

Level 2

1.0 Changing Worksheet Layout

  • 1.1 Inserting Columns, Rows, and Cells
  • 1.2 Deleting Columns, Rows, and Cells
  • 1.3 Moving Cells
  • 1.4 Copying Cells
  • 1.5 Section Summary

2.0 Additional Formatting

  • 2.1 Formatting Cell Attributes and Alignment
  • 2.2 Borders
  • 2.3 Numeric Formatting
  • 2.4 Centering Text Across Columns
  • 2.5 Hiding and Unhiding Columns and Rows
  • 2.6 Section Summary

3.0 Printing

  • 3.1 Using Print Preview and Page Setup
  • 3.2 Printing Controls
  • 3.3 Using Page Break Preview
  • 3.4 Section Summary

4.0 Using Cell References

  • 4.1 Absolute References
  • 4.2 Mixed References
  • 4.3 Section Summary

5.0 The Tools Options Command

  • 5.1 Show/Hide Gridlines and Formulas
  • 5.2 File List and New Workbook Sheets
  • 5.3 Default Settings 5.4 Section Summary

6.0 Introduction to Charting - An Overview

  • 6.1 Quick Chart Creation
  • 6.2 Chart Types
  • 6.3 Titles, Gridlines, and Scaling
  • 6.4 Formatting Basics
  • 6.5 Printing and Copying Charts

Level Summary

Level 3

1.0 Adjusting Worksheet Views

  • 1.1 Freeze/Unfreeze Panes
  • 1.2 Horizontal and Vertical Split Screens
  • 1.3 Section Summary

2.0 Formula Auditing Techniques

  • 2.1 Using the Auditing Toolbar
  • 2.2 Tracing Dependant Cells
  • 2.3 Tracing Precedent Cells
  • 2.4 Section Summary

3.0 The IF and VLOOKUP Functions

  • 3.1 IF Functions and Relational Operators
  • 3.2 Logical Operators with the IF Function
  • 3.3 Nested IF Functions
  • 3.4 The VLOOKUP Function
  • 3.5 Section Summary

4.0 Dates and Times

  • 4.1 Using Dates as Values
  • 4.2 Entering a Series of Dates
  • 4.3 Date/Time Entry Techniques
  • 4.4 Section Summary

5.0 Multi-sheet Workbooks

  • 5.1 Renaming Sheets
  • 5.2 Inserting and Deleting Sheets
  • 5.3 Moving, Copying, and Grouping
  • 5.4 Formulas Across Multiple Sheets
  • 5.5 Section Summary

6.0 Intro to Database Features - An Overview

  • 6.1 Sorting Data
  • 6.2 Creating Subtotals
  • 6.3 Filtering
  • 6.4 Pivot Tables
Level Summary