University of Bath

Excel: Formulae and functions (April)

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

16 Apr 201910.00am
to
16 Apr 201911.30am
Free

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