University of Bath

Excel: Formulae and functions (October)

Learn how to navigate Microsoft Excel and utilitise the various formulae and functions

23 Oct 201810.00am
23 Oct 201811.30am

About the workshop

This course introduces formulae and functions in Excel. Participants should be confident with using the Windows environment and already have some experience of using Microsoft Office. They should have a basic understanding of Microsoft Excel including how to navigate in Excel and use the Ribbon, use Backstage View and Options, select cells, rows, columns and ranges, and format and align text and numbers in cells.

Learning outcomes

After completing this course, you will be able to:

  • create and edit formulae
  • use AutoSum
  • understand relative and absolute referencing
  • use the Formulas tab
  • create Range Names and use them in formulae
  • insert functions in Excel