COURSE
OUTLINE
Lesson
1: Customizing your Workbook
Topic 1A: Apply Conditional Formatting
Topic 1B: Add Data Validation Criteria
Topic 1C: Customize Menus
Topic 1D: Customize Toolbars
Topic 1E: Create a Macro
Topic 1F: Edit a Macro
Topic 1G: Group and Outline Structured Data
Lesson 2: Working with Multiple
Data Sources
Topic 2A: Create a Workspace
Topic 2B: Consolidate Data
Topic 2C: Link Cells in Different Workbooks
Topic 2D: Edit Links
Topic 2E: Export Excel Data as XML
Topic 2F: Import XML Data into Excel
Topic 2G: Create a Web Query
Lesson 3: Collaborating with Others
Using Workbooks
Topic 3A: Protect your Worksheets
Topic 3B: Protect Your Workbook
Topic 3C: Share Your Workbook
Topic 3D: Set Revision Tracking
Topic 3E: Merge Workbooks
Topic 3F: Track Changes
Lesson 4: Enhancing Your Worksheet
Using Charts
Topic 4A: Chart Non-adjacent Data
Topic 4B: Modify Chart Items
Topic 4C: Create a Trendline
Lesson 5: Using Graphic Objects
to Enhance your Worksheets
Topic 5A: Create Graphic Objects
Topic 5B: Resize, Move, and Copy Graphic Objects
Topic 5C: Change the Order of Graphic Objects
Topic 5D: Group Graphic Objects
Topic 5E: Format Graphic Objects
Topic 5F: Insert Clip Art
Topic 5G: Modify Clip Art
|
