Overview:

This course is designed for users who desire to gain the skills necessary to create, edit, format, and print basic Excel 2007 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
• Operators
• Order of operations

Lesson 4: Formatting a Worksheet
• Change font size and type
• Add borders and fill 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

Assessment:

Candidates will undertake consolidation and assessment exercises during the training.