The Basic Excel workbook

Spreadsheet skills have become essential for virtually everyone who works with numbers, and are particularly necessary for anyone responsible for the basic numerical tasks associated with running a business, maintaining an office or keeping the household books. The WARP! Basic Excel course provides your learners with a solid grounding in essential spreadsheet creation and management skills. Courseware for Excel 2010, Excel 2007, Excel 2003, Excel XP 2002, Excel 2000 and Excel 97.

Table of contents: (Basic Excel 2010 courseware)

Chapter What your students will learn

CHAPTER 1 -
Getting Started
  • Starting Excel
  • Title Bar
  • Minimizing, Maximizing, Restoring, Moving and Resizing a Window
  • File Ribbon Tab - Opening a File
  • Status Bar
  • The Ribbon
  • Scrollbars
  • Dialog Boxes

CHAPTER 2 -
Customizing Excel
  • Page Layout
  • Page Break Preview
  • Normal View
  • Show group
  • Customizing the Quick Access Toolbar
  • Excel Options

CHAPTER 3 -
Creating a New Spreadsheet
  • What is a Spreadsheet?
  • Working with Numbers
  • Creating a New Spreadsheet
  • Saving a spreadsheet
  • Undo and Redo last action
  • Editing cell contents and [F2]

CHAPTER 4 -
Formatting Text
  • Adding text
  • AutoFit Column Width
  • Formatting text - Font, Size, Bold and Centering
  • Text Alignment

CHAPTER 5 -
Formatting Numbers
  • Adding and Formatting Currency
  • Calculating a Value using a Multiply Formula
  • Copying and Pasting a Formula
  • Paste Options button
  • The Office Clipboard
  • Paste Special
  • Resizing a column using the mouse
  • Minus Fomula
  • Formatting Values
  • AutoSum
  • Sum Formula
  • Divide Formula
  • Percentages
  • Calculation operators in formulas

CHAPTER 6 -
Columns and Rows
  • Deleting Rows
  • Column Width
  • Row Height

CHAPTER 7 -
Borders and Shading
  • Borders
  • Shading

CHAPTER 8 -
Word Tools
  • Spell Check
  • AutoCorrect
  • Finding text
  • Replacing text
  • Go To

CHAPTER 9 -
Page Formatting
  • Headers and Footers
  • Page Setup

CHAPTER 10 -
Charts and Graphs
  • Creating a Chart
  • Chart Type
  • Chart Title
  • Chart Data Labels
  • Rotating the pie slices
  • Exploding a slice of pie
  • An extra charting exercise

CHAPTER 11 -
Clip Art and WordArt
  • Clip Art
  • Clip Organizer
  • WordArt

CHAPTER 12 -
Printing
  • Print Preview
  • Printing
  • Closing a spreadsheet
  • Exiting Excel

CHAPTER 13 -
AutoFill, AutoFormat and Styles
  • AutoFill
  • Series
  • AutoFormat - Table Styles Gallery
  • Styles - Cells Styles

CHAPTER 14 -
Formulas and Functions
  • Adding Formulas to a spreadsheet
  • Formatting Values
  • Introduction to Logical Functions
  • IF - Logical Function
  • AND - Logical Function
  • Editing a complicated function
  • Worksheet Protection

CHAPTER 15 -
Using Help
  • Starting Help
  • Table of Contents
  • Search Offline Help
  • Search Online Help
  • [F1] Help