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 2003

Course Outlines
Level 1
Introduction
1.0 Getting Started
1.1 Starting Excel
1.2 Workbooks and Worksheets
1.3 Task Pane
1.4 The Menu Bar
1.5 Toolbars
1.6 Navigation and the Mouse Pointer
Questions
2.0 Entering Data
2.1 Data Entry
2.2 Auto-Fill Entry
2.3 Erasing Data
2.4 AutoComplete and Preselections
2.5 Undo and Redo
Questions
3.0 Saving Opening and Closing ~Files
3.1 File Save and Files Save As
3.2 Opening a File
3.3 Closing a File
3.4 Creating a New Workbook
Questions
4.0 Entering Formulas
4.1 Methods of Entering Formulas
4.2 Repeating Formulas in Adjacent Fields
4.3 Formula Operators
4.4 Additional Formulas
Questions
5.0 Basic Excel Functions
5.1 Totals and Averages
5.2 Function Overview
Questions
6.0 Formatting
6.1 Adjusting Columns
6.2 Formatting Toolbar
6.3 Numeric Formatting
Questions
7.0 Changing Worksheet Layout
7.1 Inserting Columns Rows and Cells
7.2 Deleting Columns Rows and Cells
7.3 Moving Cells
7.4 Copying Cells
Questions
8.0 Printing
8.1 Using Print Preview and Page Setup
8.2 Printing Controls
8.3 Using Page Break Preview
8.4 Printing
Questions
9.0 Excel Help System
9.1 Using Excel Online Help
9.2 Using Excel Offline Help
Questions
Post Course Exam
Level 2
Introduction
1.0 Additional Formatting
1.1 Cell Alignment and Orientation
1.2 Borders
1.3 Centering Text Across Columns
1.4 Hiding and Unhiding Columns and Rows
Questions
2.0 Conditional Formatting
2.1 Formatting Based on Values
2.2 Avoiding Overlapping Conditions
2.3 Using a Formula to Control Formatting
Questions
3.0 Specialized Numeric Formatting
3.1 Custom Category
3.2 Special Category
Questions
4.0 Cell References
4.1 Absolute References
4.2 Mixed References
Questions
5.0 Range Names
5.1 Naming and Using Range Names
5.2 Additional Creation Methods
5.3 Passing a List of Range Names
5.4 Deleting Range Names
5.5 Assigning a Name to a Value
Questions
6.0 Formula Auditing Techniques
6.1 Using the Formula Auditing Toolbar
6.2 Tracing Dependent Cells
6.3 Tracing Precedent Cells
Questions
7.0 Cell Protection Techniques
7.1 Unlocking/Locking Selected Cells
7.2 Protecting/Unprotecting a Worksheet
Questions
8.0 Find and Replace
8.1 Matching Entire Cells
8.2 Formulas and Wildcard Characters
8.3 Find and Replace by Format
Questions
9.0 Adjusting Worksheet Views
9.1 Freeze/Unfreeze Panes
9.2 Horizontal and Vertical Split Screens
Questions
10.0 Customizing Toolbars
10.1 Adding and Removing Buttons
10.2 Economizing Buttons
10.3 Creating New Toolbars
Questions
Post Course Exam
Level 3
Introduction
1.0 The IF and VLOOKUP Functions
1.1 IF and Relational Operators
1.2 Using Text in IF Functions
1.3 Logical Operators with IF Function
1.4 Nested IF Functions
1.5 Getting Data with VLOOKUP Function
Questions
2.0 Dates and Time
2.1 Using Dates as Values
2.2 Entering a Series of Dates
2.3 Date/Time Techniques
Questions
3.0 Multi-Sheet Workbooks
3.1 Renaming Sheets and Coloring Tabs
3.2 Inserting and Deleting Sheets
3.3 Moving/Copying and Grouping Sheets
3.4 Formulas Across Multiple Sheets
Questions
4.0 Multiple Workbooks
4.1 Displaying Multiple Workbooks
4.2 Moving Sheets Across Workbooks
4.3 Linking Formulas Across Workbooks
4.4 Locating and Maintaining Links
Questions
5.0 Features and Settings
5.1 Show-Hide Gridlines and Formulas
5.2 Recently Used File List
5.3 Other Settings and Features
Questions
6.0 Overview of Charting
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
Questions
7.0 Overview of Database Features
7.1 Sorting Data
7.2 Creating Subtotals
7.3 Filtering
7.4 Pivot Tables
Questions
Post Course Exam
Level 4
Introduction
1.0 Creating a Chart
1.1 Quick Chart Creation
1.2 Chart Wizard
1.3 Using the Chart Toolbar
1.4 Copying Moving and Reshaping a Chart
1.5 Changing a Chart's Location
Questions
2.0 Formatting a Chart
2.1 Selecting Elements to Format
2.2 Color Backgrounds and Fill Effects
2.3 Controlling Text Size and Position
2.4 Series Order and Column Options
Questions
3.0 Chart Content
3.1 Titles and Data Labels
3.2 Gridlines and Legends
3.3 Scaling Column and Line Charts
3.4 Add and Remove Data From a Chart
3.5 Adding Trendlines
Questions
4.0 Specific Chart Types
4.1 Line Charts
4.2 Column Charts
4.3 Pie Charts
4.4 Combination Charts
Questions
5.0 Printing Charts
5.1 Printing a Chart From a Separate Sheet
5.2 Printing a Chart Located on a Worksheet
Questions
6.0 Annotating Charts & Worksheets
6.1 Adding Text and Arrows
6.2 Inserting Hiding and Editing Comments
6.3 Printing Comments
Questions
7.0 Outlining and Custom Views
7.1 Group and Outlining Capabilities
7.2 Custom Views
Questions
8.0 Drawing Toolbar
8.1 WordArt
8.2 Shapes Lines and Arrows
8.3 Coloring Objects and Adding Text
8.4 Clipart
8.5 Applying 3-D and Shadow Effect
Questions
Post Course Exam
Level 5
Introduction
1.0 Excel Database
1.1 List Attributes and Building Lists
Questions
2.0 Data Form
2.1 Single Record With Formulas
2.2 Adding Records to a Database
2.3 Finding Records
Questions
3.0 Data Validation
3.1 Establishing Data Entry Criteria
3.2 Using Formulas and Lists to Restrict Data
3.3 Using Data Validation on Existing Data
3.4 Data Validation Exclusions
Questions
4.0 Data Sort
4.1 Sorting from the Menu
4.2 Sorting from the Toolbar
4.3 Multiple-Key Sorting
4.4 Sorting with Custom Lists
4.5 Sorting Columns
Questions
5.0 Data Subtotals
5.1 Single Level Subtotals
5.2 Multiple Level Subtotals
Questions
6.0 Data Filter
6.1 Criteria
6.2 Multiple Column
6.3 Creating Custom Filters
6.4 Top-ten
6.5 Formatting Data
6.6 Using SUBTOTAL function
6.7 Advanced Filter
Questions
7.0 Data Functions
7.1 SUMIF COUNTIF
7.2 Array Formulas
7.3 Database Functions
Questions
Post Course Exam
Level 6
Introduction
1.0 Templates
1.1 Saving a Skeleton Workbook
1.2 Creating a New Workbook
1.3 Editing a Template
Questions
2.0 Protection
2.1 Workbook Protection
2.2 File Password
2.3 Macro Security
Questions
3.0 Sharing Workbooks
3.1 Establishing Sharing
3.2 Tracking Changes
3.3 Merging Workbooks
Questions
4.0 Exporting Data From Excel
4.1 Exporting to Access
4.2 Exporting to Word
4.3 Saving as a Text File
4.4 Saving in a New Folder
Questions
5.0 Importing Data to Excel
5.1 Using the File Open Command
5.2 Importing or Copying External Data
5.3 Hyperlinks
5.4 Tools Research
Questions
6.0 Excel and the Web
6.1 Importing Web Data
6.2 Saving Excel Data as a Webpage
Questions
7.0 Customizing Excel Environment
7.1 Creating a New Menu
7.2 Creating a Macro
7.3 Running a Macro
7.4 Editing a Macro
Questions
Post Course Exam
Level 7
Introduction
1.0 Functions
1.1 Statistical Functions
1.2 Date and Time Functions
1.3 Financial Functions
1.4 Mathematical Functions
Questions
2.0 Formula Troubleshooting
2.1 Formula Watch Window
2.2 Evaluate Formula Feature
Questions
3.0 Data Analysis Tools
3.1 Goal Seek
3.2 Solver
3.3 Scenarios
3.4 Data Table
Questions
4.0 Consolidating Data
4.1 Consolidate By Position
4.2 Consolidate By Category
Questions
5.0 Managing a List
5.1 Creating a List
5.2 Adding Data to a List
5.3 Adding Totals
Questions
6.0 File Properties
6.1 File Properties
Questions
7.0 Workbook/Worksheet
7.1 Worksheet Styles
7.2 Autoformatting
7.3 Showing Multiple Worksheets
7.4 Comparing Workbooks
Questions
Post Course Exam
Level 8
Introduction
1.0 Navigation Shortcuts
1.1 Navigating Around a Worksheet
1.2 Navigating to the End of Columns
1.3 Workbook/Worksheet Navigation
1.4 Navigating and Zooming with the Mouse
2.0 Selection Shortcuts
2.1 Selecting Ranges
2.2 Selecting Visible- Blank or Text Cells
3.0 Data Entry Shortcuts
3.1 Date and Time
3.2 Move On Enter
3.3 Multiple Cell Entries
3.4 AutoComplete with Keyboard or Mouse
3.5 Multi-line and Comment Entries
3.6 Editing Shortcuts
4.0 Operational Shortcuts
4.1 Undoing and Repeating
4.2 File and Menu Shortcuts
4.3 Columns and Rows
4.4 Re-wrapping Text Entries
4.5 Split screen Shortcuts
4.6 Toolbar Adjustments
5.0 Formula and Function Tips
5.1 Basic Formula Tips
5.2 Locating and Displaying Formulas
5.3 Dependent and Precedent Cells
5.4 Formula Conversion and Evaluation
5.5 Auto-Sum Variations
5.6 TRIM and SUBTOTAL
6.0 Numerical Formatting
6.1 Numerical Keyboard Shortcuts
6.2 Handling Large Numbers
7.0 Data Expansion
7.1 Numerical Series
7.2 Date and Time Series
7.3 Rapid Copy
8.0 Drag and Drop
8.1 Moving and Copying Cells
8.2 Inserting Copying and Moving
8.3 Graphical Shortcuts
8.4 Repeating and Duplicating Objects
8.5 Linked and Unlinked Pictures
8.6 Chart Creation and Movement Tips
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.