FORGOT YOUR DETAILS?

Learn Excel Formulas and Functions for Beginners

Live Online Learning (1 Hour)

Get started and learn Excel formulas and functions, in this interactive Live Online training session.

With a few simple steps, you will learn how to turn Excel from a simple spreadsheet tool into a dynamic analytics engine.

Our friendly expert-trainer will walk you through the basics of creating and using simple formulas and functions; helping you to save time and do more with Microsoft’s popular application – especially when working with data-heavy spreadsheets.

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

What will I learn?

How to reference and calculate data - Become confident to efficiently and accurately calculate data, using cell references.

How to create simple formulas - Create and edit a basic Excel formula with sets of data in seconds.

How to use standard operators - Understand the different operators used in Excel formulas such as addition, subtraction, multiplication and division; and know the order of operations.

How to add simple functions - Use simple Excel functions to perform calculations on data.

How to copy and paste formulas and functions - Reuse formulas using copy and paste, and Fill Handle.

Requirements

You should be familiar with using Microsoft Excel at a basic level, and keen to start creating calculations and using functions. If you are new to Excel, taking the How to Create Your First Excel Spreadsheet training first would be beneficial.

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]

learn excel formulas and functions Course Content

  • What are the Excel formula operators
  • How to order Excel operations
  • What are cell references
  • How are cell references made up
  • Learn Excel formulas: create and edit a basic Excel formula to carry out calculations
  • How to add a simple Excel function to perform different calculations on data
  • How to copy and paste to reuse formulas
  • How to use Fill Handle to copy formulas across a range of cells
TOP