|
|
|
ms301-ver12.7-sg
Microsoft Office Excel 2007 - Level 1 (1 day)
Description
This Microsoft Office courseware training guide book will use Microsoft Office Excel 2007 to manage, edit, and print data. During this course, you will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks.
PrerequisitesStudents should be familiar with:
• Using personal computers and have used a mouse and keyboard.
• The Windows environment and be able to use Windows to manage information on your computer.
• Launching and closing programs; navigate to information stored on the computer; and manage files and folders.
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Getting Started • What is Excel 2007? • Three Primary Functions of Excel • Start Microsoft Excel 2007 • The Excel Interface • The Title Bar and Ribbon • The Formula Bar • Scroll Bars and Splitters • The Status Bar • The New Shortcut Menu
Lesson 2: Basic Worksheet Skills • Create a New Workbook • Begin a New Workbook • Understand Cell Addressing • Enter Data • Types of Entries • Select a Range • Adjust Column Widths • Insert and Delete Rows and Columns • Change Row Height • Hide Rows and Columns • Move Around the Worksheet • Save the Workbook • Close a Workbook • Open a Workbook
Lesson 3: Editing a Worksheet • Delete a Range • Use Cut, Copy, and Paste • Use Find and Replace • Use Paste Options • Use the Clipboard Task Pane • Use Undo and Redo
Lesson 4: Creating Formulas • Enter a Simple Formula • Order of Preference • Use Cell Addresses in Formulas • Use AutoSum • Use AutoFill and AutoFill Options • Use Simple Functions • Date Arithmetic • Insert Function • Auto calculate • Relative vs. Absolute Cell Addressing • Use the Range Finder • Use Error Checking • Error Checking Settings
Lesson 5: Formatting the Worksheet • Change Numeric Formats • Use the Format Cells Dialog • Create a Custom Numeric Format • Use Zeros in Formatting • Change Text Formats • Align Data • Work With Styles • Borders and Shading • The Format Painter • Insert Page Breaks • Use Page Break Preview • Themes
Lesson 6: Printing and Page Setup • Use Print Preview • Work with Print Areas • Work with the Print Dialog Box • Change the Page Setup • Page Layout View
Lesson 7: Working with Large Worksheets • Use Zoom Features • Split the Window • Freeze and Unfreeze Panes • Change the Display Screen
Lesson 8: Using Protection and Comment Boxes • Work with Cell Comments • Lock and Unlock Cell Ranges on a Worksheet
|
|
|
|
| Students interested in this course book have also been interested in the following virtual digital books (vBooks). |
|
 |
|
|
|
|
|
|
