Excel - How to use 3-D reference or tridimensional formulas Tutorial

In this video, you will learn about how to determine the right tool to use in collaborative work using Microsoft 365. The video covers the importance of defining your collaboration needs, identifying the different uses of Microsoft 365, and promoting change within your organization.
This will help you make informed decisions on which tools to use for effective collaboration.

3:01
1474 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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 - Add formulas and references

In this video, you will learn about adding formulas and references in Microsoft 365. The video covers how to use formulas and references in Office apps like Word, Excel, and PowerPoint to enhance your work and collaboration.
You can easily create formulas to perform calculations and use references to link data between different files.
This will help you improve your productivity and efficiency when working with Microsoft 365.

2:52
1363 views

Excel - Combine data from multiple worksheets

In this video, you will learn how to combine data from multiple worksheets using Microsoft 365. The video covers the process of merging data from different worksheets in Excel, allowing you to streamline your data analysis and reporting.
This skill will help you save time and improve your productivity when working with large datasets.

2:50
1348 views

Excel - Cell references

In this video, you will learn about cell references in Microsoft 365. The video covers how to use cell references in Excel to link and manipulate data across different cells and worksheets.
This will help you improve your data analysis and organization skills in Microsoft 365.

1:34
1313 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
1653 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

204 vues

ALL COURSES