## About this lesson

Utilize basic mathematics including multiplication and division in Excel.

## Exercise files

Download this lesson’s related exercise files.

Basic Math.xlsx8.4 KB Basic Math - Completed.xlsx

8.9 KB

## Quick reference

### Topic

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.