NewEra Technology Facebook
Excel 2007 - Level 1 - Virtual Live - Course Information
PRINT
SEND TO A FRIEND
Name: Excel 2007 - Level 1 - Virtual Live
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 300
Description:
TARGET AUDIENCE
This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
Prerequisites:
Windows XP (New Version) - Level 1
Outline:
1 - 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

2 - PERFORMING CALCULATIONS

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

3 - MODIFYING A WORKSHEET

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

4 - 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

5 - PRINTING WORKBOOK CONTENTS

Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks

6 - MANAGING LARGE WORKBOOKS

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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Guaranteed to run courses