Saving & Managing Documents in Excel for the Web
Excel for the Web
| Beginner
- 9 videos | 31m 59s
- Includes Assessment
- Earns a Badge
In Excel for the Web, it is easy to create and save new workbooks. Learn how to save and download a copy of your documents, as well as protect your Excel workbooks from unwanted edits or use. In Excel for the Web worksheet can contain more than numbers and text, so learn how to search for spelling mistakes and accessibility issues. You will also see how te get statistics concerning the data in your workbook. In this course you will also discover how to work with various workbooks at the same time, manage spreadsheets, and create sheet views.
WHAT YOU WILL LEARN
-
Save and download a copy of your workbook
Recover and restore different versions of a workbook
Create, customize, and delete sheet views
Work with different workbooks simultaneously
Add, customize, and delete worksheets -
Review and get statistics from a workbook
Create an accessible workbook
Configure printing options
Protect and unprotect a workbook
IN THIS COURSE
-
4m 44sWhen working on a workbook in Excel for the Web, any changes you make will be automatically and instantly saved. However, you can choose to save a copy of your document online by choosing the exact location of the file. You can also download a copy of your workbook as a backup or to share offline. FREE ACCESS
-
3m 21sThe automatic save function in Excel for the Web means that you will always have the latest version of your workbook available to you online. Sometimes, however, you may want to access an earlier version of your document. To do so, you will need to know how to open the version history. From this menu option, you can open all previous versions of your document, save a copy, and even restore them to the current version. FREE ACCESS
-
3. Creating & managing sheet views in Excel for the Web3m 33sIf you are working on a shared document with other users in your organization, you may want to create a separate view to easily find the data you are looking for. Excel for the Web allows you to create a customize view of a spreadsheet to sort and filter data without interfering with the work of other users. Learn how to create, manage, and delete a custom view. FREE ACCESS
-
4. Working on multiple spreadsheets in Excel for the Web4m 45sIf you find that you need to work on multiple documents simultaneously, there are several tools that you can use to organize your workspace. In Excel for the Web, you can open multiple workbooks at once. You can also adjust how you visualize these windows, and how you move from one to another. FREE ACCESS
-
5. Managing your worksheets in Excel for the Web3m 13sWorksheets are used in Excel for the Web to manage different sets of data within a workbook. A single workbook can have multiple worksheets, all of which can be changed and managed individually. If you want to get the most out of Excel for the Web, you will need to know how to navigate between your worksheets and how to modify their properties, such as their position, their name, and even their color. FREE ACCESS
-
6. Reviewing your document in Excel for the Web3m 10sIn Excel for the Web, you can check the spelling of a single worksheet or your entire workbook. Access the Spelling tool via the Review tab to get started correcting your spelling. You will be able to use suggestions to correct your data or ignore them, so they do not get flagged as incorrect. You can also change the dictionary language if your spreadsheets include multiple languages. FREE ACCESS
-
7. Creating an accessible document in Excel for the Web2m 56sIndividuals with sight difficulties often use specialized tools to identify tags and other structural information embedded in your document. Excel for the Web features a document scan that can ensure that your spreadsheet is as accessible as possible for all users reading it. FREE ACCESS
-
8. Printing your document in Excel for the Web3m 31sYou have the possibility of printing one of your workbooks in Excel for the Web with several print settings you can configure before printing. Such as, the orientation of your paper, how many copies you want to print and how your data will be displayed. In this video, you will see how to access the print settings in Excel for the Web and in the web browser Microsoft Edge. FREE ACCESS
-
9. Protecting your document in Excel for the Web2m 46sIf you plan to share a document with other users, but you also need to prevent any changes into your workbook, protect your document with Excel for the Web. Learn how to activate the protection so the workbook will always open as read-only. You will also see how to deactivate the protection. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
