|
Microsoft Excel Training Levels
 MS Excel 2003 Level 1 (Intro)
Lesson 1: Creating a simple worksheet
- Using worksheets and workbooks
- Navigating a worksheet
- Managing toolbars
- Entering data
- Data types
- Deleting and replacing entries
- Number formats
- Using Autofill
- Zooming
- Selecting Cells
- Save Concepts
Lesson 2: Expanding on the Basics
- Editing entries and replacing entries
- Undo and Redo
- Autocorrect
- Printing worksheet
Lesson 3: Introducing Formulas and Functions
- Working with Formulas and functions
- Using cell references (relative and absolute)
- Revising formulas
Lesson 4: Formatting Cell Contents
- Number formats – Accounting, Currency, Negative numbers
- Indenting entries
- Formatting cells
- Auto Format
- Moving and copying cells, contents, worksheets
Lesson 5: Working with Dates and Text Features and Restructuring Worksheets
- Understanding text
- Rotating text in a cell
- Changing column widths and row height
- Find and replace Data
Lesson 6: Creating an Impact with Charts
- Creating charges
- Modifying charts
- Modifying chart objects
- Formatting Data Series
MS Excel 2003 Level 2 (Intermediate)
Lesson 1: Working with Large Worksheets
- Sorting worksheets
- Freezing header rows and columns
- Header and Footer options
- Page Break preview
Lesson 2: Introducing Templates and Graphics
- Creating workbooks from templates
- Using templates
- Working with graphics
- Drawing objects
- WordArt
- Autoshapes and other shapes
Lesson 3: Working with Multiple-Sheet Workbooks
- Linking cells
- Copying worksheets
- Using named ranges
- Protecting the workbook
- Advanced Printing techniques
Lesson 4: Financial Functions
- Using PMT and FV Functions
Lesson 5: Introducing Databases
- Database concepts
- Sorting the list
- Creating subtotals
Lesson 6: Using Pivot Tables Outlines and grouping
- Pivot Tables and Pivot Charts
- Working with Outlines and Grouping
- Auto Outline
- Manual Groups
MS Excel 2003 Level 3
Lesson 1: Working with Lookup Functions, Custom Templates, and Auditing
- Lookup Functions
- Templates
- Tracing Formulas
- Evaluating formulas
Lesson 2: Macros And VBA
- Macros
- Using Custom Buttons In Worksheets
- The Personal Macro Workbook
- Shortcut Keys
- Customizing Toolbars
- Deleting Macros And Buttons
- Hiding And Unhiding Worksheets And Workbooks
- Visual Basic For Applications
Lesson 3: Advanced Formatting And Analysis Tools
- Validating Data Entry
- Consolidating Worksheet Data
- Natural Language Formulas
- Conditional Formatting
- Data Tables
- Scenario Manager
- The Report Manager
Lesson 4: Tracking The Status Of A Project
- Using 3-D Cell References In Formulas
- Creating A Formula With The If Function
- Using Logical Tests
- Using The If Function
- Filtering A List On A Worksheet
- Using Custom Filters
- Additional Practice With Styles
Lesson 5: Workgroup Collaboration
- Setting Workbook Properties
- Working With File Passwords
- Tracking Changes To Workbooks
- Sharing Workbooks
- Merging Multiple Workbooks
- Creating Workspaces
- Linking Workbooks
|
