Duration: 8 Hours
Overview:
In this course, students will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. Who Should Attend:
This course was designed for students who have experience using Excel to create, edit, and manage worksheets, and want to further their skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. At Course Completion:
Upon successful completion of this course, students will be able to: - enhance productivity and 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. Prerequisite(s) or equivalent knowledge:
Excel 2010 - Level 1 (First Look)
Excel 2010 - Level 2 Prerequisite Comments:
Students enrolling in this class should have experience working in Excel, creating, editing, and managing workbooks.
Outline: Lesson 1: Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties 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 Sparklines
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
|
