Saving & Managing Documents in Excel for the Web

Excel for the Web    |    Beginner
  • 9 videos | 31m 59s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 60 users Rating 4.7 of 60 users (60)
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 44s
    When 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 21s
    The 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
  • Locked
    3.  Creating & managing sheet views in Excel for the Web
    3m 33s
    If 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
  • Locked
    4.  Working on multiple spreadsheets in Excel for the Web
    4m 45s
    If 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
  • Locked
    5.  Managing your worksheets in Excel for the Web
    3m 13s
    Worksheets 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
  • Locked
    6.  Reviewing your document in Excel for the Web
    3m 10s
    In 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
  • Locked
    7.  Creating an accessible document in Excel for the Web
    2m 56s
    Individuals 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
  • Locked
    8.  Printing your document in Excel for the Web
    3m 31s
    You 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
  • Locked
    9.  Protecting your document in Excel for the Web
    2m 46s
    If 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.

YOU MIGHT ALSO LIKE

Rating 4.0 of 4 users Rating 4.0 of 4 users (4)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Journey Microsoft Excel
Rating 3.7 of 9 users Rating 3.7 of 9 users (9)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 716 users Rating 4.6 of 716 users (716)
Rating 4.5 of 2842 users Rating 4.5 of 2842 users (2842)
Rating 4.5 of 6282 users Rating 4.5 of 6282 users (6282)