Excel - Add numbers Tutorial

In this video, you will learn about Microsoft365 and how it can help you and your team be creative and work together securely.
The video covers the Office apps like Word, Excel, and PowerPoint, which allow you to save your files in the cloud with OneDrive.
This means you can access your files from anywhere.
You can store any type of file, including images, spreadsheets, and presentations.
The video also demonstrates how you can share and work in real-time with your coworkers, whether you're in the office or on the go.
Microsoft365 also offers mobile apps for your devices, allowing you to stay organized and connected.
Additionally, you can be productive from any browser with Office for the web.
This tutorial will help you understand how to work and collaborate from anywhere and on any device using Microsoft365. By following these steps, you can enhance your productivity and achieve better results.

2:54
4334 views

Available in Microsoft365

Objectifs :

Learn how to use Excel to add numbers using formulas, reference cells, and utilize the AutoSum feature for efficient calculations.

Chapitres :

Introduction to Adding Numbers in Excel
In this section, we will explore how to add numbers in Excel using various methods. Excel provides powerful tools to perform calculations efficiently, making it easier to manage data.
Using Formulas to Add Numbers
To add numbers in Excel, you start by using a formula. A formula always begins with an equal sign (=). For example, if you want to add the numbers in cells B2 and B3, you would enter the following formula in another cell: - =B2 + B3 After pressing Enter, the cell will display the result of the addition. This method allows you to add multiple numbers, not just two.
Referencing Cells for Easier Calculations
Instead of manually entering numbers, you can reference cells to simplify your calculations. For instance, if B2 contains the number 6 and B3 contains the number 3, you can create a formula that adds these cells together. Simply start with an equal sign, click on the first cell (B2), add a plus sign (+), click on the second cell (B3), and press Enter. If you change the value in either cell, the result will automatically update.
Adding Cells and Numbers
You can also add a cell and a number in your formula. For example: - =B2 + 5 This formula adds the value in cell B2 to the number 5. Again, press Enter to see the result.
Understanding Cell Content
To check if a cell contains a number or a formula, double-click the cell. Alternatively, you can look at the formula bar located at the top of the Excel window.
Using AutoSum for Quick Calculations
The AutoSum feature in Excel simplifies the process of adding adjacent cells in rows and columns. To use AutoSum: 1. Click the cell below a column of adjacent cells or to the right of a row. 2. On the Home tab, click the AutoSum button (Σ). 3. Press Enter to see the sum. The keyboard shortcut for AutoSum is Alt + =. You can also select a group of adjacent cells along with an extra column and row to get the sum for each row and column, as well as a grand total.
Copying Formulas
To copy a cell and its formula, click on the cell, then point to the bottom right corner of the cell until you see a small cross (the fill handle). Hold down the left mouse button and drag it to the right to copy the formula into the new cells.

FAQ :

How do I add numbers in Excel?

You can add numbers in Excel by using formulas that start with an equal sign. For example, to add the values in cells B2 and B3, you would enter '=B2+B3' in another cell.

What is AutoSum in Excel?

AutoSum is a feature in Excel that allows you to quickly calculate the sum of adjacent cells. You can activate it by clicking on the AutoSum button in the Home tab or using the keyboard shortcut 'Alt'.

Can I reference other cells in my formulas?

Yes, you can reference other cells in your formulas. For example, you can create a formula like '=A1+B1' to add the values in cells A1 and B1.

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 result of the formula will automatically update to reflect the new value.

How do I copy a formula to other cells in Excel?

To copy a formula to other cells, click on the cell with the formula, then drag the fill handle (the small square at the bottom right corner of the cell) to the right or down to fill adjacent cells with the same formula.

Quelques cas d'usages :

Budget Tracking

Use Excel to create a budget tracker by adding up expenses in different categories. You can reference cells for each category and use AutoSum to quickly calculate total expenses.

Sales Reporting

In a sales report, you can use formulas to calculate total sales by adding individual sales figures from different sales representatives. AutoSum can help you quickly get totals for each month.

Project Management

When managing a project, you can use Excel to track hours worked by team members. By adding up the hours in adjacent cells, you can easily see total hours worked and project progress.

Inventory Management

In inventory management, you can use Excel to sum up quantities of products in stock. By referencing cells for each product and using AutoSum, you can maintain accurate inventory records.

Data Analysis

For data analysis, you can use Excel to calculate averages and totals from large datasets. Using formulas and AutoSum can help you quickly analyze trends and make data-driven decisions.

Glossaire :

Formula

A mathematical expression used in Excel that begins with an equal sign (=) and performs calculations on numbers or cell references.

Cell

A single unit in an Excel spreadsheet where data can be entered, identified by its column letter and row number (e.g., A1, B2).

AutoSum

A feature in Excel that automatically calculates the sum of a range of adjacent cells, typically used for quick calculations.

Formula Bar

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

Adjacent Cells

Cells that are next to each other in a row or column, which can be selected together for calculations.

Keyboard Shortcut

A combination of keys that performs a specific command in software, such as using 'Alt' for AutoSum in Excel.

Grand Total

The overall sum of all values in a selected range of cells, often displayed at the bottom of a column or at the end of a row.

00:00:08

Let's take a look.

00:00:10

You add numbers in cells by using formulas.

00:00:14

A formula always starts with the equal sign.

00:00:17

Then enter a number, then a plus sign,

00:00:21

then another number and press Enter and the cell displays the results.

00:00:28

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

00:00:32

Instead of adding numbers within a cell, you can also

00:00:35

reference cells to make adding a bit easier.

00:00:39

B2 is equal to 6, B3 is equal to 3

00:00:44

or create a formula that adds the cells.

00:00:48

I start with an equal sign,

00:00:51

click the cell that I want to add, then a plus sign

00:00:55

and then another cell and press Enter.

00:00:59

If I change a number in a cell, the results automatically update.

00:01:05

You can also add many cells this way, not just two.

00:01:10

You can even add cells and numbers.

00:01:13

I start with equal sign, click the cell I want to add,

00:01:18

then a plus sign, then another cell,

00:01:22

then another plus sign, the number and press Enter.

00:01:28

When you double-click a cell, you can see if it has

00:01:31

a number or a formula or you can look up here in the formula bar.

00:01:40

AutoSum makes it easy to add adjacent cells in rows and columns.

00:01:45

Click the cell below a column of adjacent cells or to

00:01:48

the right of a row of adjacent cells.

00:01:51

Then on the Home tab, click AutoSum and press Enter.

00:01:58

Excel adds all of the cells in the column or row.

00:02:01

It's really handy.

00:02:04

The keyboard shortcut for AutoSum is Alt-=.

00:02:12

You can even select an adjacent group of cells and an extra column and row,

00:02:17

click AutoSum and you get the sum

00:02:19

for each row and column and a grand total.

00:02:25

AutoSum has a number of options.

00:02:27

Choose an option such as Average and Excel calculates the average for the row.

00:02:34

To copy a cell and its formula, click the cell,

00:02:39

point to the bottom right of the cell border so that you see a plus sign,

00:02:44

hold down your left mouse button

00:02:46

and drag it to the right for a column or down for a row

00:02:51

and the formula is copied into the new cells.

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