Introduction to Microsoft Excel 2007 Training (1 day)

Introduction to Microsoft Excel 2007 Training Course Overview

This Microsoft Excel training course is designed for students new to working with Microsoft Excel 2007. Students will learn to use Excel to create, modify and format Excel worksheets, perform calculations, and print and Excel workbooks.

Introduction to Microsoft Excel 2007 Training Course Goals

• Explore the Microsoft Office Excel 2007 environment and create a basic worksheet.
• Learn to perform calculations.
• Learn to modify a worksheet.
• Learn to format a worksheet.
• Learn to print workbook contents.
• Learn to manage large workbooks.

Introduction to Microsoft Excel 2007 Training Course Outline

1. Creating a Basic Worksheet
   1. Explore the User Interface and the Ribbon
   2. Navigate and Select in Excel
   3. Obtain Help
   4. Enter Data and Save a Workbook
   5. Customize the Quick Access Toolbar
2. Performing Calculations
   1. Create Basic Formulas
   2. Calculate with Functions
   3. Copy Formulas and Functions
3. Modifying a Worksheet
   1. Manipulate Data
   2. Insert and Delete Cells, Columns, and Rows
   3. Search for Data in a Worksheet
   4. Spell Check a Worksheet
4. Formatting a Worksheet
   1. Modify Fonts
   2. Add Borders and Color to Cells
   3. Change Column Width and Row Height
   4. Apply Number Formats
   5. Position Cell Contents
   6. Apply Cell Styles
5. Printing Workbook Contents
   1. Print Workbook Contents Using Default Print Options
   2. Set Print Options
   3. Set Page Breaks
6. Managing Large Workbooks
   1. Format Worksheet Tabs
   2. Manage Worksheets in a Workbook
   3. Manage the View of Large Worksheets

Introduction to Microsoft Excel 2007 Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Introduction to Microsoft Excel 2007 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions