Microsoft Excel 2007

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to move that data to an electronic format. In this course, you will use Microsoft Excel 2007 to manage, edit, and print data in a spreadsheet.

Excel Beginner course outline.

  • Spreadsheet Basics
  • Excel Basics (Screen, Menu)
  • Navigating Within a Worksheet
  • Changing the View
  • Using Help
  • Entering, Editing, Deleting & Undeleting Data
  • Working with Blocks
  • Adjusting Column Widths & Row Height
  • Creating & Filling Formulas
  • Entering Natural Language Formulas
  • Auto Fill
  • Using the Spell Checker
  • Saving, Opening & Printing Workbooks
  • Setting Print Options
  • Copying & Moving (Drag & Drop)
  • The Office Clipboard
  • Formatting (Alignment, Attributes, Borders)
  • Inserting & Deleting Rows/Columns
  • Using Built-In Functions
  • Customizing Cell Formats
  • Cell Styles
  • The Format Painter
  • Working with Charts
  • Absolute Addressing
  • Document Recovery
  • Using & Creating Templates