Training Course Outlines:

Course content includes:

Module 1: Streamlining Workflow

• Create a Macro


• Edit a Macro


• Customize Access to Excel Commands


• 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


• Adjust Macro Settings


• Administer Digital Signatures

• Trace Cell Precedents


• Trace Cell Dependents


• Locate Errors in Formulas


• Locate Invalid Data and Formulas


• Watch and Evaluate Formulas


• Group and Outline Data

• Create a Trendline


• Create Scenarios


• Perform What-If Analysis


• Develop a PivotTable© Report


• Develop a PivotChart© Report


• Perform Statistical Analysis with the Analysis ToolPak

• Create a Workspace


• Consolidate Data


• Link Cells in Different Workbooks


• Edit Links

• Export to Microsoft Word


• Import a Word Table


• Import Text Files

• Develop XML Maps


• Import, Add, and Export XML Data


• Manage XML Workbooks


• Apply XML View Options

Training Course Outcomes:

You 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.

Course Accreditations:

Course Prerequisites:

Related Courses:

People Visited:

129 people visited