Home > Courses Certifications > Microsoft Office > Excel 2007 Level 1 synopsis

Microsoft Excel 2007 - Level 1

Prerequisites: Windows XP (New Version) - Level 1

Duration: 1 day

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 Contents

• 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