This course is not currently offered by Global Knowledge. Information here is provided for reference only.

This course considers large or multiple worksheets and how to manage them. IT covers using range names as well as more advanced functions such as financial and date functions, data management, auto filtering, and file management. The course also covers working with charts, objects, shapes, SmartArt, HTML files, and comments.

For this course, training is performed on student's equipment. We provide the software and data files for the training.

What You'll Learn

• Use large worksheets
• Work with multiple worksheets
• Manage worksheets
• Use range names
• Use other functions
• Manage data
• Use Autofilter
• Manage files
• Create charts
• Format charts
• Draw an object
• Use additional effects and objects
• Use shapes and SmartArt
• Use HTML files
• Work with comments

Who Needs to Attend

Business users who have taken Excel 2007 - Level 1 (Course 6604) or have equivalent knowledge

Prerequisites

There are no prerequisites for this course.

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Using Large Worksheets

• Increasing the Magnification
• Decreasing the Magnification
• Changing the Magnification of a Range
• Switching to Full Screen View
• Splitting the Window
• Removing Split Windows
• Freezing the Panes
• Unfreezing the Panes

2. Working with Multiple Worksheets

• Using Multiple Worksheets
• Navigating between Worksheets
• Selecting Worksheets
• Renaming Worksheets
• Selecting Multiple Worksheets
• Coloring Worksheet tabs
• Inserting Worksheets
• Deleting Worksheets
• Printing Selected Worksheets

3. Managing Worksheets

• Copying Worksheets
• Moving Worksheets
• Using Grouped Worksheets
• Moving Data between Worksheets
• Copying Data between Worksheets
• Creating 3-D Formulas
• Using 3-D Ranges in Functions

4. Using Range Names

• Working with Range Names
• Jumping to a Named Range
• Assigning Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Applying Range Names
• Deleting Range Names
• Using Range Names in 3-D Formulas
• Creating 3-D Range Names
• Using 3-D Range Names in Formulas

5. Using Other Functions

• Using Function Arguments
• Using Financial Functions
• Using Logical Functions
• Using Date Functions
• Formatting Dates
• Revising Formulas

6. Managing Data

• Sorting Lists
• Sorting in Ascending/Descending Order
• Finding Data
• Replacing Data
• Finding and Replacing Cell Formats

7. Using AutoFilter

• Enabling AutoFilter
• Using AutoFilter to Filter a List
• Clearing AutoFilter Criteria
• Creating a Custom AutoFilter
• Disabling AutoFilter

8. Managing Files

• Changing Workbook Properties
• Selecting File Views
• Sorting Excel Files
• Using the Document Recovery Pane
• Inspecting a Document
• Marking a Document as Final
• Saving to a PDF Format
• Using the Compatibility Checker
• Convert a File to 2007 Format
• Saving as a Binary format

9. Creating Charts

• Using Charts
• Creating Charts
• Moving and Resizing Charts
• Identifying Chart Elements
• Changing the Chart Type
• Changing the Plot Direction
• Removing/Adding a Legend
• Moving the Legend
• Charting Non-Adjacent Ranges
• Changing the Chart Range
• Changing the Data Source
• Changing the Chart Location
• Printing a Chart

10. Formatting Charts

• Formatting Charts
• Adding Chart Titles
• Formatting Chart Elements
• Changing the Text Orientation
• Adding a Data Table
• Creating an Exploded Pie Chart
• Adjusting the 3-D View
• Deleting a Chart

11. Drawing an Object

• Working with Drawing Objects
• Drawing Enclosed ObjectsDrawing a Line
• Selecting Filled and Unfilled Objects
• Moving an Object
• Adding Text to an Object
• Selecting Text in an Object
• Resizing an Object
• Formatting Lines
• Changing and Removing the Fill Color
• Changing the Font Color
• Deleting an Object

12. Using Additional Effects and Objects

• Adding a 3-D Effect
• Applying a 3-D Setting
• Adding a Shadow
• Drawing a Text Box
• Drawing an Arrow
• Inserting Pictures
• Formatting Graphics

13. Using Shapes and SmartArt

• Working with Shapes
• Drawing a Callout
• Drawing a Basic Shape
• Working with Connectors
• Drawing Flowchart Shapes
• Drawing Block Arrows
• Adding SmartArt
• Working with SmartArt

14. Using HTML Files

• Previewing a Web Page
• Creating a Hyperlink
• Editing a Hyperlink
• Saving a Worksheet as a Web Page
• Using Publishing Options
• Opening an HTML File

15. Working with Comments

• Creating Comments
• Viewing a Comment
• Reviewing Comments
• Printing Comments
• Responding to Discussion Comments