Microsoft Excel 2002 Training Course


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

Training Course 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
Course Duration: 1 Day

To see more details as to our East Anglian Training Venues click one of the links below:

Cambridge | Milton Keynes | Norwich | Peterborough | Luton | Ipswich