Duration

One Day

Suitable for

This course is for anyone who wants to gain the skills necessary to create a basic macro, collaborate with others, audit and analyse worksheet data and import and export data.

Objectives

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets and share Excel data with other applications.

Programme

Lesson One – Streamlining Workflow

• Update Workbook Properties
• Create and Edit a Basic Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

Lesson Two – Collaborating with other Users

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks

Lesson Three – Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson Four - Analysing Data

• Create a Trendline
• Create Sparklines
• Create Scenarios
• Perform a What-If Analysis
• Create a One and Two Variable Table

Lesson Five – Working with Multiple Workbooks

• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Lesson Six – Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File

Duration (in days)