Join David Rivers for an in-depth discussion in this video Protecting data in a shared spreadsheet, part of Office 2013 New Features.
A very common scenario when working with Excel is to share a workbook, …that is to have more that one person having access to the data, either to make changes…or update or additions.…Protecting that workbook is then something to consider and there are some new options …here in Excel 2013, we're going to explore them using this file named …No Obstacle Sport - Customer Database3.…As you can see down below there are more in than one tab.…There is our main sheet, Sheet1, containing our customer data base information;…and there's also a Power View, and if we switch over to that tab, you can see…we're looking at a table with some tiles. Okay.…
So, maybe this is an area where anyone can have access to manipulate the data and visualize it in different ways.…We don't need to protect that.…But if we go back to our sheet, maybe we do want to protect this sheet.…Well, maybe we want to protect a part of this sheet, and that is an option now…using a Range Protection, so let's talk about that.…Looking at our data, we have First Name, Last Name and we have Phone, Street Address, City, Zipcode.…
- Exploring the new user interface
- Using the bookmark feature
- Inserting online video in Word documents
- Editing PDFs in Word
- Filtering records using the timeline in Excel
- Exploring new slide transitions in PowerPoint
- Creating web apps for SharePoint or Office 365 with Access
- Inserting online pictures with Publisher
- Embedding files in a OneNote notebook
- Connecting to social networks with Outlook
Skill Level Intermediate
1. Suite-Wide Enhancements
Using the Weather bar1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.