| |
|
| |
Microsoft Office Excel 2003: Level 3 Training Class
Course ID: 14823
|
|
| |
|
|
| |
|
|
| |
Microsoft Office Excel 2003: Level 3 Training Seminar
The previous two course of this three-course series have taught you how to perform tasks such as performing calculations and sorting and filtering data. In this course, we will show you how to automate some common Excel tasks with macros, audit worksheet data, apply advanced analysis techniques to more complex data sets (including what-if analysis, PivotTables, and PivotCharts), collaborate on worksheets with others, share Excel data with other applications, import and export data, and structure XML workbooks.
This course is one of a series of courses aimed at helping you master the Microsoft Office Specialist (MOS) skill sets. MOS certification is a globally recognized standard for demonstrating expertise in specific Microsoft products. Certification candidates must pass one or more product proficiency examinations to earn Office Specialist certification.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Streamlining Workflow
- Topic 1A: Create a Macro
- Topic 1B: Edit a Macro
- Topic 1C: Customize Access to Excel Commands
- Topic 1D: Apply Conditional Formatting
- Topic 1E: Add Data Validation Criteria
- Topic 1F: Update a Workbook's Properties
- Topic 1G: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
- Topic 2A: Protect Files
- Topic 2B: Share a Workbook
- Topic 2C: Set Revision Tracking
- Topic 2D: Review Tracked Revisions
- Topic 2E: Merge Workbooks
- Topic 2F: Adjust Macro Settings
- Topic 2G: Administer Digital Signatures
Lesson 3: Auditing Worksheets
- Topic 3A: Trace Cell Precedents
- Topic 3B: Trace Cell Dependents
- Topic 3C: Locate Errors in Formulas
- Topic 3D: Locate Invalid Data and Formulas
- Topic 3E: Watch and Evaluate Formulas
- Topic 3F: Group and Outline Data
Lesson 4: Analyzing Data
- Topic 4A: Create a Trendline
- Topic 4B: Create Scenarios
- Topic 4C: Perform What-If Analysis
- Topic 4D: Develop a PivotTable?? Report
- Topic 4E: Develop a PivotChart?? Report
- Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
- Topic 5A: Create a Workspace
- Topic 5B: Consolidate Data
- Topic 5C: Link Cells in Different Workbooks
- Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
- Topic 6A: Export to Microsoft Word
- Topic 6B: Import a Word Table
- Topic 6C: Import Text Files
Lesson 7: Structuring XML Workbooks
- Topic 7A: Develop XML Maps
- Topic 7B: Import, Add, and Export XML Data
- Topic 7C: Manage XML Workbooks
- Topic 7D: Apply XML View Options |
|
| |
|
|
|
| |
|
|
| |
Audience |
|
| |
Those with intermediate level of skill in Excel 2003 who wish to study its more advanced features or who wish to prepare for the Microsoft Office Specialist examination in Excel 2003 or Module 2, Key Applications of the Internet and Computing Core Certification (IC3) examination.
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
- Microsoft Office Excel 2003: Level 1 (M-EXCEL03L1, 1 day)
- Microsoft Office Excel 2003: Level 2 (M-EXCEL03L2, 1 day)
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Microsoft Office Excel 2003: Level 3 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 14823
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|