MS Excel Level III, CMP959
Learn advanced features of MS Excel 2007. 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: Working with Windows XP or Working with Vista, 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