From the course: Excel Essential Training (Microsoft 365)
Video is locked.
Unlock the full course today
Join today to access over 20,400 courses taught by industry experts or purchase this course individually.
Sharing workbooks
From the course: Excel Essential Training (Microsoft 365)
Start my 1-month free trial Buy this course (A$50.00*)
- Transcripts
- Exercise Files
- View Offline
“
- [Narrator] If you want to allow multiple users to access the same workbook, you'll need to know how to activate sharing, and ultimately the ability to track changes by each user. And when we say, open at the same time, we are also opening the door to the idea that people could be making changes to the same cells at approximately the same time frame. The feature called sharing, in prior versions of Excel, used to be found on the review tab. Now, when you go to the review tab in the ribbon, you don't see sharing, but you might see here, grayed out, unshare workbook. So how do we share our workbook? We need to add an icon to the quick access toolbar. On the right side of the quick access toolbar, and most people do keep this above the ribbon, there's a drop arrow, slide down to more commands. In this dialog box, choose commands from either commands not in the ribbon or all commands. Slide down to the letter S, and you'll see an option. "Share workbook," it's a Legacy feature. We add it…
Sharing workbooks
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download the exercise files for this course.
Get started with a free trial today.
Practice while you learn with exercise files
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere.
Get started with a free trial today.
Download courses and learn on the go
Contents
-
Introduction Introduction
-
Getting started with Excel for Office 365
38s
-
-
1. Getting Started with Excel 1. Getting Started with Excel
-
What is Excel used for?
2m 25s
-
Using the Quick Access Toolbar and ribbon menu
3m 26s
-
Shortcut menus and the Mini toolbar
2m 59s
-
Understanding workbooks and worksheets
2m 56s
-
Using Excel Help
2m 47s
-
-
2. Entering Data 2. Entering Data
-
Exploring data entry, editing, and AutoFill
4m 8s
-
Working with dates and times
3m 2s
-
Using Undo and Redo
2m 39s
-
Using Save or Save As
3m 34s
-
-
3. Formulas and Functions 3. Formulas and Functions
-
Using simple formulas
3m 57s
-
Copying a formula into adjacent cells
3m 2s
-
Using SUM and AVERAGE
4m 6s
-
XLOOKUP and lookup functions
4m 32s
-
-
4. Formatting 4. Formatting
-
Exploring font styles and effects
4m 9s
-
Applying borders and color backgrounds
2m 55s
-
Adjusting row heights and column widths
4m 30s
-
-
5. Adjusting Worksheet Layout and Data 5. Adjusting Worksheet Layout and Data
-
Rows and columns: Insert, delete, hide, and unhide
4m 30s
-
Moving, copying, and inserting data
2m 52s
-
Finding and replacing data
3m 8s
-
-
6. Printing 6. Printing
-
Page Layout view and commands
4m 59s
-
Using Page Break Preview and print setup options
4m 39s
-
-
7. Charts 7. Charts
-
Creating charts
5m 39s
-
Exploring chart types
3m 58s
-
Working with Excel Ideas
5m 9s
-
-
8. Adjusting Worksheet Views 8. Adjusting Worksheet Views
-
Freezing and unfreezing panes
3m 17s
-
Splitting screens horizontally and vertically
4m 42s
-
-
9. Multiple Worksheets and Workbooks 9. Multiple Worksheets and Workbooks
-
Renaming, inserting, and deleting sheets
3m 7s
-
Moving, copying, and grouping sheets
3m 21s
-
-
10. Data Management Features 10. Data Management Features
-
Sorting data
5m 5s
-
Using filters
3m 15s
-
Creating PivotTables
4m 56s
-
New data types coming to Excel for 365
6m 58s
-
-
11. Sharing Workbooks 11. Sharing Workbooks
-
Protecting worksheets and workbooks
4m 48s
-
Sharing workbooks
2m 57s
-
Tracking changes
4m 14s
-
-
Conclusion Conclusion
-
Next steps
25s
-