Students will customize their
workbooks, work with multiple data sources, collaborate with other users, and
enhance their spreadsheets using charts and graphic objects.
Target Student: The
target student for this course is a user who has worked with personal computers
and used Windows to manage information, run programs, access the Web, and who
has a working knowledge of Excel 2002.
Prerequisites:
Excel 2002: Level 1
Excel 2002: Level 2
Benefits: Learn how
to customize their workbook, work with multiple data sources, collaborate with other Excel users, and use charts and
graphic objects to enhance their worksheets.
Performance-Based
Objectives
Lesson objectives help students become comfortable with the course, and
also provide a means to evaluate learning. Upon successful completion of this
course, students will be able to:
Apply conditional
formatting; add data validation criteria; customize menus and toolbars;
and create, edit, and run macros. The student will also view data using
the outline.
Create a workspace,
consolidate data, view the consolidated data, and link cells.
Protect their worksheet,
protect their workbook, add and remove file passwords, share their
workbooks, set revision tracking, merge workbooks, and track changes.
Chart non-adjacent data,
modify embedded charts and chart items, and add a trend line to their
chart.
Create, change the order of,
group, move, copy, and format graphic objects. They will also insert and
modify clip art.
Course Content
Lesson 1: Customizing Your Workbook
Applying Conditional Formatting
Adding Data Validation Criteria
Customizing Menus
Customizing Toolbars
Creating a Macro
Editing a Macro
Grouping and Outlining Structured
Data
Lesson 2: Working with Multiple Data Sources
Creating a Workspace
Consolidating Data
Linking Cells in Different
Workbooks
Editing Links
Exporting Excel Data as XML
Importing XML Data in Excel
Create a Web Query
Lesson 3: Collaborating with Others Using
Workbooks
Protecting Your Worksheets
Protecting Your Workbook
Sharing Your Workbook
Setting Revision Tracking
Merging Workbooks
Tracking Changes
Lesson 4: Enhancing Your Worksheet Using Charts
Charting Non-adjacent Data
Modifying Chart Items
Creating a Trend Line
Lesson 5: Using Graphic Objects to Enhance Your
Worksheet
