MS Excel Level III, CMP959
Learn advanced features of MS Excel 2007 -- how to create and edit macros and apply conditional formatting to streamline workflow. Modify workbook and file properties and use Excel’s web publisher and XML exchange features. Master complex decision-making functions with a click of the mouse. Work with multiple workbooks and files to consolidate data.
Prerequisites: MS Excel--Levels I and II or equivalent experience.
Textbook: Purchase at the Rockville Campus Bookstore, bring textbook to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Classroom Hours: 10
-
Course Objectives:
- Increase productivity and improve efficiency by streamlining your workflow
- Collaborate with others using workbooks
- Audit worksheets
- Analyze data
- Work with multiple workbooks
- Import and export data
- Use Excel with the web
- Structure workbooks with XML
Course Content
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 ToolPack
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 and Exporting Data
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Lesson 8: Structuring XML Workbooks
- Develop XML Maps
- Import and Export XML Data