Microsoft Excel 2002
Short course
In
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. Suitable for: Someone who has completed Excel 2002 intro and inter
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