Course Description
Upon completion of this course, participants will be able to:
- Enhance productivity 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.
Agenda
Lesson 1: Streamlining Workflow
Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
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 Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a 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
Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Audience
This course is designed for individuals who want 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