FORGOT YOUR DETAILS?

Excel Advanced Formulas and Functions

Live Online Learning (1 Hour)

This Live Online training session will strengthen your understanding of creating and using Excel advanced formulas and functions.

Your expert trainer will carefully guide you through the nature and structure of functions and how to accurately reference data; as well as become able to differentiate between absolute and relative references, understand the order of operations, and create functions using the Insert Function command.

This Excel Advanced Formulas and Functions training session is suitable for users of Excel 2013 and 2016.

What will I learn?

How to create Excel advanced formulas - Develop a solid understanding of how to order operations when constructing formulas.

How to use relative cell references - Discover the advantages and disadvantages of using a relative cell reference.

How to use absolute cell references - Learn the differences between relative and absolute references, when to use them, and how to create a mixed cell reference.

How to use advanced Excel functions - Become confident to create useful functions, and build functions using Insert Function command.

Requirements

You should have a good understanding of Excel 2013 or 2016, and of creating and editing workbooks. Attending the Learn Excel Formulas and Functions for Beginners session first would be beneficial (or have a good understanding of creating a simple function and formula in Excel).

What Are Live-Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.

Cost:

£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e: [email protected]

Course Content

  • How to order operations when constructing formulas
  • What are relative cell references
  • What are the advantages and disadvantages of using a relative cell reference
  • How to differentiate between relative and absolute references
  • How to create a mixed cell reference
  • How to create functions
  • How to use the Insert Function command
TOP