|
|
|
|
ONLINE- Excel 2003 Training Series- 26 hrs
SKU
EXCEL-2003-TRAINING-SERIES
Summary
The Excel 2003 series provides an introduction to Microsoft Excel 2003 including the skills to create and edit your own spreadsheets. The training is based on the popular Excel for Dummies books.
Audience
The Excel 2003 tutorial is for anyone wanting to learn about Excel or requiring a refresher Excel course
Excel 2003: Getting Started- 3 hrs
- What is Excel
- Cells and worksheets
- Toolbars
- The formula bar and worksheet window
- The status bar and task panes
- Moving within a worksheet
- Using menu items, shortcut menus and dialog boxes
Excel 2003: Creating a spreadsheet- 4 hrs
- Data entry
- Dates and Formula (simple and complex)
- Using autofill
- Symbols, shortcuts and functions (including the likes of Autosum)
- Saving your work
Excel 2003: Formatting Data- 3 hrs
- Autoformatting cells
- Moving toolbars
- Using the Format Cells assistant
- Special numbers and dates
- Re sizing columns and rows
- The format painter and patterns
Excel 2003: Editing and Printing Worksheets- 5 hrs
- Opening workbooks
- Redo and Undo
- Coping, Cutting and Pasting Formulas and cells
- Inserting and deleting cells
- Previewing your printing and setting up the page
- Establishing headers and footers
- Setting your sheet options
- Controlling page breaks and formulas
Excel 2003: Managing Worksheets- 4hrs
- Heading and comments
- Assigning names to cells/ cell ranges
- Find and replace
- Protecting your spreadsheet
- Working with multiple worksheets
- Moving worksheet windows
- Comparing / copying worksheets
Excel 2003: Charts and Databases- 4 hrs
- Chart wizard assistance
- Editing charts and chart options
- Adding WordArt, organizational charts and images
- Creating databases with email and web addresses
- Finding and sorting records
- Using the Data AutoFilter
Excel 2003: Hyperlinks and Tips- 3 hrs
- Using hyperlinks in your spreadsheets
- Working with web pages
- Sending and saving worksheets
- Ten top Excel 2003 features
- Ten top beginner basics for Excel 2003
- Excel 2003 commandments
|
|
|