Microsoft Excel Intermediate Courses

Course Overview

Duration: 1 Day
Pre-requisites: Delegates should have attended an Excel introduction and been using Excel for a reasonable length of time. Delegates should have prior knowledge of creating spreadsheets and adding formulae and text
Aimed at: Intermediate users of Excel for Windows wishing to gain an increase in productivity.
Objectives: On successful completion of the course delegates will be able to use Excel to produce more advanced linked spreadsheets with conditional formulae.

Course Content:

Lesson 1: Using Worksheets Together

  1. Using copy and paste with multiple worksheets
  2. Creating a summary worksheet

Lesson 2: Named Areas

  1. Creating named areas?
  2. Changing named areas
  3. To delete a named area:
  4. Exercise

Lesson 3: Sorting Data

  1. Concept
  2. Sorting data
  3. Sorting columns
  4. Sorting left to right

Lesson 4: Formatting Series

  1. Formatting series
  2. Customised series

Lesson 5: Pivot Tables

  1. Concept
  2. Creating a pivot table
  3. Exercise

Lesson 6: Advanced Filtering

  1. Using advanced filters
  2. Copy selection to location
  3. Filter by selection
  4. Exercise

Lesson 7: Introduction To Absolute Cell Addresses

  1. Relative addresses
  2. Absolute addresses

Lesson 8: Auto And Conditional Formatting Of Cells

  1. Concept
  2. Formatting a worksheet
  3. Autoformat
  4. Conditional formatting
  5. Exercise

Lesson 9: Conditional Formulae

  1. Concept
  2. “if” statements
  3. Creating “if” statements
  4. Creating a combined “if” and “or” statement
  5. Creating “if” and “and” combination statements
  6. Exercise

Lesson 10: Outlining And Grouping Information

  1. Outlining a worksheet
  2. Setting up outlined groups
  3. Showing or hiding detail data in an outline
  4. Subtotals
  5. Exercise

Lesson 11: Creating Custom Chart Types

  1. Creating a custom chart type
  2. Exercise

Lesson 12: Consolidating Worksheets Together

  1. Consolidating worksheets
  2. Concept
  3. Exercise

Lesson 13: Filling Data Across Worksheets

  1. Concept
  2. Editing data across worksheets
  3. Concept

Lesson 14: Workspaces

  1. Concept
  2. Creating a workspace

Lesson 15: Protecting A Worksheet

  1. Concept
  2. Locking cells on a worksheet
  3. Protecting a worksheet
  4. Limit changes to an entire workbook
  5. Setting a password
  6. Exercise

Further Training:

Excel for Windows Advanced

The above is an outline intended as a guide only; topics may not be covered in this order. Actual course content will be tailored to suit client's needs.

Contact John Cowie on 0141 563 8200 to book your course, or use our enquiry form to send us a message.