Overview:

This course is designed for students who desire to gain the skills necessary to create, edit, format, and print basic Excel worksheets.

Course Outline:

Lesson 1: Getting Started With Excel
   An overview of Excel
   Navigate in Excel
   Select data
   Enter data
   Save a workbook
   Obtain Help

Lesson 2: Modifying a Worksheet
   Move and copy data between cells
   Fill cells with series of data
   Edit cell data
   Insert and delete cells, columns and rows
   Find, replace and go to cell data
   Spell check a worksheet

Lesson 3: Performing Calculations
   Create basic formulas
   Calculate with functions
   Copy formulas and functions
   Create an absolute reference

Lesson 4: Formatting a Worksheet
   Change font size and type
   Add borders and colour to cells
   Change column width and row height
   Merge cells
   Apply number formats
   Create a custom number format
   Align cell contents
   Find and replace formats
   Apply an AutoFormat
   Apply styles

Lesson 5: Developing a Workbook
   Format worksheet tabs
   Reposition worksheets in a workbook
   Insert and delete worksheets
   Copy and paste worksheets
   Copy a workbook

Lesson 6: Printing Workbook Contents
   Set a print title
   Create a Header and a Footer
   Set page margins
   Change page orientation
   Insert and remove page breaks
   Print a range

Lesson 7: Split a Worksheet
   Arrange worksheets
   Freeze and unfreeze rows and columns
   Hide and unhide worksheets