|
ms302-ver12.7-sg
Microsoft Office Excel 2007 - Level 2 (1 day)
Description
In Microsoft Office Excel 2007 - Level 1, you created, edited, formatted, and printed basic spreadsheets.
You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways.
In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with charts, graphics, and formulas. During this course, you will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Prerequisites• Microsoft Office Excel 2007 - Level 1
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Working With Workbooks • Move Around in a Workbook • Select Several Sheets • Rename Sheets • Insert and Delete Sheets • Delete a Sheet • Move and Copy Sheets • Move a Sheet to Another Workbook • Group Worksheets • Compare Workbooks • Set Automatic Recovery • Add a Watch Window • Create Formulas and Functions Across Worksheets
Lesson 2: Working With Outlines • The Outline Feature • Create the Worksheet Structure • Apply an Outline • Expand/Collapse an Outline • Apply Auto Outline • Clear an Outline • Modify Outline Settings
Lesson 3: Saving Workbooks to the Web and Hyperlinks • Save as a Web Page • Open an HTML File • Insert Hyperlinks • Use a Hyperlink • Remove a Hyperlink
Lesson 4: Using Paste Special • Paste Formats between Worksheets • Paste Values or Formulas • Mathematical Operations • Link Between Workbooks • Transpose Values
Lesson 5: Using Range Names • Assign Range Names • Move to a Named Range • Use Range Names in Formulas • Create Range Names from Headings • Add Range Names to Existing Formulas • Manage Range Names • Use Range Names in 3-D Formulas • Create 3-D Range Names
Lesson 6: Creating Charts • Chart Basics • Chart Components • When to Use Different Chart Types • Insert a Chart • Chart Data Sizing Handles • Switch the Row/Column Data • Move and Size a Chart • Change the Chart Range and Type • Change the Series Type • Add Chart Elements • Select Chart Objects • Work with Text on a Chart • Enhance the Text Box • Work with Arrows • Scale an Axis • Create a Picture Chart • Format the Picture • Print a Chart • Customize 3-D Effects on a Chart
Lesson 7: Drawing an Object • Draw a Rectangle or Oval • Draw a Line or Arrow • Move and Size Objects • Remove or Change the Fill Color • Add Text to an Object • Format Objects • Add a Text Box • Use Shapes • Insert SmartArt
|
|
|
|
