Excel - Copying formulas Tutorial

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

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Copy a VLOOKUP formula

In this video, you will learn how to copy a VLOOKUP formula in Microsoft 365. The video demonstrates the process of using absolute cell references by adding dollar signs to your arguments.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.

3:27
1397 views

Excel - How to link cells and calculate formulas across multiple worksheets

In this video, you will learn how to link cells and calculate formulas across multiple worksheets in Microsoft Excel.
The video demonstrates the process of linking data from one worksheet to another within the same workbook or multiple workbooks.
By using the fill handle, you can quickly fill adjacent cells with a series of data.
This technique is useful for summing totals and calculating data across different worksheets.
By following the steps shown in the video, you will be able to efficiently perform calculations and streamline your data analysis in Excel.
This knowledge will help you improve your productivity and accuracy when working with multiple worksheets in Excel.

2:10
1378 views

Excel - Basic math

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

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
1532 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
1488 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