Microsoft Excel 2007 Introduction

Course review:

Learn how to manage, edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is.

Microsoft Excel 2007 Training Course (Beginners) Outline -

Exploring the Excel Environment

• Explore the User Interface
• Explore the Ribbon
• Obtain Help
• Customize the Quick Access Toolbar

Working with an Excel Worksheet

• Navigate in Excel
• Select and Enter Data
• Save a Workbook

Modifying a Worksheet

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

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create a Mixed Reference

Formatting a Worksheet

• Convert Text to Columns
• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Align Cell Contents
• Find and Replace Formats
• Apply AutoFormat
• Apply Cell Styles
• Apply Themes

Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets

Printing Workbook Contents

• Set Print Titles
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Set Page Breaks
• Print a Range

Customizing Layout

• Split a Worksheet
• Arrange Windows
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets