Microsoft Excel 2007 Level 1

Microsoft Excel 2007 Level 1

Course ID: S171
Duration: 1 day

Prerequisites

Windows 2000, Windows XP, or Windows Vista

Course Objectives

After completing the course, participants will be able to:

Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets
Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet
Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box
Format worksheets and use view features to more effectively review large worksheets
Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks

Course Content

Getting Started with Excel 2007
Understanding Spreadsheet Concepts ; Getting Started ; Creating and Saving Workbooks ; Opening and Closing Workbooks

Modifying Worksheets
Working with Columns and Rows ; Working with Cell Contents

Using Formulas and Functions
Creating and Using Formulas ; Creating and Using Functions ; Using Absolute Cell References ; Inserting Functions

Formatting and Viewing Worksheets
Formatting Worksheets ; Viewing Worksheets

Printing Workbooks
Using Workbook Views ; Changing the Page Setup ; Previewing and Printing Workbooks

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver