Excel 2007 - Level 1 Training Class

Course ID: 13891

Excel 2007 - Level 1 Training Seminar

Overview:
In this course, students create and edit basic Microsoft?? Office Excel?? 2007 worksheets and workbooks.

Who Should Attend:
This course is designed for people preparing for certification as a Microsoft Office 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.

At Course Completion:
Upon successful completion of this course, students will be able to: - explore the Excel 2007 environment. - work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet. - modify a worksheet. - perform calculations. - format a worksheet. - develop a workbook. - print workbook contents. - customize the layout of the Excel application window.

Agenda

Outline:
Lesson 1: Exploring the Excel Environment Explore the User Interface Explore the Ribbon Obtain Help Customize the Quick Access Toolbar
Lesson 2: Working with an Excel Worksheet Navigate in Excel Select and Enter Data Save a Workbook
Lesson 3: Modifying a Worksheet Manipulate Data Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet Spell Check a Worksheet
Lesson 4: Performing Calculations Create Basic Formulas Calculate with Functions Copy Formulas and Functions Create a Mixed Reference
Lesson 5: Formatting Worksheets 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
Lesson 6: Developing a Workbook Format Worksheet Tabs Reposition Worksheets in a Workbook Insert and Delete Worksheets Copy and Paste Worksheets
Lesson 7: Printing Workbook Contents Set a Print Title Create a Header and a Footer Set Page Margins Change Page Orientation Set Page Breaks Print a Range
Lesson 8: Customizing Layout Split a Worksheet Arrange Worksheets Freeze and Unfreeze Rows and Columns Hide and Unhide Worksheets