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 2000

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 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 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 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
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.