Microsoft Excel 2002: Level 3 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Microsoft Excel 2002: Level 3  

 Email information about this seminar Microsoft Excel 2002: Level 3 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft Excel 2002: Level 3 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for individuals who have worked with personal computers and used Windows to manage information, run programs, access the Web, and who has a working knowledge of Excel 2002.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

In this course, students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

microsoft+excel+spreadsheet+2002 training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Microsoft Excel 2002: Level 3 seminar

 

 

Training Course Syllabus:


Description
Students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects.

Audience
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.

Objectives
·  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.

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.

Required Prerequisites
 ·  Microsoft Excel 2002: Level 2

Exams
 ·  Excel 2002 Expert : Excel 2002 Expert

Outline
    1. Customizing Your Workbook
      1. Applying Conditional Formatting
      2. Adding Data Validation Criteria
      3. Customizing Menus
      4. Customizing Toolbars
      5. Creating a Macro
      6. Editing a Macro
      7. Grouping and Outlining Structured Data
    2. Working with Multiple Data Sources
      1. Creating a Workspace
      2. Consolidating Data
      3. Linking Cells in Different Workbooks
      4. Editing Links
      5. Exporting Excel Data as XML
      6. Importing XML Data in Excel
      7. Create a Web Query
    3. Collaborating with Others Using Workbooks
      1. Protecting Your Worksheets
      2. Protecting Your Workbook
      3. Sharing Your Workbook
      4. Setting Revision Tracking
      5. Merging Workbooks
      6. Tracking Changes
    4. Enhancing Your Worksheet Using Charts
      1. Charting Non-adjacent Data
      2. Modifying Chart Items
      3. Creating a Trend Line
    5. Using Graphic Objects to Enhance Your Worksheet
      1. Creating Graphic Objects
      2. Resizing, Moving, and Copying Graphic Objects
      3. Changing the Order of Graphic Objects
      4. Grouping Graphic Objects
      5. Formatting Graphic Objects
      6. Inserting Clip Art
      7. Modifying Clip Art

    Seminar Summary:

    In this course, students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects. (see full course description)

    print this agenda print agenda for the Microsoft Excel 2002: Level 3 training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search