Computer Training Course Outline for PC Training Experts
Home About Contact Courses Tutorials Hot ArticlesBlog Forums
Excel 2007 Level 1 (1 day )
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 migrate that data to an electronic format.

Performance-Based Objectives

  • Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbook contents.
  • Manage large workbooks.
Course Outline
Lesson 1: Creating a Basic Worksheet
  • Explore the User Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar
Lesson 4: Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles
Lesson 2: Performing Calculations
  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
Lesson 5: Printing Workbook Contents
  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks
Lesson 3: Modifying a Worksheet
  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet
Lesson 6: Managing Large Workbooks
  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets
Home | About | Contact | Schedule Training | Course Catalog | Blog | Terms of Use | Privacy Statement
Copyright © 2008 Mike Phillips