Microsoft Excel 2002 Advanced
Short course
Inhouse
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.
Reviews
Course programme
- 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