Excel - Basic math Tutorial

In this video, you will learn about basic math in Excel.
The video covers how to perform calculations using operators like plus, minus, asterisk, and forward slash, as well as functions like SUM.
You can add numbers by typing them directly in a formula or by referencing cells that contain numbers.
The formula automatically updates if you change the referenced cells.
The video also demonstrates subtracting, multiplying, and dividing numbers in Excel.
This knowledge will help you perform basic math calculations efficiently in Microsoft 365.

2:28
4003 views

Available in Microsoft365

Objectifs :

Understand how to use Excel as a calculator by applying basic arithmetic operations through formulas and cell references.

Chapitres :

Introduction to Excel as a Calculator
Excel is a powerful tool that can function as a calculator, allowing users to perform various arithmetic operations. This section will guide you through the basic formulas and functions that can be used to manipulate numbers effectively.
Basic Arithmetic Operations
Excel supports several arithmetic operations, including addition, subtraction, multiplication, and division. Each operation uses specific symbols and follows a straightforward formula structure.
Addition in Excel
To add numbers in Excel, you can use the plus sign (+). A formula in Excel always begins with an equal sign (=). For example, if you want to add two numbers, you would type: =A4 + A5. After pressing Enter, the cell will display the result. You can also add multiple numbers by continuing to use the plus sign. Additionally, instead of typing numbers directly, you can reference cells that contain the numbers, making it easier to update calculations.
Automatic Updates
One of the advantages of using cell references in your formulas is that if you change the value in a referenced cell, the formula will automatically update the result. For instance, if A4 is 6 and A5 is 3, changing A4 to a different number will reflect in the result of the formula.
Subtraction in Excel
Subtracting numbers in Excel is similar to addition. To subtract, you use the minus sign (-). For example, to subtract the value in cell A5 from A4, you would enter: =A4 - A5 and press Enter to see the result.
Multiplication in Excel
To multiply numbers, you use the asterisk (*) symbol. For example, to multiply the values in cells A4 and A5, you would type: =A4 * A5 and press Enter. This will display the product of the two numbers.
Division in Excel
Dividing numbers in Excel is done using the forward slash (/) symbol. For instance, to divide the value in cell A4 by the value in cell A5, you would enter: =A4 / A5 and press Enter to see the quotient.
Conclusion
Excel provides a user-friendly interface for performing basic arithmetic operations through formulas. By understanding how to use cell references and arithmetic symbols, users can efficiently calculate and manage numerical data.

FAQ :

How do I create a formula in Excel?

To create a formula in Excel, start by typing an equal sign (=), followed by the numbers or cell references you want to calculate, using operators as needed. For example, =A4 + A5 will add the values in cells A4 and A5.

What is the purpose of the SUM function?

The SUM function in Excel is used to add together a range of numbers quickly. For example, =SUM(A1:A5) will add all the values from cells A1 to A5.

Can I use cell references in my formulas?

Yes, you can use cell references in your formulas. This allows you to create dynamic calculations that update automatically when the values in the referenced cells change.

What are the basic arithmetic operations I can perform in Excel?

In Excel, you can perform basic arithmetic operations such as addition (+), subtraction (-), multiplication (*), and division (/).

What happens if I change a number in a cell that is referenced in a formula?

If you change a number in a cell that is referenced in a formula, the formula will automatically update to reflect the new value.

Quelques cas d'usages :

Budget Tracking

Use Excel formulas to track your monthly budget by adding expenses and income. For example, you can create a formula that sums up all your expenses in one column and subtracts it from your total income in another column to see your net savings.

Sales Reporting

In a sales report, you can use Excel to calculate total sales by adding individual sales figures using the SUM function. This helps in quickly assessing performance over a specific period.

Inventory Management

Utilize Excel formulas to manage inventory levels. For instance, you can subtract sold items from the total inventory using a formula, allowing for real-time tracking of stock levels.

Data Analysis

In data analysis, you can use Excel to perform calculations on large datasets. For example, you can multiply quantities by prices to calculate total revenue for each product.

Financial Forecasting

Excel can be used for financial forecasting by creating formulas that project future revenues based on historical data. This can involve using multiplication and addition to estimate growth rates.

Glossaire :

Formula

A set of instructions in Excel that performs calculations on numbers. It always starts with an equal sign.

Operators

Symbols used in formulas to perform calculations, such as + (plus), - (minus), * (asterisk for multiplication), and / (forward slash for division).

SUM

A function in Excel that adds together a range of numbers.

Cell

A single box in an Excel spreadsheet where data can be entered. Each cell is identified by its column letter and row number (e.g., A4).

Formula Bar

The area in Excel where you can view and edit the contents of the selected cell, including formulas.

Reference

Using the address of a cell in a formula to include its value in calculations.

00:00:04

With a simple formula, Excel can perform calculations on

00:00:07

numbers using operators, such as the plus sign,

00:00:11

and functions such as SUM.

00:00:16

To add numbers, you use the plus sign.

00:00:19

A formula always starts with an equal sign.

00:00:23

If I then type a number, a plus sign, another number

00:00:28

and then press Enter, the cell displays the results.

00:00:33

You can add many numbers this way, not just two.

00:00:38

Instead of typing numbers in a formula, you can reference

00:00:41

cells that contain numbers to make adding a bit easier and more flexible.

00:00:47

A4 is equal to 6, A5 is equal to 3.

00:00:53

I'll create a formula that adds the cells.

00:00:57

As with all formulas, I start again with the equal sign,

00:01:02

click a cell, type a plus sign, then another cell

00:01:07

and press Enter.

00:01:10

And if I change a number in a cell, the results of

00:01:12

the formula automatically updates.

00:01:16

When you double-click a cell, you can see right in the cell if it's a formula

00:01:21

like A6 or a number like A4

00:01:27

or you can click a cell and look up here in the formula bar.

00:01:32

Subtracting is similar to adding except you use the minus sign.

00:01:41

Click a cell, then a minus sign, then another cell

00:01:47

and press Enter.

00:01:50

Multiplying is similar to adding and subtracting, except you use an asterisk.

00:01:55

Don't use an X for multiplying. That won't work.

00:02:02

Click a cell, then an asterisk,

00:02:07

then another cell and press Enter.

00:02:12

Dividing is similar to multiplying, except you use a forward slash.

00:02:20

Click a cell, then a forward slash,

00:02:24

then another cell and press Enter.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2796 Views

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introduct...

ALL COURSES