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
1501 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - More complex formulas

In this video, you will learn about more complex formulas in Microsoft 365. The video covers advanced formula techniques and demonstrates how to create complex formulas in Excel using functions and operators.
This will help you enhance your data analysis skills and make more sophisticated calculations in Excel.

4:17
1550 views

Excel - Three ways to add numbers in Excel Online

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
1508 views

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 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
1672 views

Excel - Copying formulas

In this video, you will learn about copying formulas in Microsoft Excel.
The video covers how to copy a formula down a column to add pairs of cells.
It demonstrates how to use the black plus sign in the bottom right-hand corner of a cell to copy the formula into other cells.
The video also explains the concept of relative cell references, which is the default in Excel.
However, it shows that sometimes you may want to use absolute cell references to prevent the references from changing when you copy a formula.
By using the dollar sign before the column and row references, you can make a cell reference absolute.
This will help you understand how to copy formulas accurately and efficiently in Excel.

3:00
1385 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

243 vues

ALL COURSES