Public Courses

We can arrange Microsoft Desktop & Technical training at  a range of public centres across London including Tabernacle Street, Middlesex Street and the the International House centre.

As agents for the biggest training providers in the Country, we are able to secure substantial discounts for you on Microsoft public course rates.

Excel Training Courses Overview

Microsoft Excel Level 1

Lesson 1: Getting Started with Excel

  • Topic 1A: Identify the Elements of the Excel Interface
  • Topic 1B: Navigate and Select Cells in Worksheets
  • Topic 1C: Customize the Excel Interface
  • Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  • Topic 2A: Create Formulas in a Worksheet
  • Topic 2B: Insert Functions in a Worksheet
  • Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Topic 3A: Edit Worksheet Data
  • Topic 3B: Find and Replace Data
  • Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  • Topic 4A: Apply Font Properties
  • Topic 4B: Add Borders and Colors to Cells
  • Topic 4C: Align Content in a Cell
  • Topic 4D: Apply Number Formatting
  • Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  • Topic 5A: Manage Worksheets
  • Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

  • Topic 6A: Define the Page Layout
  • Topic 6B: Print a Workbook

Microsoft Excel Level 2

Lesson 1 – Calculating Data with Advanced Formulas

  • 1A: Apply Cell and Range Names
  • 1B: Calculate Data Across Worksheets
  • 1C: Use Specialized Functions
  • 1D: Analyze Data with Logical and Lookup (vLookup) Function

Lesson 2: Organizing Worksheet and Table Data

  • 2A: Create and Modify Tables
  • 2B: Format Tables
  • 2C: Sort or Filter Data
  • 2D: Use Functions to Calculate Data

Lesson 4: Analyzing Data Using PivotTables, Slicers and PivotCharts

  • 4A: Create a PivotTable Report
  • 4B: Filter Data Using Slicers
  • 4C: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

  • 5A: Insert and Modify Pictures and Cliprt
  • 5B: Draw and Modify Shapes
  • 5C: Illustrate Workflow Using SmartArt Graphics
  • 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

  • 6A: Customize the Excel Environment
  • 6B: Customize Workbooks
  • 6C: Manage Themes
  • 6D: Create and Use Templates

Microsoft Excel Level 3

Lesson 1: Streamlining Workflow

  • Topic 1A: Update Workbook Properties
  • Topic 1B: Create a Macro
  • Topic 1C: Edit a Macro
  • Topic 1D: Apply Conditional Formatting
  • Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

  • Topic 2A: Protect Files
  • Topic 2B: Share a Workbook
  • Topic 2C: Set Revision Tracking
  • Topic 2D: Review Tracked Revisions
  • Topic 2E: Merge Workbooks
  • Topic 2F: Administer Digital Signatures
  • Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

  • Topic 3A: Trace Cells
  • Topic 3B: Troubleshoot Invalid Data and Formula Errors
  • Topic 3C: Watch and Evaluate Formulas
  • Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data

  • Topic 4A: Create a Trendline
  • Topic 4B: Create Sparklines
  • Topic 4C: Create Scenarios
  • Topic 4D: Perform a What-If Analysis
  • Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

  • Topic 5A: Create a Workspace
  • Topic 5B: Consolidate Data
  • Topic 5C: Link Cells in Different Workbooks
  • Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

  • Topic 6A: Export Excel Data
  • Topic 6B: Import a Delimited Text File

Lesson 7: Integrating Excel Data with the Web

  • Topic 7A: Publish a Worksheet to the Web
  • Topic 7B: Import Data from the Web
  • Topic 7C: Create a Web Query