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. 

Next Microsoft Excel 2007/10 Introduction Open Training Course
25/01/2012
Manchester City Centre Venue
Limited Places-Book Now -
Call 0161 408 0435
Or
Book Online

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