Skip to main content

This qualification is aimed at anyone who wishes to expand and develop their skills using spreadsheet software, such as Microsoft Excel, and is broken down into 4 sessions for beginner, intermediate, advanced and specialist dashboard users.

Beginner Session

This session will focus on the following:

  • Concepts of spreadsheets and Excel.
  • How to open, save and print a spreadsheet.
  • Understanding data types.
  • How to add data, calculations and simple charts.

Intermediate Session

This session will focus on the following:

  • Understanding cell addressing.
  • How to control charts.
  • How to use spark lines.
  • How to manipulate lists and tables.
  • How to use conditional formatting, VLOOKUP and more complex functions.

Advanced Session

This session will focus on the following:

  • How to create named ranges.
  • Auditing dynamic data.
  • Manipulating text and dates.
  • How to create pivot tables.
  • How to create macros.

Specialist Dashboard Session

This session is presented in 2 parts, and will focus on the following:

  • Introducing and creating dashboards.
  • Developing the data model.
  • Using analysis and interactivity.

These half-day courses run during either the morning or the afternoon and are delivered at the Cranford Avenue College site, with free parking available on site.

 

Register your interest
Artboard 7Artboard 6emailArtboard 9Artboard 9Artboard 11Artboard 17Artboard 10Artboard 16Artboard 18