Excel - Three ways to add numbers in Excel Online Tutorial

In this video, you will learn about three ways to add numbers in Excel Online.
The video covers selecting a set of numbers in rows or columns and using the AutoSum function to calculate totals.
It also demonstrates how to use the SUM function to add numbers in a sequence or range, including cells with text or blank cells.
These techniques will help you efficiently calculate totals and analyze data in Excel Online.

3:15
1488 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Knowing the number of numeric values in a column

In this video, you will learn three ways to add numbers in Excel Online.
The video covers selecting a set of numbers on the status bar, using AutoSum to calculate totals, and using the SUM function for more complex calculations.
This will help you efficiently calculate totals and analyze data in Excel.

410 views

Excel - The SUMIF function

In this video, you will learn about the SUMIF function in Excel.
The video covers how to use the SUMIF function to add cells that meet specific criteria.
It demonstrates the syntax of the function and provides examples of how to use it to add cells based on conditions.
This will help you efficiently add numbers in Excel and improve your data analysis skills.

5:27
1735 views

Excel - The SUM function

In this video, you will learn about the SUM function in Microsoft 365. The video demonstrates how to use the SUM function to add up a range of cells in Excel.
It explains the syntax of the SUM function and shows how to add adjacent cells, non-adjacent cells, and cells from different worksheets.
This knowledge will help you efficiently calculate sums in Excel and improve your data analysis skills.

4:37
1654 views

Excel - Average a group of numbers

In this video, you will learn how to average a group of numbers using Microsoft 365. The video demonstrates how to use the AutoSum feature to quickly calculate averages in Excel.
By clicking the cell to the right of a row or below a column, you can access the AutoSum dropdown menu and select the Average option.
The video also explains how to verify the formula and save time when averaging a few cells.
Additionally, it covers how to average values and cells that are not adjacent by using the Average function and ignoring empty cells or those containing text.
This tutorial will help you efficiently calculate averages in Microsoft 365.

2:01
1292 views

Excel - Automatic Data Entry in Excel

In this video, you will learn about automatic data entry in Excel.
The video covers how to enter geographic or stock data, even if they contain spelling errors.
It demonstrates how to select your cells, define the Geography data type, select data to populate your columns, and fill in your table as you wish.
This tutorial will help you improve your data entry skills in Excel and save time.

0:41
626 views

RELATED COURSES This tutorial is part of the following courses

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 introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

229 vues

ALL COURSES