Training Course Outlines:

Course content includes:

Module 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

• Protect Files


• Share a Workbook


• Set Revision Tracking


• Review Tracked Revisions


• Merge Workbooks


• Administer Digital Signatures


• Restrict Document Access

• Trace Cells


• Troubleshoot Errors in Formulas


• Troubleshoot Invalid Data and Formulas


• Watch and Evaluate Formulas


• Create a Data List Outline

• Create a Trendline


• Create Scenarios


• Perform What-If Analysis


• Perform Statistical Analysis with the Analysis ToolPak

• Create a Workspace


• Consolidate Data


• Link Cells in Different Workbooks


• Edit Links

• Export Excel Data


• Import a Delimited Text File

• Publish a Worksheet to the Web


• Import Data from the Web


• Create a Web Query

• Develop XML Maps


• Import and Export XML Dat

Training Course Outcomes:

Upon successful completion of this course, students will be able to:

• 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 Accreditations:

Course Prerequisites:

Related Courses:

People Visited:

135 people visited