Excel PowerUser Level
Upon successful completion of this course, students will be able to:
- work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query.
- collaborate with other Excel users by protecting your workbook, sharing your workbook, setting revision tracking, merging multiple copies of the same workbook, and tracking changes.
- chart non-adjacent data, modify chart items, and create a trendline.
- use multiple graphic objects to enhance your worksheet.
|
|
||||||||||
- Excel Expert Level
Next Course(s):
- Access VBA Programming
This course is included in the following Certification Program:
- Microsoft Office Specialist
Our Program is All-Inclusive:
- 8 hours of classroom instruction
- Unlimited supervised computer lab/practice time for 6 months
- A complete instruction manual
- Certificate upon completion
- Career Enhancement Services
- Full Placement Counseling
- Free Resume Review
- Job Placement Assistance
- Free Test Preparation
- Computer-Based Training Files
- Assessment Testing
- Internship Opportunities
- Guarantee: Retake the course for free until test passed and/or employed.
- Check the schedule
Topics:
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
