Excel - Formulae & Functions

Microsoft Excel

getting started with formulae & functions

Please use the left and right arrows on the edge of each page to move through the presentation

CONTENTS

Formula & Functions Overview

More Complex Formulas

Absolute References

Basic Math in Excel

VLOOKUP

Operator Order in Excel

Get in touch!

Sum Function

Using Functions

FORMULAS & FUNCTIONS

Get started on how to create formulas and use built-in functions to perform calculations and solve problems.

Click on the image to access the Overview of Fomulas & Functions video

CONTENTS

FORMULAS

This video shows you how to add, subtract, multiply, and divide in your workbook.

Click on the image to access the Basic Math in Excel video

CONTENTS

OPERATOR ORDER

How do you know what part of your formula Excel acts on first, second, third, and so on? This video explains it.

Click on the image to access the Operator Order in Excel video

CONTENTS

SUM FUNCTION

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

Click on the image to access the Sum Function video

CONTENTS

USING FUNCTIONS

A function is a predefined formula that helps save you time. For example, use the SUM function to add lots of numbers or cells, and the PRODUCT function to multiply them.

Click on the image to access the Using Functions video

CONTENTS

MORE COMPLEX FORMULAS

Watch this video to learn how to create more complex formulas using multiple operators, cell references, and functions.

Click on the image to access the More Complex Formulas video

CONTENTS

Switch between relative & absolute references

By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row (2). A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 adjust downward by one row and become =A3+B3.

If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference. You can use the F4 key to make a cell reference absolute.

CONTENTS

VLOOKUP

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. Tip: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.

Click on the image to access the VLOOKUP Function video

CONTENTS

THANKS FOR WATCHING

WWW.BLUENOVATION.CO.UK

PLEASE GET IN TOUCH

CONTENTS