Excel Level 3


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.


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.


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)


Show the next months in

Location Dates Price exc. VAT   Status
Please call us for the next available date for this course. Dates are added regularly and may not appear on this list. Tel: 020 7256 6668