Before you begin

You should have a good working knowledge of Excel and be able to create and manipulate workbooks. You should also have core knowledge of working with files and folders in the Windows environment. If this is not the case we recommend you first take Excel - Get started with spreadsheets.

Delivery Method: Tutor led
Course Duration: 2 hours

Postgraduates will need to pay £5 to DD&T reception, 4 East South.

What you will learn

Microsoft Excel is a spreadsheet application which you can use to store, manipulate and present data. This course is taught through a mixture of demonstration and hands-on practice. You will learn how to:

  • set macro security
  • save a document as macro enabled
  • record, run, edit, copy and delete macros
  • record a macro with relative cell references
  • record a macro with absolute cell references
  • assign a macro to the toolbar
  • assign a macro to a ribbon
  • place a macro button into a worksheet
  • assign a keyboard shortcut to a macro
  • write a basic VBA macro

Book your place

To book your place:

  • Go to the Employee Self Service booking page
  • Select the date you wish to book
  • Enter any optional personal objectives you wish to achieve
  • Select "Save"

Course dates and times

  • Monday 27 April 2020, 2:15pm to 4:15pm
  • Wednesday 27 May, 2:15pm to 4:15pm

Find a related course

Excel - Use advanced functions
Excel - Use PivotTables to summarise data
Excel - Create charts to present your data
Excel - Manage your data better
Excel - Create formulae and functions