Excel - Combine data from multiple worksheets Tutorial

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

An error occurred while attempting to play the video

Excel - How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 1473 times
Excel - How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 1631 times
Excel - How to track and monitor values with the Watch Window
- 2:42
- Viewed 1457 times
Excel - Three ways to add numbers in Excel Online
- 3:15
- Viewed 1487 times
Excel - How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1378 times
Excel - Top tips for working in Excel Online
- 3:35
- Viewed 1562 times
Excel - Assign a button to a macro
- 2:49
- Viewed 1532 times
Excel - Edit a macro
- 3:29
- Viewed 1230 times

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - How to simultaneously edit and calculate formulas across multiple worksheets

In this video, you will learn how to simultaneously edit and calculate formulas across multiple worksheets in Microsoft 365. The video covers the process of grouping worksheets, making changes that apply to all worksheets, formatting tables, and using formulas.
This tutorial will help you efficiently manage and manipulate data across multiple worksheets, saving you time and effort.

3:07
1631 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 - Merge two columns

In this video, you will learn about merging two columns using Microsoft 365. The video covers the process of merging columns in Microsoft Excel and demonstrates how to do it step by step.
This will help you organize and manipulate data more efficiently in Excel using Microsoft 365.

782 views

Excel - Look up values on a different worksheet

In this video, you will learn how to look up values on a different worksheet using Microsoft 365. The video demonstrates how to use the VLOOKUP function to aggregate data from multiple worksheets into one place.
By entering the appropriate arguments, such as the column reference and the range of cells to search, you can find matching values and retrieve the desired information.
This tutorial will help you efficiently gather and analyze data from different worksheets, improving your data management skills.

2:39
1470 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

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Advanced level

With our "advanced" tutorials, discover and master the full potential of Excel, using complex functions, macros and the power of DCTs and Power Pivot, combined with the Power Query tool.

Your trainer for this course
Cours E-learning

184 vues

ALL COURSES