Excel 2007 Introduction

Anyone with a need to acquire the basic skills to use Excel 2007 for the creation of spreadsheets and data manipulation.
Anyone updating from a previous version of this software.

On completion of this course, delegates will be able to create, modify, format and print Spreadsheets using a number of features, as well as creating basic charts.

A number of commonly used timesaving features are also introduced giving the necessary skills to use the product effectively.

Microsoft Excel 2007 provides delegates with powerful tools for creating professional-looking spreadsheets quickly and easily.

This course is designed for new users who wish to acquire the basic Excel skills needed for the creation of spreadsheets.

Skills Gained
* Explore the Excel 2007 environment.
* Perform Calculations.
* Modify a Worksheet.
* Format a Worksheet.
* Print Workbook Content.
* Manage Large Workbooks.

Course Outline
Creating a Basic Worksheet
Explore the User Interface and the Ribbon. Navigate and Select in Excel. Obtain Help. Enter Data and Save a Workbook. Customize the Quick Access Toolbar.

Performing Calculations
Create Basic Formulas. Calculate with Functions. Copy Formulas and Functions.

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

Formatting a Worksheet
Modify Fonts. Add Borders and Color to Cells. Change Column Width and Row Height. Apply Number Formats. Position Cell Contents. Apply Cell Styles.

Printing Workbook Content
Print Workbook Contents Using Default Print Options. Set Print Options. Set Page Breaks.

Managing Large Workbooks

Format Worksheet Tabs. Manage Worksheets in a Workbook. Manage the View of Large Worksheets