Unlimited User License
Course Outline - Excel 2003 Training Bundle
Approx. 16 hours of training on 8 CD-ROMs or DVDs,
Level 1 - Beginner
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
Level 2 - Intermediate
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
Level 3 - Advanced
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
Level 4 - Charts and Graphical Features
Creating a Chart
- Quick Chart Creation
- Chart Wizard
- Using the Chart Toolbar
- Copying, Moving and Re-shaping a Chart
- Changing a Chart's Location
Formatting a Chart
- Selecting Elements to Format
- Color Backgrounds and Fill Effects
- Controlling Text Size and Position
- Series Order and Column Options
Chart Content
- Titles and Data Labels
- Gridlines and Legends
- Scaling Column and Line Charts
- Add and Remove Data from a Chart
- Adding Trendlines
Specific Chart Types
- Line Charts
- Column Charts
- Pie Charts
- Combination Charts (Dual Axis)
Printing Charts
- Printing Chart from A separate Sheet
- Printing a Chart Located on a Worksheet
Annotating Charts and Worksheets
- Adding Text and Arrows
- Inserting, Displaying, Hiding and Editing Comments
- Printing Comments
Outlining and Custom Views
- Group and Outlining Capabilities
- Custom Views
Drawing Toolbar
- WordArt
- Shapes, Lines and Arrows
- Coloring Objects and Adding Text
- Clipart
- Applying 3-D and Shadow Effect
Level 5 - Database Features
Excel Databases
- List Attributes and Building Lists
Data Form
- Setting a Single Record with Formulas
- Adding Records to a Database
- Finding Records
Data Validation
- Establishing Data Entry Criteria
- Using Formulas and Lists to Restrict Data
- Using Data Validation on Existing Data
- Data Validation Exclusions
Data Sort
- Sorting from a Menu
- Sorting from the Toolbar
- Multiple-Key Sorting
- Sorting with Custom Lists
- Sorting Columns
Data Subtotals
- Single Level Subtotals
- Multiple Level Subtotals
Data Filter
- Criteria
- Multiple Column
- Creating Custom Filter
- Top Ten
- Copying Formatting and Sorting Data
- Using "SUBTOTAL" Function to Count Results
- Advanced Filter
Data Functions
- "SUMIF", "COUNTIF"
- Array Formulas
- Database Functions
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
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
Workbook/Worksheet
- Worksheet Styles
- Autoformatting
- Showing Multiple Worksheets
- Comparing Workbooks
Level 8 - Tips & Tricks For Excel 2003
Tips, Tricks & Shortcuts
- Navigation Shortcuts
- Selection Shortcuts
- Data Entry Shortcuts
- Operational Shortcuts
- Formula and Functions Tips
- Numeric Formatting
- Data Expansion
- Drag & Drop
- Graphical Shortcuts