Duration

1 day

Aim

The skills and knowledge acquired in Microsoft Excel 2007, Level One are sufficient to be able to use and operate the software at an efficient level.

Target Audience

Microsoft Excel 2007, Level One is designed for users who are keen to extend their understanding and knowledge of the software.

Prerequisites

Microsoft Excel 2007, Level One assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Content

Excel 2007 Orientation A Simple Workbook Working With Workbooks Working With Worksheets Viewing Worksheets Adjusting A Worksheet Formulas Working With Functions Selecting Ranges Formatting Cells Copying And Filling Sorting AutoFilter Printing Simple Data Entry

Course Objectives

At the completion of Microsoft Excel 2007, Level One you should be able to:

• start Microsoft Excel, navigate workbooks, and exit correctly • create, modify, save, and close a simple workbook • work with one or more workbooks at once • use a range of techniques to work with worksheets • use a variety of viewing techniques to view worksheets • adjust the sizing of columns and rows in a workbook • create formulas that perform calculations in a workbook • create and work with functions in a workbook • select ranges of cells in a workbook • format cells in a workbook • copy and fill data in a workbook • sort data in lists in a workbook • use autofilter to display data in lists selectively • print data in a workbook • enter a range of data types and formulas

Course Outline