Creating Functions and Formulae in Excel

IT Training

Date:
Wed 19 Feb 2020 - 14:15 to 15:45
Sign up by:
Wed 19 Feb 2020 - 13:45

This self-paced course is an introduction to the basics of creating functions and formulae in Excel – Microsoft’s spreadsheet application.

The real benefit of Excel lies in its ability to perform calculations. Excel processes numbers with formulae that are used to perform calculations. Formulae can perform simple tasks such as adding up a few cells or more complex operations. In addition, Excel also contains several hundred pre-programmed formulae for performing a variety of different types of calculations.

At the end of this trainer-facilitated session 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

 

The tutors for the Wednesday afternoon sessions are highly qualified IT trainers who have been delivering a variety of IT courses and workshops to staff and students at the University for many years.

The trainer for the Thursday evening sessions is a very able trainer with an excellent subject knowledge.