Microsoft Excel 2002 Training Course Advanced

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

Course Duration: 1 Day

You may also be interested in:

Microsoft Excel 2003 Training Course - Beginners

To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester