Locked lesson.

## About this lesson

Utilize basic mathematics including multiplication and division in Excel.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Basic Math.xlsx20.3 KB Basic Math - Completed.xlsx

20.4 KB

## Quick reference

### Basic Math

Basic Math in Excel.

### When to use

Working with basic mathematics in Excel.

### Instructions

#### Excel’s Mathematical symbols

Addition | + |

Subtraction: | - |

Multiplication: | * |

Division: | / |

Exponents/Powers: | ^ |

#### Formula Basics

- To write a formula in Excel you must start with the = character
- A basic multiplication formula might be =8*10

#### Using Ranges

- Instead of using numbers in our formulas, we can link to cell addresses

#### Basic formula examples

Multiply A5 by B5: | =A5*B5 |

Add A5 and B5: | =A5+B5 |

Divide A5 by B5: | =A5/B5 |

#### AutoSum

- A feature to write formulas using basic Excel functions for you
- To SUM a column:
- Select the cell immediately below the last row of data
- Go to the Home tab » Editing group » AutoSum
- The formula will automatically show up in the cell
- Press Enter

- To AVERAGE a column:
- Select the cell immediately below the last row of data
- Go to the Home tab » Editing group » click the down arrow just to the right of the AutoSum button
- Choose Average
- The formula will automatically show up in the cell
- Press Enter

Lesson notes are only available for subscribers.