CHAPTER ONE CREATING A MS EXCEL SPREADSHEET.
 Signing on to MS Excel.
 Manipulating a Worksheet.
 Entering data into a Worksheet.
 Saving a Worksheet.
 Formatting a Worksheet (Numbers, Text, Entire Worksheet)
 Practice Exercises

CHAPTER TWO USING an EXCEL WORKSHEET.
 Opening and Creating Worksheets.
 Cells and Ranges.
 Formulas and Functions.
 Editing.
 Using Multiple Worksheets.
 Printing and Previewing your Worksheet.
 Practice Exercises.

CHAPTER THREE MS EXCEL FEATURES and UTILITIES.
 Spell Checker.
 Find and Replace.
 Creating a Series.
 Protecting Data and Hiding Cells / Deleting and Inserting Cells.
 Relative and Absolute Values (apply to formulas).
 Font Size and Colours.
 Adding a Picture or Clipart.
 Practice Exercises.

CHAPTER FOUR BASIC CHARTING.
 Creating a Basic Chart using the Wizard.
 Types of Chart.
 Editing and Updating an Excel Chart.
 Pie Charts.
 Practice Exercises.

CHAPTER FIVE “WHAT IF” SCENARIOS.
 Explain “What If”.
 A “What If” Exercise.
 =IF formulas.
 Headers and Footers.
 Sorting the Order.
 Practice Exercises.

CHAPTER SIX MS EXCEL DATABASE.
 What is a Database?
 Sorting a Database.
 Editing a Database.
 Filtering a Database.
 Subtotals.
 Data Form.
 Advanced Filters.
 Practice Exercises.

CHAPTER SEVEN INTRODUCTION to MS EXCEL MACROS.
 What is a Macro?
 Creating a Macro in the Active Workbook (Recording, Viewing and Executing)
 Creating a New Macro Workbook.
 Practice Exercises.

CHAPTER EIGHT. PRACTICE EXERCISES.
 Exercise One
 Exercise Two
 Exercise Three
 Exercise Four.