Microsoft Excel 2007 Training Course


(Beginners)
Learn how to manage, edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is.

Training Course Outline

Exploring the Excel Environment

  • Explore the User Interface
  • Explore the Ribbon
  • Obtain Help
  • Customize the Quick Access Toolbar

Working with an Excel Worksheet

  • Navigate in Excel
  • Select and Enter Data
  • Save a Workbook

Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create a Mixed Reference

Formatting a Worksheet

  • Convert Text to Columns
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Align Cell Contents
  • Find and Replace Formats
  • Apply AutoFormat
  • Apply Cell Styles
  • Apply Themes

Developing a Workbook

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets

Printing Workbook Contents

  • Set Print Titles
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Customizing Layout

  • Split a Worksheet
  • Arrange Windows
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide Worksheets
Course Duration: 1 Day

Other courses you may be interested in:

Intermediate Microsoft Excel 2007 Training Course
Advanced Microsoft Excel 2007 Training Course

To see more details as to our East Anglian Training Venues click one of the links below:

Cambridge | Milton Keynes | Norwich | Peterborough | Luton | Ipswich