Course Objectives
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
Prerequisites
To ensure your success, we recommend that you first take the following courses or have equivalent knowledge:
- Microsoft® Office Excel® 2010: Level 1 (Second Edition)
- Microsoft® Office Excel® 2010: Level 2 (Second Edition)
Target Student
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Certification
This course is one of a series of courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products.
Hardware Requirements
For this course, you will need one computer for each student and the instructor. Each computer should have the following minimum hardware configuration:
- 1 GHz Pentium-class processor or faster.
- A minimum of 1 GB of RAM is recommended.
- 20 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for Office 2010 installation.
- A DVD-ROM drive.
- A keyboard and mouse or other pointing device.
- A 1024 x 768 resolution SVGA monitor is recommended.
- Network cards and cabling for local network access.
- Internet access.
- A printer (optional) or an installed printer driver.
- A projection system to display the instructor’s computer screen
Software Requirements
Each computer requires the following software:
- Microsoft® Office Professional Plus 2010 Edition
- Microsoft® Windows® XP Professional with Service Pack 3
- Windows Rights Management Services (RMS) Client with Service Pack 2.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- proenhanceductivity and efficiency by streamlining the workflow.
- collaborate with other workbook users.
- audit worksheets.
- analyze data.
- work with multiple workbooks.
- import and export data.
- integrate Excel data with the web.
Course duration
1 Day
Course outline
Lesson 1: Streamlining Workflow
Topic1A: Update Workbook Properties
Topic1B: Create a Macro
Topic1C: Edit a Macro
Topic1D: Apply Conditional Formatting
Topic1E: Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
Topic2A: Protect Files
Topic2B: Share a Workbook
Topic2C: Set Revision Tracking
Topic2D: Review Tracked Revisions
Topic2E: Merge Workbooks
Topic2F: Administer Digital Signatures
Topic2G: Restrict Document Access
Lesson 3: Auditing Worksheets
Topic3A: Trace Cells
Topic3B: Troubleshoot Invalid Data and Formula Errors
Topic3C: Watch and Evaluate Formulas
Topic3D: Create a Data List Outline
Lesson 4: Analyzing Data
Topic4A: Create a Trendline
Topic4B: Create Sparklines
Topic4C: Create Scenarios
Topic4D: Perform a What-If Analysis
Topic4E: Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic5A: Create a Workspace
Topic5B: Consolidate Data
Topic5C: Link Cells in Different Workbooks
Topic5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic6A: Export Excel Data
Topic6B: Import a Delimited Text File
Topic6C: Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
Topic7A: Publish a Worksheet to the Web
Topic7B: Import Data from the Web
Topic7C: Create a Web Query
Appendix A: Creating Excel Forms
Appendix B: Microsoft Office Excel 2010
Appendix C: Microsoft Office Excel 2010
|
