IT

Advanced Excel

  • IT
  • Location / Campus, Face-to-Face (non-campus), Work-Based
  • Daytime / Working Hours

Overview

This one-day course is aimed at users who require advanced skills in Excel.  The training day will provide you with the knowledge and skills necessary to make best use of Excel to create, edit, format, print and manipulate advanced spreadsheets.

You will work through a series of on-line exercises and will work at your own pace and be able to take away a learning guide to refer to once the training day is over.  

It contains exercises covering the following topics:

  • Advanced functions
  • Input data tables
  • Data analysis tools
  • Manipulating charts
  • Objects
  • Outlines
  • Drawing tools
  • Macros
  • Data consolidation
  • Lookup tables
  • Auditing
  • Importing data
  • Forms
  • Sharing workbooks
  • Styles
  • Hyperlinking
  • Creating web pages

 

What you'll learn / gain skills in

The training day will provide you with the knowledge and skills necessary to make best use of Excel to create, edit, format, print and manipulate advanced spreadsheets.

Entry Requirements

There are no formal entry requirements however participants should be used to using Excel and ready to progress onto an advanced course.  

All delegates will complete a short initial assessment for literacy and numeracy. Delegates must also provide eligibility evidence to meet European Social Funding regulations, including:

  • Employment status
  • DOB
  • Residency
  • National Insurance number

The course can be attended by both the employed and unemployed.

Contact Provider

Occasionally we may send further marketing material that we think may be relevant to you. By submitting this enquiry form, you are confirming that you are happy to receive future marketing messages from us. Please tick the form of contact you prefer or none if you do not wish to be contacted further.

Loading...