Have you unlocked your potential?
Satisfaction Guaranteed.
Here at LearnLocker, we are committed to providing the best possible experience we can. If at any time you are not completely satisfied, we invite you to contact us with your comments and feedback. In addition, you have the right to cancel your membership at anytime. You can even cancel online through our website. Our cancellation policy and terms are covered in detail in the terms and conditions found in the LearnLocker Subscription Membership Agreement.

Excel 2002

Instructor: Dennis 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. Five years ago, he turned his attention to Excel spreadsheets and has become an Excel training specialist. Dennis brings a combination of in-depth knowledge and training experience to this course. Watch and Learn in minutes with Dennis.
Course Outlines
Level 1
1.0 The Excel Screen
1.1 The Excel Workbook
1.2 The Task Pane
1.3 Title Bar and Menu Bar
1.4 Toolbars
1.5 Formula
1.6 Columns & Rows
1.7 Navigation
1.8 Sheet Names & the Status Bar
1.9 Mouse Pointers & Shortcut Menus
2.0 Entering Data
2.1 Data Entry Techniques
2.2 AutoFill Entry Techniques
2.3 Erasing Data
2.4 AutoComplete & Pre-selection
2.5 IP Classes
3.0 Entering Formulas
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula in Adjacent Cells
3.3 Additional Formulas
4.0 Basic Excel Functions
4.1 Summation & Averaging
4.2 Recalculating Effects
4.3 Other Functions
5.0 Formatting
5.1 The Formatting Toolbar
5.2 Adjusting Column Widths
5.3 Numeric Formatting
6.0 Saving Files
6.1 File Save or File Save As
6.2 Opening & Closing a File
6.3 Creating a New Workbook
7.0 The Excel Help System
7.1 The Excel Help System
Level 2
1.0 Changing Worksheet Layout
1.1 Inserting Columns/Rows/Cells
1.2 Deleting Columns/Rows/Cells
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Centering Text Across Columns
2.5 Hiding and Unhiding Columns & Rows
3.0 Printing
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References
4.1 Absolute References
4.2 Mixed References
5.0 The Tools Options Command
5.1 Show/Hide Gridlines
5.2 File List & New Workbook
5.3 Default Settings
6.0 Introduction to Charting-An Overview
6.1 Quick Chart Creation
6.2 Chart Types
6.3 Titles/Gridlines & Scaling
6.4 Formatting Basics
6.5 Printing & Copying Charts
Level 3
1.0 Adjusting Worksheet Views
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split Screens
2.0 Formula Auditing Techniques
2.1 Using the Formula Auditing Toolbar
2.2 Tracing Dependent Cells
2.3 Tracing Precendent Cells
3.0 The IF & VLOOKUP Functions
3.1 IF & VLOOKUP Functions Operators
3.2 Logical Operators
3.3 Nested IF Functions
3.4 Getting Data from Tables
4.0 Dates & Times
4.1 Using Dates as Values
4.2 Entering a Series of Dates
4.3 Date/Time Entry Techniques
5.0 Multi-Sheet Workbooks
5.1 Renaming Sheets
5.2 Inserting & Deleting Sheets
5.3 Moving/Copying & Grouping
5.4 Formulas across Multiple Sheets
6.0 Introduction to Database Features
6.1 Sorting Data
6.2 Creating Subtotals
6.3 Filtering
6.4 Pivot Tables
Reset Password
Sign In:

You will be sent a link to the Reset Password page. Please note that the link may only be used today.