| 
Microsoft Excel Introduction Course Overview
- Understand the origins of and basic uses for spreadsheets
- Start Microsoft Excel, navigate workbooks and exit correctly
- Create, modify, save and close a simple workbook
- Select ranges of cells in a workbook
- Create formulas that perform calculations in a workbook
- Copy and fill data in a workbook
- Create and work with functions in a workbook
- Print data in a workbook
- Create a variety of charts (graphs) in Excel
- Get help in using Excel 2003
Specific Topics: Microsoft Excel Introduction Course
Excel 2003 Orientation
- Starting Microsoft Excel 2003
- The Excel 2003 Screen
- Understanding The Workbook
- Moving The Cell Pointer
- Moving About The Workbook
- Using Go To
- Menus and Toolbars
- Using Menus and Toolbars
- Using Context Sensitive
- Menus
- Exiting Excel
A Simple Workbook
- Creating a New Workbook
- Entering Data in a Workbook
- Saving a New Workbook
- Opening a Saved Workbook
- Creating an Input Range
- Saving Your Work
- Essential Formatting
- Column Best Fit
- Closing a Workbook
Selecting Ranges
- Selecting Contiguous Ranges
- Selecting Non-Contiguous Ranges
- Using Special Selection Techniques
- Selecting Larger Ranges
- Range Calculations
Formulas
- Understanding Formulas
- Formulas That Add
- The Sum Function
- Formulas That Subtract
- Formulas That Multiply and Divide
- Referential Formulas
- What If Formulas
- More Complex Formulas
- Formula Error Checking
- Common Error Messages
Copying and Filling
- Understanding Copying In Excel
- Using Fill for Quick Copying
- Copying From One Cell to Another
- Copying From One Cell to Multiple Cells
- Copying From Many Cells to Many Cells
- Copying Relative Formulas
- Copying to a Non-Contiguous Range
|
Working With Functions
- Functions
- Typing a Sum Function
- Summing Non-Contiguous Ranges
- Calculating an Average
- The Maximum Function
- The Minimum Function
Printing
- Print Preview
- Simple Printing
- Previewing Large Worksheets
- Page Orientation
- Scaling To Fit
- Printing to Multiple Pages
- Creating Page Headers and Footers
- Formatting Headers and Footers
- Printing Formulas
Charting
- Using the Chart Wizard
- Choosing the Chart Type
- Changing the Chart Type
- Modifying a Chart
- Printing a Chart
- Creating a Pie Chart
- Creating a Bar Chart
- Moving a Chart
- Deleting a Chart
Getting Help
- General Computer Usage
- The Help Task Pane
- Searching For General Help
- Searching For Specific Help
- Understanding a Help Window
- Disabling Online Content
- Enabling Online Content
- Displaying and Using the Office Assistant
- Customising the Office Assistant
- Disabling the Office Assistant
- Screen Tips and Dialog Box Help
- Setting up An Ergonomic Workstation
- Breaks and Exercises
|
|
 |
|