Microsoft Excel 2002  Advanced

Short course

Inhouse

Price on request

Description

  • Type

    Short course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

You already know the basic and some advanced operations in Excel, now you will learn even more.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

You already know the basic and some advanced operations in Excel, now you will learn even more.Microsoft Excel 2002 Training Course (Advanced) Outline
  • Customizing your Workbook
    • Apply Conditional Formatting
    • Add Data Validation Criteria
    • Customize Menus
    • Customize Toolbars
    • Create a Macro
    • Edit a Macro
    • Group and Outline Structured Data
  • Working with Multiple Data Sources
    • Create a Workspace
    • Consolidate Data
    • Link Cells in Different Workbooks
    • Edit Links
    • Export Excel Data as XML
    • Import XML Data into Excel
    • Create a Web Query
  • Collaborating with Others Using Workbooks
    • Protect your Worksheets
    • Protect Your Workbook
    • Share Your Workbook
    • Set Revision Tracking
    • Merge Workbooks
    • Track Changes
  • Enhancing Your Worksheet Using Charts
    • Chart Non-adjacent Data
    • Modify Chart Items
    • Create a Trendline
  • Using Graphic Objects to Enhance your Worksheets
    • Create Graphic Objects
    • Resize, Move, and Copy Graphic Objects
    • Change the Order of Graphic Objects
    • Group Graphic Objects
    • Format Graphic Objects
    • Insert Clip Art
    • Modify Clip Art

Microsoft Excel 2002  Advanced

Price on request