MICROSOFT EXCEL 2007
LEVEL 3
Duration
- 1 Day
Entry Requirements
- Computer literate
Students should have completed the following courses or possess Equivalent knowledge:
- Microsoft Office Excel 2007: Level 1
- Microsoft Office Excel 2007: Level 2
Outline
Lesson 1: Streamlining Workflow
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Update a Workbook’s Properties
- Modify Excel’s Default Settings
Lesson 2: Collaborating with Others
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Administer Digital Signatures
- Restrict Document Access
Lesson 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson 4: Analyzing Data
- Create a Trendline
- Create Scenarios
- Perform What–If Analysis
- Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson 6:
- Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Lesson 7:
- Using Excel with the Web
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Lesson 8:
- Structuring Workbooks with XML
- Develop XML Maps
- Import and Export XML Data