Upon successful completion of this course, students will be able to:

* 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
* Access and use the help system and work safely    with your computer

Unit 1: Spreadsheets

* How Spreadsheets Work
* Spreadsheet Characteristics
* Spreadsheet Functionality
* The Appropriateness of Spreadsheets

Unit 2: Excel Orientation

* Starting Microsoft Excel
* The Excel 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

Unit 3: 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

Unit 4: Selecting Ranges

* Selecting Contiguous Ranges
* Selecting Non-Contiguous Ranges
* Using Special Selection Techniques
* Selecting Larger Ranges
* Range Calculations

Unit 5: 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

Unit 6: 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

Unit 7: Working With Functions

* Functions
* Typing A Sum Function
* Summing Non-Contiguous Ranges
* Calculating An Average
* The Maximum Function
*The Minimum Function

Unit 8: 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

Unit 9: 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

Unit 10: Formatting Cells

* Using The Font Tools
* Using The Alignment Tools
* Using The Number Tools
* The Format Cells Dialog Box
* Formatting Fonts Using The Menu
* Superscript Subscript & Strikethrough
* Changing Horizontal Alignment
* Centering Across A Selection
* Wrapping Text
* Changing Text Orientation
* Changing Vertical Alignment
* Formatting Dates
* Formatting Numbers
* Formatting Currency
* Creating Custom Formats
* Borders And Shading
* Clearing Cell Formats

Unit 11: 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