Excel - Work simultaneously with others on a workbook Video
In this video, you will learn how to work simultaneously with others on a workbook using Microsoft 365. The video covers the process of sharing your document online and co-authoring, allowing you to see each other's changes in real time.
You can also track other users' work locations and meet them there.
This tutorial will help you collaborate efficiently and effectively with others on a workbook.
- 0:43
- 3190 views
-
Excel - Chat with your co-editors in real-time
- 0:28
- Viewed 3861 times
-
Excel - Password protect workbooks and worksheets
- 2:27
- Viewed 3966 times
-
Excel - IFS
- 1:05
- Viewed 3637 times
-
Excel - Creating a forecast sheet with Excel
- 0:43
- Viewed 2291 times
-
Excel - CONCAT
- 0:51
- Viewed 3491 times
-
Excel - MAXIFS & MINIFS
- 1:06
- Viewed 3225 times
-
Excel - TEXTJOIN
- 0:47
- Viewed 3711 times
-
Excel - Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4059 times
-
Ink Equation
- 0:41
- Viewed 5332 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5150 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5047 times
-
3D Maps
- 1:41
- Viewed 4840 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4708 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4522 times
-
Create a combo chart
- 1:47
- Viewed 4518 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4502 times
-
More complex formulas
- 4:17
- Viewed 4484 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4410 times
-
Manage conditional formatting
- 4:30
- Viewed 4366 times
-
Functions and formulas
- 3:24
- Viewed 4334 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4326 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4297 times
-
Start using Excel
- 4:22
- Viewed 4275 times
-
Manage drop-down lists
- 6:12
- Viewed 4261 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4257 times
-
New Chart types
- 1:52
- Viewed 4228 times
-
The SUMIF function
- 5:27
- Viewed 4228 times
-
A closer look at the ribbon
- 3:55
- Viewed 4190 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4188 times
-
The SUM function
- 4:37
- Viewed 4164 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4162 times
-
AVERAGEIF function
- 3:04
- Viewed 4157 times
-
Using functions
- 5:12
- Viewed 4120 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4117 times
-
Insert columns and rows
- 4:16
- Viewed 4093 times
-
Advanced formulas and references
- 4:06
- Viewed 4077 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4071 times
-
A first look at Excel 2016
- 3:22
- Viewed 4069 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4059 times
-
Add numbers
- 2:54
- Viewed 4054 times
-
Customize charts
- 4:28
- Viewed 4045 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4043 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 4040 times
-
Work with macros
- 4:40
- Viewed 4038 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4032 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4028 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4018 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4008 times
-
Advanced filter details
- 4:13
- Viewed 3991 times
-
Subtract time
- 3:58
- Viewed 3986 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3982 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3976 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3966 times
-
Freeze panes in detail
- 3:30
- Viewed 3965 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3960 times
-
AutoFill
- 2:55
- Viewed 3952 times
-
AutoFilter details
- 3:27
- Viewed 3949 times
-
More print options
- 5:59
- Viewed 3948 times
-
How things are organized
- 1:58
- Viewed 3944 times
-
Copying formulas
- 3:00
- Viewed 3917 times
-
Input and error messages
- 2:52
- Viewed 3915 times
-
IF with AND and OR
- 3:35
- Viewed 3911 times
-
Conditionally format dates
- 2:38
- Viewed 3910 times
-
Introduction to Excel
- 0:59
- Viewed 3906 times
-
Assign a button to a macro
- 2:49
- Viewed 3888 times
-
Sort details
- 4:46
- Viewed 3882 times
-
Insert headers and footers
- 2:02
- Viewed 3874 times
-
Header and footer details
- 3:41
- Viewed 3873 times
-
Drop-down list settings
- 4:14
- Viewed 3871 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3864 times
-
How to create a table
- 2:11
- Viewed 3864 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3861 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3833 times
-
Basic math
- 2:28
- Viewed 3795 times
-
Save your macro
- 2:59
- Viewed 3788 times
-
Operator order
- 2:04
- Viewed 3784 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3767 times
-
Advanced IF functions
- 3:22
- Viewed 3760 times
-
Weighted average
- 2:06
- Viewed 3749 times
-
Cell references
- 1:34
- Viewed 3734 times
-
Use conditional formatting
- 2:02
- Viewed 3722 times
-
Copy a chart
- 2:59
- Viewed 3721 times
-
Improved version history
- 0:51
- Viewed 3713 times
-
TEXTJOIN
- 0:47
- Viewed 3711 times
-
Add formulas and references
- 2:52
- Viewed 3673 times
-
IFS
- 1:05
- Viewed 3637 times
-
Use slicers to filter data
- 1:25
- Viewed 3636 times
-
Save, publish, and share
- 2:22
- Viewed 3626 times
-
Conditionally format text
- 2:12
- Viewed 3624 times
-
Map Chart in Excel
- 0:31
- Viewed 3623 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3612 times
-
One click Forecasting
- 1:01
- Viewed 3607 times
-
Nested IF functions
- 3:30
- Viewed 3605 times
-
Get going fast
- 1:38
- Viewed 3579 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3532 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3512 times
-
Flash Fill
- 2:59
- Viewed 3493 times
-
CONCAT
- 0:51
- Viewed 3491 times
-
Freeze or lock panes
- 1:06
- Viewed 3475 times
-
Edit a macro
- 3:29
- Viewed 3465 times
-
Average a group of numbers
- 2:01
- Viewed 3447 times
-
Drop-down lists
- 0:55
- Viewed 3425 times
-
Create a chart
- 0:52
- Viewed 3412 times
-
Sort and filter data
- 1:38
- Viewed 3407 times
-
SWITCH
- 1:03
- Viewed 3389 times
-
Share documents
- 1:13
- Viewed 3309 times
-
Microsoft Search
- 0:34
- Viewed 3260 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3225 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3176 times
-
Page numbers in depth
- 3:06
- Viewed 3113 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3053 times
-
Funnel Chart
- 0:33
- Viewed 3036 times
-
Accessibility in Excel
- 1:12
- Viewed 2924 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2761 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2717 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2595 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2570 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2523 times
-
Text before & after Function
- 4:57
- Viewed 2409 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2389 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2291 times
-
Change chart type
- 1:29
- Viewed 2022 times
-
Morph transition
- 0:43
- Viewed 7692 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4522 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3882 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3861 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3834 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3761 times
-
TEXTJOIN
- 0:47
- Viewed 3711 times
-
IFS
- 1:05
- Viewed 3637 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3635 times
-
Map Chart in Excel
- 0:31
- Viewed 3623 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3519 times
-
CONCAT
- 0:51
- Viewed 3491 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3435 times
-
Insert icons
- 0:43
- Viewed 3396 times
-
SWITCH
- 1:03
- Viewed 3389 times
-
How to search a file in all channels
- 0:29
- Viewed 3360 times
-
Quickly sort emails
- 0:27
- Viewed 3317 times
-
Display 3 time zones
- 0:37
- Viewed 3305 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3283 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 3273 times
-
Locate your documents
- 0:20
- Viewed 3260 times
-
Microsoft Search
- 0:34
- Viewed 3260 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3254 times
-
Reusing slides
- 0:37
- Viewed 3232 times
-
Identify meeting members
- 0:26
- Viewed 3231 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3225 times
-
How to set quiet hours
- 0:32
- Viewed 3188 times
-
Use dictate to type in Word
- 0:27
- Viewed 3150 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3125 times
-
3D Models
- 0:42
- Viewed 3050 times
-
Funnel Chart
- 0:33
- Viewed 3036 times
-
Translate your Word documents into any language
- 0:33
- Viewed 3022 times
-
Icon insertion
- 0:54
- Viewed 3000 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2940 times
-
Edit document with natural gestures
- 0:34
- Viewed 2918 times
-
Embed fonts in presentations
- 0:40
- Viewed 2837 times
-
New tab "Recording"
- 0:43
- Viewed 2715 times
-
PivotTable Insertions
- 0:43
- Viewed 2671 times
-
Removing the background of a picture
- 0:41
- Viewed 2657 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2613 times
-
Make screenshots easier
- 3:59
- Viewed 2515 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2503 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2291 times
-
Work on multiple windows
- 1:21
- Viewed 2265 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 19 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 15 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 16 times
-
Relevant views to highlight your information
- 01:52
- Viewed 22 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 14 times
-
A well-structured form for easy entry
- 01:17
- Viewed 18 times
-
The right column type for each data set
- 02:35
- Viewed 14 times
-
Custom columns to match your needs
- 02:09
- Viewed 14 times
-
Smooth updates and management for any list
- 01:06
- Viewed 14 times
-
Simple ways to add data to your list
- 01:06
- Viewed 14 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 16 times
-
A fully custom list built from scratch
- 01:34
- Viewed 18 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 19 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 22 times
-
The essentials of the Lists interface
- 02:01
- Viewed 16 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 15 times
-
Introduction to PowerBI
- 00:60
- Viewed 284 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 269 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 261 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 294 times
-
Introduction to Planner
- 00:56
- Viewed 273 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 410 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 280 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 419 times
-
Introduction to Sway
- 01:53
- Viewed 355 times
-
Introducing to Word
- 01:00
- Viewed 258 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 249 times
-
Create a call group
- 01:15
- Viewed 447 times
-
Use call delegation
- 01:07
- Viewed 214 times
-
Assign a delegate for your calls
- 01:08
- Viewed 416 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 220 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 219 times
-
Manage advanced call notifications
- 01:29
- Viewed 230 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 367 times
-
Block unwanted calls
- 01:24
- Viewed 264 times
-
Disable all call forwarding
- 01:09
- Viewed 243 times
-
Manage a call group in Teams
- 02:01
- Viewed 262 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 214 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 219 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 237 times
-
Manage voicemail messages
- 01:55
- Viewed 371 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 409 times
-
Customize your voicemail greeting
- 02:17
- Viewed 214 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 279 times
-
Manage simultaneous calls
- 01:52
- Viewed 246 times
-
Support third-party apps during calls
- 01:53
- Viewed 354 times
-
Add participants quickly and securely
- 01:37
- Viewed 230 times
-
Configure call privacy and security settings
- 02:51
- Viewed 230 times
-
Manage calls on hold
- 01:20
- Viewed 227 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 235 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 221 times
-
Action Function
- 04:18
- Viewed 226 times
-
Search Function
- 03:42
- Viewed 270 times
-
Date and Time Function
- 02:53
- Viewed 293 times
-
Logical Function
- 03:14
- Viewed 451 times
-
Text Function
- 03:25
- Viewed 283 times
-
Basic Function
- 02:35
- Viewed 240 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 283 times
-
Introduction to Power Fx
- 01:09
- Viewed 283 times
-
The New Calendar
- 03:14
- Viewed 489 times
-
Sections
- 02:34
- Viewed 254 times
-
Customizing Views
- 03:25
- Viewed 244 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 552 times
Objectifs :
Understand the collaborative features of online document sharing, including real-time editing and tracking changes made by co-authors.
Chapitres :
-
Introduction to Online Document Collaboration
In today's digital age, sharing documents online has become a common practice, especially for collaborative projects. This section explores the benefits of co-authoring documents, emphasizing the efficiency and immediacy of real-time collaboration. -
Real-Time Changes
When you co-author a document, you can see each other's changes almost instantly. This feature allows for seamless collaboration, as all modifications are reflected in real time. This means that as one person makes edits, others can view those changes immediately, facilitating a dynamic and interactive working environment. -
Tracking Work Locations
Another significant advantage of online document sharing is the ability to track where other users are working within the document. This feature enables team members to meet at specific sections of the document, enhancing communication and collaboration. Knowing each other's locations in the document can help streamline discussions and focus on relevant content. -
Conclusion
The ability to share documents online and collaborate in real time is a powerful tool for teams. By understanding how to utilize these features effectively, users can enhance their productivity and ensure that all contributions are recognized and integrated smoothly.
FAQ :
What is co-authoring?
Co-authoring is a collaborative process where multiple users can edit a document at the same time, allowing for immediate visibility of changes made by each participant.
How does real-time collaboration work?
Real-time collaboration allows users to see changes made by others instantly. When one user edits a document, those changes appear on all users' screens without delay.
Can I track where other users are working in a document?
Yes, you can track other users' work locations within the document, which helps in coordinating efforts and meeting them at specific sections.
What are the benefits of using real-time collaboration tools?
Real-time collaboration tools enhance teamwork by allowing immediate feedback, reducing the time spent on revisions, and improving overall productivity.
Quelques cas d'usages :
Collaborative Document Editing
In a marketing team, members can co-author a campaign proposal document. Each member can contribute their ideas and edits in real time, ensuring that everyone is on the same page and can provide immediate feedback.
Project Management
In a software development project, team members can use real-time collaboration to update project documentation. Developers can track changes made by others, ensuring that all updates are reflected instantly, which improves project efficiency.
Academic Research
Researchers working on a joint paper can utilize co-authoring features to write and edit their sections simultaneously. This allows for a more dynamic writing process and quicker completion of the research paper.
Glossaire :
Co-authoring
The process of multiple users collaborating on a document simultaneously, allowing them to make changes and see each other's edits in real time.
Real-time collaboration
A feature that enables users to work together on a document or project at the same time, with changes being reflected instantly for all participants.
Work locations
The specific areas within a document or project where users are currently making edits or contributions.
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