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.
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
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Administer Digital Signatures
Restrict Document Access
Lesson 3: Auditing Worksheets
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Create a Workspace
Link Cells in Different Workbooks
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
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