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 2003

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. For those seeking certification as a Microsoft® Office Specialist (MOS) this course provides MOS elements that meet all the requirements and prepare you to become MOS Certified

5 levels - 173 modules - 15 learning hours

 

Available Options

SINGLE USER: Excel 2003 (5 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$229.00Add To Cart
1 YR ONLINE, e-Study Guides$229.00Add To Cart
CD-ROMs, e-Study Guides$229.00Add To Cart
DVD-Video, e-Study Guides$229.00Add To Cart
MULTI USER: Excel 2003 (5 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$458.00Add To Cart
CD-ROMs, e-Study Guides$458.00Add To Cart
DVD-Video, e-Study Guides$458.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

Excel 2003: Level 1
Getting Started
  • Starting Excel
  • Workbooks and Worksheets
  • Task Pane
  • Menu Bar and Shortcut Menus
  • Toolbars
  • Navigation and Mouse Pointer
Entering Data
  • Data Entry
  • Auto-Fill Entry
  • Erasing Data
  • AutoComplete and Preselections
  • Undo and Redo
Saving, Opening and Closing Files
  • File Save and File Save As
  • Opening a File
  • Closing a File
  • Creating a New Workbook
Entering Formulas
  • Methods of Entering Formulas
  • Repeating Formulas in Adjacent Fields
  • Formula Operators
  • Additional Formulas
Basic Excel Functions
  • Totals and Averages
  • Function Overview
Formatting
  • Adjusting Column Widths and Row Heights
  • Formatting Toolbar
  • Numeric Formatting
Changing Worksheet Layout
  • Inserting Columns, Rows and Cells
  • Deleting Columns, Rows and Cells
  • Moving Cells
  • Copying Cells
Printing
  • Using Print Preview and Page Setup
  • Printing Controls
  • Printing
Excel Help System
  • Using Excel Online Help
  • Using Excel Offline Help
Excel 2003: Level 2
Additional Formatting
  • Cell Alignment and Orientation
  • Borders
  • Centering Text Across Columns
  • Hiding and Unhiding Columns and Rows
Conditional Formatting
  • Formatting Based on Values and Multiple Conditions
  • Avoiding Overlapping Conditions
  • Using a Formula to Control Formatting
Specialized Numeric Formatting
  • Custom Category
  • Special Category
Cell References
  • Absolute References
  • Mixed References
Range Names
  • Naming and Using Range Names
  • Additional Creation Methods
  • Pasting a List of Range Names in a Worksheet
  • Deleting Range Names
  • Assigning a Name to a Value
Formula Auditing Techniques
  • Using the Formula Auditing Toolbar
  • Tracing Dependent Cells
  • Tracing Precedent Cells
Cell Protection Techniques
  • Locking/Unlocking Selected Cells
  • Protecting/Unprotecting a Worksheet
Find and Replace
  • Matching Entire Cells and Case Factors
  • Formulas and Wildcard Characters
  • Find and Replace by Format
Adjusting Worksheet Views
  • Freeze/Unfreeze Panes
  • Horizontal and Vertical Split Screens
Customizing Toolbars
  • Adding and Removing Buttons
  • Economizing Buttons and Resetting Toolbars
  • Creating New Tool Bars
Excel 2003: Level 3
The "IF" Function
  • "IF" Functions and Relational Operators
  • Using Text in "IF" Functions
  • Logical Operators ("AND" and "OR") with "IF" Functions
  • Nested "IF" Functions
  • Getting Table Data with "VLOOKUP" Function
Dates and Time
  • Using Dates as Values
  • Entering a Series of Dates
  • Date/Time Techniques
Multi-Sheet Workbooks
  • Renaming Sheets and Coloring Tabs
  • Inserting and Deleting Sheets
  • Moving, Copying and Grouping Sheets
  • Formulas Across Multiple Sheets
Multiple Workbooks
  • Opening and Displaying Multiple Workbooks
  • Moving and Copying Sheets Across Workbooks
  • Linking Formulas Across Workbooks
  • Locating and Maintaining Links
Features and Settings
  • Show/Hide Gridlines and Formulas
  • Recently Used File List and New Workbook Settings
  • Other Settings and Features
Overview of Charting
  • Quick Chart Creation
  • Chart Types
  • Titles, Gridlines and Scaling
  • Formatting Basics
  • Printing and Copying Charts
Overview of Database Features
  • Sorting Data
  • Creating Subtotals
  • Filtering
  • Pivot Tables
MOS ELEMENTS
Excel 2003 Level 6: MOS Additional Topics
Templates
  • Saving a Skeleton Workbook as a Template
  • Creating a New Workbook from a Template
  • Editing a Template
Protection
  • Workbook Protection
  • File Password
  • Macro Security
Sharing Workbooks
  • Establishing Sharing
  • Tracking Changes
  • Merging Workbooks
Exporting Data From Excel
  • Exporting to Access
  • Exporting to Word
  • Saving as a Text File
  • Saving as a New Folder
Importing Data to Excel
  • Importing Data Using the File Open Command
  • Importing or Copying External Data
  • Hyperlinks
  • Tools Research
Excel and the Web
  • Importing Web Data
  • Saving Excel Data as a Webpage
Customizing Excel Environment
  • Creating a New Menu
  • Creating a Macro
  • Running a Macro
  • Editing a Macro
Excel 2003 Level 7: MOS Special Topics
Functions
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • Mathematical Functions
Formula Troubleshooting
  • Formula Watch Window
  • Evaluate Formula Feature
Data Analysis Tools
  • Goal Seek
  • Solver
  • Scenarios
  • Data Table
Consolidating Data
  • Consolidate By Position
  • Consolidate By Category
Managing a List
  • Creating a List
  • Adding Data to a List
  • Adding Totals
File Properties
  • File Properties
Workbook/Worksheet
  • Worksheet Styles
  • Autoformatting
  • Showing Multiple Worksheets
  • Comparing Workbooks