After completing this Microsoft Excel 2007 training course you will become familiar with spreadsheet terminology and the Excel interface. You will learn to navigate worksheets and workbooks and how to use the Help system. You will enter and edit text, values, formulas,and save and open workbooks.

You will also move and copy data, learn about absolute and relative references. This course also covers simple functions, basic formatting techniques, and printing. Finally, you will create and format charts, and learn how to handle large workbooks. 

Target audience

Microsoft Excel 2007 Introduction training Course
The target student for this course should be comfortable using a personal computer and Microsoft Windows . You should have little or no experience using Microsoft Excel or any other spreadsheet program. You will get the most out of this course if your goal is to become proficient in using Microsoft Excel to create simple worksheets and charts for internal reports and data tracking.

Course prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed the Windows XP: Basic or Windows Vista: Basic course or have equivalent experience.
 

Course contents

Getting started

 

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Navigating workbooks

 

Entering and editing data

  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks
Modifying a worksheet
  • Moving and copying data
  • Moving and copying formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows, and columns
 

Using functions

  • Entering functions
  • AutoSum
  • Other useful functions
 Formatting worksheets
  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Conditional formatting
  • Copying formats and applying table formats
 Printing
  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts

Managing large workbooks

  • Viewing large worksheets
  • Printing large worksheets
  • Using multiple worksheets