Course Outline

MS Excel 2007

This is a typical 1 day course split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 Bite Size lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.

Getting Started
Lesson not Started  What is the Active Cell
Lesson not Started  Entering Numbers & Text
Lesson not Started  Workbooks & Worksheets
Lesson not Started  Saving Files
Lesson not Started  Creating a New Workbook
Lesson not Started  Selecting Ranges
Lesson not Started  Office Button
Lesson not Started  The Ribbon
Lesson not Started  Live Preview
Lesson not Started  Mini Toolbar
Lesson not Started  Quick Access Toolbar
Lesson not Started  The Status Bar
Lesson not Started  Saving Files to Earlier Versions

Manipulating Rows and Columns
Lesson not Started  Inserting Rows & Columns
Lesson not Started  Deleting Rows & Columns
Lesson not Started  Modifying Rows & Columns

Moving, Copying, Deleting
Lesson not Started  Copy,Cut & Paste
Lesson not Started  Clearing Cell Contents
Lesson not Started  Editing Cell Contents
Lesson not Started  Undo & Redo
Lesson not Started  Fill Handle
Lesson not Started  Find & Replace
Lesson not Started  Transpose Columns and Rows

Formatting
Lesson not Started  Font Size & Type
Lesson not Started  Font Formatting
Lesson not Started  Customising Borders
Lesson not Started  Aligning Data in a Cell
Lesson not Started  Merge & Centre Button
Lesson not Started  Text Orientation
Lesson not Started  Shrink to Fit
Lesson not Started  Text Wrapping
Lesson not Started  Format Painter
Lesson not Started  Formatting Numbers

Formulas
Lesson not Started  Understanding Formulas
Lesson not Started  Creating Formulas
Lesson not Started  Logical Operators
Lesson not Started  Formula Error Messages
Lesson not Started  Absolute & Relative Referencing
Lesson not Started  Order of Calculation

Printing a Worksheet
Lesson not Started  Displaying Gridlines
Lesson not Started  Printing Titles on Every Page
Lesson not Started  Printing Excel Row & Column Headings
Lesson not Started  Spell Checking
Lesson not Started  Previewing a Worksheet
Lesson not Started  Comparing Workbooks Side By Side
Lesson not Started  Zooming the View
Lesson not Started  Printing Options
Lesson not Started  Scaling your Worksheet