Monday, January 26, 2009

2. Getting to Know Excel 2007

We began our unit on MS Excel with Project 1 from our textbook, MS Excel 2007, Comprehensive Concepts and Techniques.

Looking at the screen layout and tools of the program gave us a good idea of how different this version of the program is, and the variety of tools this program has to offer.

We observed and used:
  1. the Office Button (the old file menu)
  2. the Quick Access Toolbar
  3. Tabs and Ribbons
  4. the new default font, Calibri, size, 11
  5. AutoSum, the Fill Handle, new Formatting Themes and Styles, Merge & Center, Number Formats
  6. Adding and moving an embedded Chart
  7. Live Preview of Styles
  8. Document Properties
  9. Print Preview and Setup
  10. the Autocalculation Tool in the status bar

We were able to create a professional looking Worksheet with an embedded Chart within a short time, and to exercise control over some essential Excel internal tools.

Materials Covered: From MS Excel 2007 - Project 1:
Creating a Workbook and an Embedded Chart. pp 2-69