Excel - How to link cells and calculate formulas across multiple worksheets Tutorial
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
- 4084 views
-
Excel - How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4172 times
-
Excel - How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3624 times
-
Excel - Create a chart
- 0:52
- Viewed 3426 times
-
Excel - Three ways to add numbers in Excel Online
- 3:15
- Viewed 4740 times
-
Excel - How to track and monitor values with the Watch Window
- 2:42
- Viewed 3991 times
-
Excel - How to simultaneously view multiple worksheets
- 3:25
- Viewed 4042 times
-
Excel - Combine data from multiple worksheets
- 2:50
- Viewed 3877 times
-
Excel - Create pie, bar, and line charts
- 3:13
- Viewed 3974 times
-
Ink Equation
- 0:41
- Viewed 5401 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5179 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5066 times
-
3D Maps
- 1:41
- Viewed 4870 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4740 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4554 times
-
Create a combo chart
- 1:47
- Viewed 4544 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4531 times
-
More complex formulas
- 4:17
- Viewed 4518 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4427 times
-
Manage conditional formatting
- 4:30
- Viewed 4376 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4354 times
-
Functions and formulas
- 3:24
- Viewed 4354 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4306 times
-
Start using Excel
- 4:22
- Viewed 4289 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4284 times
-
Manage drop-down lists
- 6:12
- Viewed 4275 times
-
The SUMIF function
- 5:27
- Viewed 4244 times
-
New Chart types
- 1:52
- Viewed 4239 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4207 times
-
A closer look at the ribbon
- 3:55
- Viewed 4203 times
-
The SUM function
- 4:37
- Viewed 4176 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4172 times
-
AVERAGEIF function
- 3:04
- Viewed 4166 times
-
Using functions
- 5:12
- Viewed 4128 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4128 times
-
Insert columns and rows
- 4:16
- Viewed 4109 times
-
Advanced formulas and references
- 4:06
- Viewed 4098 times
-
A first look at Excel 2016
- 3:22
- Viewed 4080 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4070 times
-
Add numbers
- 2:54
- Viewed 4069 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4068 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 4066 times
-
Customize charts
- 4:28
- Viewed 4059 times
-
Work with macros
- 4:40
- Viewed 4053 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4049 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4042 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4039 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4021 times
-
Advanced filter details
- 4:13
- Viewed 4001 times
-
Subtract time
- 3:58
- Viewed 3997 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3991 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3990 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3979 times
-
Freeze panes in detail
- 3:30
- Viewed 3977 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3974 times
-
AutoFill
- 2:55
- Viewed 3963 times
-
More print options
- 5:59
- Viewed 3961 times
-
AutoFilter details
- 3:27
- Viewed 3956 times
-
How things are organized
- 1:58
- Viewed 3954 times
-
Copying formulas
- 3:00
- Viewed 3936 times
-
IF with AND and OR
- 3:35
- Viewed 3928 times
-
Input and error messages
- 2:52
- Viewed 3925 times
-
Conditionally format dates
- 2:38
- Viewed 3924 times
-
Introduction to Excel
- 0:59
- Viewed 3915 times
-
Insert headers and footers
- 2:02
- Viewed 3897 times
-
Assign a button to a macro
- 2:49
- Viewed 3896 times
-
Sort details
- 4:46
- Viewed 3895 times
-
Header and footer details
- 3:41
- Viewed 3888 times
-
Drop-down list settings
- 4:14
- Viewed 3883 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3877 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3876 times
-
How to create a table
- 2:11
- Viewed 3876 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3847 times
-
Basic math
- 2:28
- Viewed 3816 times
-
Save your macro
- 2:59
- Viewed 3800 times
-
Operator order
- 2:04
- Viewed 3797 times
-
Weighted average
- 2:06
- Viewed 3782 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3777 times
-
Advanced IF functions
- 3:22
- Viewed 3768 times
-
Cell references
- 1:34
- Viewed 3755 times
-
Copy a chart
- 2:59
- Viewed 3743 times
-
TEXTJOIN
- 0:47
- Viewed 3735 times
-
Use conditional formatting
- 2:02
- Viewed 3732 times
-
Improved version history
- 0:51
- Viewed 3724 times
-
Add formulas and references
- 2:52
- Viewed 3684 times
-
IFS
- 1:05
- Viewed 3657 times
-
Use slicers to filter data
- 1:25
- Viewed 3654 times
-
Save, publish, and share
- 2:22
- Viewed 3638 times
-
Map Chart in Excel
- 0:31
- Viewed 3638 times
-
Conditionally format text
- 2:12
- Viewed 3633 times
-
One click Forecasting
- 1:01
- Viewed 3626 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3624 times
-
Nested IF functions
- 3:30
- Viewed 3616 times
-
Get going fast
- 1:38
- Viewed 3590 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3540 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3526 times
-
CONCAT
- 0:51
- Viewed 3508 times
-
Flash Fill
- 2:59
- Viewed 3502 times
-
Freeze or lock panes
- 1:06
- Viewed 3485 times
-
Edit a macro
- 3:29
- Viewed 3474 times
-
Average a group of numbers
- 2:01
- Viewed 3458 times
-
Drop-down lists
- 0:55
- Viewed 3443 times
-
Create a chart
- 0:52
- Viewed 3426 times
-
Sort and filter data
- 1:38
- Viewed 3418 times
-
SWITCH
- 1:03
- Viewed 3398 times
-
Share documents
- 1:13
- Viewed 3322 times
-
Microsoft Search
- 0:34
- Viewed 3273 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3234 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3203 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3188 times
-
Page numbers in depth
- 3:06
- Viewed 3139 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3086 times
-
Funnel Chart
- 0:33
- Viewed 3059 times
-
Accessibility in Excel
- 1:12
- Viewed 2933 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2769 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2737 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2610 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2581 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2533 times
-
Text before & after Function
- 4:57
- Viewed 2423 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2407 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2314 times
-
Change chart type
- 1:29
- Viewed 2035 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1782 times
-
Use Copilot with Right-Click
- 02:50
- Viewed 1563 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1316 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1141 times
-
Format Data with Copilot
- 1:52
- Viewed 1116 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 251 times
-
Remove a watermark
- 2:20
- Viewed 16906 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5885 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5618 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5549 times
-
Ink Equation
- 0:41
- Viewed 5401 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 5345 times
-
Change list formatting on the slide master
- 5:22
- Viewed 5233 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5179 times
-
Trigger text to play over a video
- 2:58
- Viewed 5164 times
-
Insert items in a presentation
- 2:38
- Viewed 5098 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5066 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4895 times
-
3D Maps
- 1:41
- Viewed 4870 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4819 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4756 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4740 times
-
Add headers and footers to slides
- 3:52
- Viewed 4682 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4668 times
-
Finalize and review a presentation
- 2:02
- Viewed 4592 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 4586 times
-
Create a combo chart
- 1:47
- Viewed 4544 times
-
Add sound effects to an animation
- 4:29
- Viewed 4544 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4531 times
-
More complex formulas
- 4:17
- Viewed 4518 times
-
Build an org chart using the text pane
- 4:00
- Viewed 4446 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4390 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4390 times
-
Manage conditional formatting
- 4:30
- Viewed 4376 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4369 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4354 times
-
Functions and formulas
- 3:24
- Viewed 4354 times
-
Customize the slide master
- 4:38
- Viewed 4324 times
-
Trigger an animation effect
- 2:29
- Viewed 4310 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4306 times
-
Work with a motion path
- 2:50
- Viewed 4301 times
-
Start using Excel
- 4:22
- Viewed 4289 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4284 times
-
Manage drop-down lists
- 6:12
- Viewed 4275 times
-
Prepare a basic handout
- 4:30
- Viewed 4275 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4260 times
-
Create a flow chart
- 3:27
- Viewed 4251 times
-
The SUMIF function
- 5:27
- Viewed 4244 times
-
New Chart types
- 1:52
- Viewed 4239 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4207 times
-
Create slide content and save the template
- 4:50
- Viewed 4198 times
-
The SUM function
- 4:37
- Viewed 4176 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4172 times
-
AVERAGEIF function
- 3:04
- Viewed 4166 times
-
Using functions
- 5:12
- Viewed 4128 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4128 times
-
Insert columns and rows
- 4:16
- Viewed 4109 times
-
Advanced formulas and references
- 4:06
- Viewed 4098 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4070 times
-
Add numbers
- 2:54
- Viewed 4069 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4068 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 4062 times
-
Customize charts
- 4:28
- Viewed 4059 times
-
Work with macros
- 4:40
- Viewed 4053 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4049 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4042 times
-
Create slicers
- 3:55
- Viewed 4033 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4029 times
-
Create quick measures
- 3:02
- Viewed 4015 times
-
Customize colors and save the theme
- 4:45
- Viewed 4009 times
-
Advanced filter details
- 4:13
- Viewed 4001 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3999 times
-
Subtract time
- 3:58
- Viewed 3997 times
-
Add a picture watermark
- 4:36
- Viewed 3991 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3991 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3990 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3979 times
-
Freeze panes in detail
- 3:30
- Viewed 3977 times
-
Customize the design and layouts
- 5:06
- Viewed 3977 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3974 times
-
Create a template from a presentation
- 3:09
- Viewed 3970 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3969 times
-
More print options
- 5:59
- Viewed 3961 times
-
AutoFilter details
- 3:27
- Viewed 3956 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3956 times
-
Copying formulas
- 3:00
- Viewed 3936 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3935 times
-
IF with AND and OR
- 3:35
- Viewed 3928 times
-
Input and error messages
- 2:52
- Viewed 3925 times
-
Conditionally format dates
- 2:38
- Viewed 3924 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3908 times
-
Insert headers and footers
- 2:02
- Viewed 3897 times
-
Assign a button to a macro
- 2:49
- Viewed 3896 times
-
Sort details
- 4:46
- Viewed 3895 times
-
Header and footer details
- 3:41
- Viewed 3888 times
-
Drop-down list settings
- 4:14
- Viewed 3883 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3877 times
-
How to create a table
- 2:11
- Viewed 3876 times
-
Work with handout masters
- 4:34
- Viewed 3864 times
-
Change the theme background
- 5:38
- Viewed 3863 times
-
Animate pictures and shapes
- 4:17
- Viewed 3854 times
-
Creating and managing a group
- 1:56
- Viewed 3853 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3847 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3842 times
-
Basic math
- 2:28
- Viewed 3816 times
-
Print handouts
- 4:32
- Viewed 3813 times
-
Screen recording
- 0:49
- Viewed 3804 times
-
Save your macro
- 2:59
- Viewed 3800 times
-
Operator order
- 2:04
- Viewed 3797 times
-
Weighted average
- 2:06
- Viewed 3782 times
-
Advanced IF functions
- 3:22
- Viewed 3768 times
-
Cell references
- 1:34
- Viewed 3755 times
-
Copy a chart
- 2:59
- Viewed 3743 times
-
Use conditional formatting
- 2:02
- Viewed 3732 times
-
Customize master layouts
- 4:57
- Viewed 3726 times
-
Improved version history
- 0:51
- Viewed 3724 times
-
Apply and change a theme
- 5:13
- Viewed 3686 times
-
Add formulas and references
- 2:52
- Viewed 3684 times
-
Use slicers to filter data
- 1:25
- Viewed 3654 times
-
Conditionally format text
- 2:12
- Viewed 3633 times
-
One click Forecasting
- 1:01
- Viewed 3626 times
-
Prepare and run your presentation
- 1:28
- Viewed 3624 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3624 times
-
Nested IF functions
- 3:30
- Viewed 3616 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3604 times
-
Combine a path with other effects
- 4:49
- Viewed 3599 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3592 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3587 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3583 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 3576 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3540 times
-
Conditional formatting
- 3:35
- Viewed 3531 times
-
Create an org chart
- 3:09
- Viewed 3529 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3526 times
-
Use the drill down filter
- 4:41
- Viewed 3519 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3487 times
-
Freeze or lock panes
- 1:06
- Viewed 3485 times
-
New chart types
- 0:39
- Viewed 3481 times
-
Edit a macro
- 3:29
- Viewed 3474 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3473 times
-
Animate text
- 4:14
- Viewed 3464 times
-
Ink Equation
- 0:40
- Viewed 3460 times
-
Average a group of numbers
- 2:01
- Viewed 3458 times
-
Design motion paths
- 2:30
- Viewed 3458 times
-
Add staff members
- 2:57
- Viewed 3458 times
-
Drop-down lists
- 0:55
- Viewed 3443 times
-
Sort and filter data
- 1:38
- Viewed 3418 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3417 times
-
Calculate function
- 4:22
- Viewed 3397 times
-
Present Live
- 3:13
- Viewed 3377 times
-
Create a sequence with line paths
- 6:42
- Viewed 3351 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3257 times
-
Start using PowerPoint
- 2:06
- Viewed 3250 times
-
Add bullets to text
- 2:24
- Viewed 3222 times
-
Create a new calendar
- 2:55
- Viewed 3213 times
-
Turn on the drill down feature
- 2:23
- Viewed 3202 times
-
Trigger a video
- 4:06
- Viewed 3193 times
-
Add an alert to a visual
- 2:24
- Viewed 3128 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 3078 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 3075 times
-
Manage interactions
- 1:56
- Viewed 3075 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 3069 times
-
Make a reservation [Customer]
- 2:13
- Viewed 3047 times
-
Create custom fields
- 1:21
- Viewed 3029 times
-
Manage relations between data sources
- 2:37
- Viewed 2997 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2975 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2922 times
-
What are measures?
- 2:58
- Viewed 2907 times
-
Organise notes
- 2:57
- Viewed 2906 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2891 times
-
Add a service
- 2:03
- Viewed 2889 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2869 times
-
Research in your notes
- 1:13
- Viewed 2868 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2860 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2850 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2814 times
-
Create and organise a group
- 1:30
- Viewed 2808 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2804 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2801 times
-
Send your notes by email
- 0:42
- Viewed 2752 times
-
How Clock In Works
- 0:22
- Viewed 2717 times
-
Add a Visio diagram
- 1:23
- Viewed 2707 times
-
Manage our recent documents
- 2:24
- Viewed 2652 times
-
Make better tables
- 10 min
- Viewed 2650 times
-
Creating and managing campaigns
- 1:39
- Viewed 2630 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2625 times
-
Password protect your notes
- 1:43
- Viewed 2619 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2610 times
-
Create a new shared booking page
- 2:32
- Viewed 2609 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2581 times
-
Save, share and share everything
- 0:49
- Viewed 2539 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2434 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 2432 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2429 times
-
Insert online videos
- 0:41
- Viewed 2428 times
-
Text before & after Function
- 4:57
- Viewed 2423 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2401 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 2398 times
-
Add files
- 1:26
- Viewed 2368 times
-
See who's collaborating
- 2:01
- Viewed 2363 times
-
Add items
- 2:04
- Viewed 2358 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2350 times
-
Make a reservation Employee]
- 1:50
- Viewed 2329 times
-
Use page templates
- 2:19
- Viewed 2323 times
-
Create a video from the web app
- 1:20
- Viewed 2322 times
-
Upload an existing video from your device
- 1:11
- Viewed 2311 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2302 times
-
How to Copy a Schedule
- 0:39
- Viewed 2301 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2294 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2288 times
-
Add staff
- 2:36
- Viewed 2275 times
-
Sync and sharing
- 0:28
- Viewed 2274 times
-
Create custom fields
- 1:12
- Viewed 2249 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2225 times
-
Install Office on 5 devices
- 1:53
- Viewed 2223 times
-
Create a video from the mobile app
- 1:13
- Viewed 2204 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2173 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2168 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2164 times
-
Engaging and animating a group
- 1:55
- Viewed 2044 times
-
Change chart type
- 1:29
- Viewed 2035 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1917 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1897 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1782 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1763 times
-
Add a service
- 2:28
- Viewed 1697 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1687 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1675 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1592 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1567 times
-
Draft an Email with Copilot
- 02:36
- Viewed 1434 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1316 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1161 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1141 times
-
Format Data with Copilot
- 1:52
- Viewed 1116 times
-
Improve Email Writing with Copilot Coaching
- 01:47
- Viewed 1111 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 1071 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1059 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 1001 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 577 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 536 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 509 times
-
Create a reminder for yourself
- 01:59
- Viewed 508 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 450 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 439 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 439 times
-
Create and add a signature to messages
- 01:26
- Viewed 416 times
-
Create different types of events
- 01:46
- Viewed 400 times
-
Make changes to a text
- 01:05
- Viewed 394 times
-
Edit and customize views
- 01:55
- Viewed 386 times
-
Sort and filter emails
- 02:51
- Viewed 375 times
-
Manage Teams online meeting options
- 01:56
- Viewed 361 times
-
Create an Email Template
- 01:40
- Viewed 361 times
-
Save and Print a Message
- 01:48
- Viewed 354 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 354 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 352 times
-
Change the default font of your emails
- 01:05
- Viewed 351 times
-
Delay Email Delivery
- 01:10
- Viewed 331 times
-
Improve Email Accessibility
- 02:02
- Viewed 325 times
-
Search options
- 01:23
- Viewed 321 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 318 times
-
Translate Emails in Outlook
- 01:32
- Viewed 314 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 311 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 307 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 285 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 261 times
-
Is a hacker always a cybercriminal?
- 01:31
- Viewed 11 times
-
Will I know what to do if I get hacked?
- 01:16
- Viewed 7 times
-
Do I have to be an IT expert to protect myself?
- 01:14
- Viewed 11 times
-
Do cybercriminals only target large companies?
- 01:21
- Viewed 8 times
-
Are all files safe as long as I open them with trusted software?
- 01:24
- Viewed 10 times
-
Is contactless payment safe ?
- 01:26
- Viewed 19 times
-
Are online payments riskier than in-store ones?
- 01:21
- Viewed 10 times
-
Is cloud storage less secure than my personal computer?
- 01:37
- Viewed 9 times
-
Is scanning a QR code always safe?
- 01:21
- Viewed 8 times
-
Can my mobile apps do anything without my permission?
- 01:19
- Viewed 9 times
-
Is public Wi-Fi safe if no password is required?
- 01:26
- Viewed 8 times
-
Is the sender’s email address enough to verify a message?
- 01:29
- Viewed 9 times
-
Can I safely click a link in a message?
- 01:46
- Viewed 9 times
-
Does connecting to a well-known website guarantee its safety?
- 01:27
- Viewed 10 times
-
Am I safe online if I’m careful?
- 01:22
- Viewed 10 times
-
Does private browsing make me anonymous?
- 01:27
- Viewed 10 times
-
Are updates useless if everything works fine?
- 01:28
- Viewed 7 times
-
Is a firewall the same as an antivirus?
- 01:31
- Viewed 9 times
-
Does my antivirus block all threats?
- 01:46
- Viewed 8 times
-
Is a free antivirus good enough?
- 01:38
- Viewed 11 times
-
Is signing in with Google or Facebook a bad idea ?
- 01:34
- Viewed 7 times
-
Is my password secure if it contains an @ and a number?
- 01:41
- Viewed 11 times
-
Is a strong password all I need to stay safe?
- 01:55
- Viewed 11 times
-
Unlock new possibilities with the Mistral Canvas
- 02:01
- Viewed 14 times
-
Mistral at the service of coding
- 01:37
- Viewed 13 times
-
Analyze and compare your documents with Mistral
- 01:58
- Viewed 11 times
-
Generate your images and visuals with Mistral AI
- 02:06
- Viewed 12 times
-
Use Mistral AI to summarize online information
- 01:00
- Viewed 12 times
-
Exchange and manage your conversations with Mistral AI
- 03:31
- Viewed 12 times
-
Explore Mistral AI's generative options
- 01:51
- Viewed 12 times
-
Set up your Mistral workspace
- 01:42
- Viewed 10 times
-
Discover Mistral, the French-style AI
- 01:51
- Viewed 12 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 29 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 25 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 26 times
-
Relevant views to highlight your information
- 01:52
- Viewed 33 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 24 times
-
A well-structured form for easy entry
- 01:17
- Viewed 31 times
-
The right column type for each data set
- 02:35
- Viewed 27 times
-
Custom columns to match your needs
- 02:09
- Viewed 24 times
-
Smooth updates and management for any list
- 01:06
- Viewed 27 times
-
Simple ways to add data to your list
- 01:06
- Viewed 27 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 27 times
-
A fully custom list built from scratch
- 01:34
- Viewed 28 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 33 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 36 times
-
The essentials of the Lists interface
- 02:01
- Viewed 29 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 30 times
-
Personality and tone for a believable rendering
- 01:48
- Viewed 66 times
-
Format and example for optimal results
- 02:03
- Viewed 68 times
-
The Importance of Context in Your Applications
- 02:14
- Viewed 59 times
-
Task Accuracy in Prompting
- 02:31
- Viewed 126 times
-
The Basis of Prompting in Conversational AI
- 02:41
- Viewed 55 times
-
What is a prompt in conversational AI?
- 02:02
- Viewed 69 times
-
Extract Text from an Image
- 01:07
- Viewed 83 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 140 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 155 times
-
Query an Attached Meeting
- 01:51
- Viewed 65 times
-
Plan with Copilot
- 01:15
- Viewed 98 times
-
Share Requests with Your Team
- 03:07
- Viewed 145 times
-
Translate a presentation
- 01:38
- Viewed 76 times
-
Generate a Video
- 01:49
- Viewed 81 times
-
Add Speaker Notes
- 00:56
- Viewed 83 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 149 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 137 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 157 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 199 times
-
Copilot at the service of project reports
- 02:36
- Viewed 165 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 171 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 304 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 169 times
-
Project mode
- 01:31
- Viewed 163 times
-
Create an agent for a team
- 01:53
- Viewed 279 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 277 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 131 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 282 times
-
Copilot Studio agent settings
- 01:33
- Viewed 122 times
-
Add new actions
- 01:54
- Viewed 279 times
-
Create a first action
- 01:59
- Viewed 267 times
-
Manage topics
- 01:51
- Viewed 154 times
-
Manage knowledge sources
- 01:11
- Viewed 118 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 270 times
-
Access Copilot Studio
- 01:09
- Viewed 265 times
-
Get started with Copilot Studio
- 01:25
- Viewed 131 times
-
Introduction to PowerBI
- 00:60
- Viewed 294 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 281 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 272 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 305 times
-
Introduction to Planner
- 00:56
- Viewed 283 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 422 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 290 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 428 times
-
Introduction to Sway
- 01:53
- Viewed 367 times
-
Introducing to Word
- 01:00
- Viewed 269 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 261 times
-
Create a call group
- 01:15
- Viewed 459 times
-
Use call delegation
- 01:07
- Viewed 225 times
-
Assign a delegate for your calls
- 01:08
- Viewed 426 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 230 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 229 times
-
Manage advanced call notifications
- 01:29
- Viewed 241 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 380 times
-
Block unwanted calls
- 01:24
- Viewed 275 times
-
Disable all call forwarding
- 01:09
- Viewed 255 times
-
Manage a call group in Teams
- 02:01
- Viewed 273 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 224 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 230 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 247 times
-
Manage voicemail messages
- 01:55
- Viewed 382 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 420 times
-
Customize your voicemail greeting
- 02:17
- Viewed 224 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 291 times
-
Manage simultaneous calls
- 01:52
- Viewed 257 times
-
Support third-party apps during calls
- 01:53
- Viewed 376 times
-
Add participants quickly and securely
- 01:37
- Viewed 242 times
-
Configure call privacy and security settings
- 02:51
- Viewed 240 times
-
Manage calls on hold
- 01:20
- Viewed 236 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 245 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 234 times
-
Draft a Service Memo
- 02:33
- Viewed 279 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 270 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 437 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 409 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 141 times
-
Other Coaches
- 01:45
- Viewed 293 times
-
Agents in SharePoint
- 02:44
- Viewed 233 times
-
Prompt coach
- 02:49
- Viewed 261 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 247 times
-
Configure a Copilot Agent
- 02:39
- Viewed 258 times
-
Describe a copilot agent
- 01:32
- Viewed 292 times
-
Rewrite with Copilot
- 01:21
- Viewed 245 times
-
Analyze a video
- 01:21
- Viewed 269 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 251 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 257 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 277 times
-
Create an image with Copilot
- 00:42
- Viewed 473 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 267 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 272 times
-
Chat with Copilot
- 00:50
- Viewed 282 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 453 times
-
Data Privacy in Copilot
- 00:43
- Viewed 276 times
-
Access Copilot
- 00:25
- Viewed 488 times
-
Use a Copilot Agent
- 01:24
- Viewed 312 times
-
Edit in Pages
- 01:49
- Viewed 319 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 292 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 278 times
-
Generate the email for the recipient
- 00:44
- Viewed 268 times
-
Action Function
- 04:18
- Viewed 240 times
-
Search Function
- 03:42
- Viewed 281 times
-
Date and Time Function
- 02:53
- Viewed 302 times
-
Logical Function
- 03:14
- Viewed 463 times
-
Text Function
- 03:25
- Viewed 294 times
-
Basic Function
- 02:35
- Viewed 251 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 292 times
-
Introduction to Power Fx
- 01:09
- Viewed 297 times
-
The New Calendar
- 03:14
- Viewed 501 times
-
Sections
- 02:34
- Viewed 263 times
-
Customizing Views
- 03:25
- Viewed 257 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 562 times
Objectifs :
This video aims to teach users how to link data and calculate formulas across multiple worksheets within a single workbook or across multiple workbooks in Excel. It demonstrates practical steps for linking cells, using formulas, and efficiently filling data across adjacent cells.
Chapitres :
-
Introduction to Linking Data in Excel
Excel provides powerful features that allow users to link data and perform calculations across multiple worksheets. This functionality is essential for managing and analyzing data efficiently, especially when dealing with large datasets spread across different sheets. -
Linking Cells Between Worksheets
To link data from one worksheet to another, follow these steps: 1. Navigate to the target worksheet (e.g., 'Quarter Two'). 2. Click on the cell where you want to display the linked data (e.g., cell B4). 3. Type the equal sign '=' to start the formula. 4. Click on the tab of the source worksheet (e.g., 'Quarter One'). 5. Select the cell containing the data you want to link (e.g., cell B6 for Australia). 6. Press 'Enter' to complete the formula. This process allows you to pull data from one sheet into another seamlessly. -
Understanding the Formula Breakdown
The formula created consists of two main components: - The sheet name (e.g., 'Quarter One') indicates where Excel is searching for the value. - The cell reference (e.g., B6) specifies the exact location of the data within that sheet. This structure allows for dynamic updates; if the data in 'Quarter One' changes, 'Quarter Two' will automatically reflect that change. -
Efficiently Filling Data Across Cells
To avoid repetitive steps when linking data for multiple countries, you can use the fill handle feature: - After entering the formula for the first country, click and hold the fill handle (a small square at the bottom-right corner of the selected cell). - Drag the fill handle to the right to fill adjacent cells with the corresponding formulas for other countries. This method ensures that all linked cells maintain the correct references relative to their positions. -
Summing Data Across Worksheets
When working with balance sheets, you can sum data from all quarters: 1. Click on the cell where you want the subtotal to appear. 2. Type the equal sign '=' and select the corresponding cell from the 'Quarter One' sheet (e.g., B6). 3. Repeat this for other worksheets, ensuring that the countries are in the same order across all sheets. 4. Use the fill handle to quickly apply the formula to adjacent cells, including the total column. This approach streamlines the process of calculating totals across multiple sheets. -
Calculating Data Across Workbooks
You can also use similar formulas to calculate data across different workbooks. However, ensure that the workbooks are open before inserting the formula. The process is similar to linking cells within a single workbook, but you will need to reference the workbook name in the formula. -
Conclusion
Linking data and calculating formulas across multiple worksheets and workbooks in Excel enhances data management and analysis. By mastering these techniques, users can efficiently handle complex datasets, ensuring accuracy and saving time in their calculations.
FAQ :
What is the purpose of linking cells in Excel?
Linking cells allows you to reference data from one worksheet in another, ensuring that any updates to the source data are automatically reflected in the linked cells.
How do I create a formula that references another worksheet?
To create a formula that references another worksheet, start by typing an equal sign in the desired cell, then click on the tab of the worksheet you want to reference, and select the cell containing the data you need.
What is the fill handle and how do I use it?
The fill handle is a tool in Excel that allows you to quickly copy data or formulas to adjacent cells. Click and hold the fill handle, then drag it across the cells you want to fill.
Can I link data from multiple workbooks?
Yes, you can link data from multiple workbooks in Excel. However, you must have the other workbooks open to insert the formula that references them.
What is a subtotal in Excel?
A subtotal in Excel is a calculated sum of a specific range of data, often used to summarize totals for different categories or groups within a dataset.
Quelques cas d'usages :
Financial Reporting
In financial reporting, linking cells across multiple worksheets allows accountants to consolidate data from different quarters and generate comprehensive reports without manually updating figures.
Sales Data Analysis
Sales analysts can use linked cells to compare sales performance across different regions or time periods, enabling them to quickly assess trends and make informed decisions.
Project Management
Project managers can link data from various project phases in separate worksheets to track progress and budgets, ensuring that all team members have access to the most current information.
Inventory Management
In inventory management, linking worksheets can help businesses keep track of stock levels across multiple locations, allowing for better resource allocation and planning.
Budgeting
When creating budgets, users can link data from previous years' worksheets to forecast future expenses and revenues, streamlining the budgeting process and improving accuracy.
Glossaire :
Linking Cells
The process of connecting data from one worksheet to another within Excel, allowing for dynamic updates when the source data changes.
Workbook
A file in Excel that contains one or more worksheets. Each workbook can hold various types of data and calculations.
Worksheet
A single spreadsheet within a workbook, consisting of rows and columns where data is entered and manipulated.
Fill Handle
A small square at the bottom-right corner of a selected cell in Excel that allows users to drag and fill adjacent cells with a series of data or formulas.
Subtotal
A sum of a specific set of data within a larger dataset, often used to summarize totals for categories or groups.
Formula
An expression in Excel that performs calculations on values in cells, starting with an equal sign (=).
Cell Reference
The unique identifier for a cell in Excel, typically represented by the column letter and row number (e.g., B6).
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise