Creating, Saving & Sharing Workbooks in Excel 2016 for Mac

Excel 2016 (Mac)    |    Beginner
  • 17 videos | 1h 7m 47s
  • Earns a Badge
Rating 4.6 of 30 users Rating 4.6 of 30 users (30)
There are numerous ways to set up a document in Excel. Discover how to create, save, print, and manage documents; edit document properties; work with the protection settings; and share documents via email and OneDrive.

WHAT YOU WILL LEARN

  • Create and open spreadsheets in excel 2016 for mac
    Use document templates in excel 2016 for mac
    Manage your worksheets in excel 2016 for mac
    Save your spreadsheets in excel 2016 for mac
    Save your spreadsheets as pdfs in excel 2016 for mac
    Recover previous versions of your spreadsheets in excel 2016 for mac
    Insert headers and footers in excel 2016 for mac
    Check and set your print area in excel 2016 for mac
    Make sure your spreadsheet is properly adjusted before printing
  • Print spreadsheets in excel 2016 for mac
    Create an accessible spreadsheet using excel 2016 for mac
    Edit your document properties in excel 2016 for mac
    Protect your spreadsheets in excel 2016 for mac
    Send your spreadsheets via email
    Share your spreadsheet via onedrive
    Follow and track changes in excel 2016 for mac
    Comment on spreadsheets in excel 2016 for mac

IN THIS COURSE

  • 4m 19s
    The first step in putting together your spreadsheet is creating a new document. With Excel 2016 for Mac, you can quickly create a new workbook and start entering your data. You can also use Excel 2016 for Mac to open an existing workbook. FREE ACCESS
  • 4m 30s
    Excel 2016 for Mac comes with a large library of spreadsheet templates. These are predefined, preformatted workbooks that can be used to get started on a project quickly. Rather than creating everything from scratch, you can download a template and insert your data. If you need to adjust the template that you have downloaded, you can of course make your own changes as well. FREE ACCESS
  • Locked
    3.  Managing your worksheets in Excel 2016 for Mac
    4m 34s
    Worksheets are used in Excel 2016 for Mac to manage different sets of data within a workbook. A single workbook can contain multiple worksheets, all of which can be modified and managed individually. If you want to get the most out of Excel 2016, you are going to 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
    4.  Saving your document in Excel 2016 for Mac
    3m 43s
    Knowing how to save your Excel 2016 for Mac spreadsheets is essential to being able to work on your document over multiple sessions. When saving the document, you can specify the name of your file, where you'd like to store it and the Excel version that you'd like to save it in. FREE ACCESS
  • Locked
    5.  Saving your document as a PDF in Excel 2016 for Mac
    2m 59s
    A PDF can be opened and viewed by the majority of operating systems and devices -making it a great format for sharing your workbooks and worksheets. Before sharing your document, it is a good idea to adjust your spreadsheet's page layout. Once this is done, Excel 2016 for Mac can quickly convert your document to PDF. FREE ACCESS
  • Locked
    6.  Returning to a previous version of your document in Excel 2016 for Mac
    3m 38s
    If your device crashes while you are working on a spreadsheet, there is always the possibility that any recent unsaved changes will be lost. However, Excel 2016 for Mac enables you to access and recover your documents via your Microsoft account. FREE ACCESS
  • Locked
    7.  Inserting headers & footers in Excel 2016 for Mac
    5m 2s
    If you have additional information to insert in your spreadsheet - such as the document's author, the date it was printed, or its total number of pages - you may find the header and footer tools useful. Headers and footers are areas that are managed independently of any cells and which appear automatically at the top and bottom of every page in your document. They are therefore very useful for storing general information about the spreadsheet that you have open in Excel 2016 for Mac. FREE ACCESS
  • Locked
    8.  Setting your print area in Excel 2016 for Mac
    3m 26s
    Before printing your spreadsheet, it is a good idea to check how it is arranged on your page. Excel 2016 for Mac features a special view mode - Page Break Preview - which is very useful for visualizing the exact layout of your worksheet. There are also a number of other useful tools which you can use to adjust your worksheet's margins and print area. FREE ACCESS
  • Locked
    9.  Adjusting your print page layout in Excel 2016 for Mac
    3m 57s
    Before printing your document in Excel 2016 for Mac, you should check to make sure it is properly laid out. You can choose the paper format, the margin size, and orientation, and even which additional formatting elements are printed as well. FREE ACCESS
  • Locked
    10.  Printing your document in Excel 2016 for Mac
    4m
    When it comes to printing your document, Excel 2016 for Mac allows you control over a large number of settings and variables. You can, for example, specify how many copies you want to print out, which pages you print, the orientation of your document, and even the paper format used by your printer. FREE ACCESS
  • Locked
    11.  Creating an accessible document in Excel 2016 for Mac
    3m 55s
    Individuals with sight difficulties often use specialist tools to identify tags and other structural information embedded in your document. Excel 2016 for Mac features a document scan that can ensure that your spreadsheet is as accessible as possible for all users reading it. FREE ACCESS
  • Locked
    12.  Editing your document properties in Excel 2016 for Mac
    3m 17s
    Your Excel 2016 for Mac workbook contains document properties with additional information about your document. These properties, include the document author, modification dates, and a host of other categories, are not stored in worksheets. See how to edit your document properties, how to access this information and modify it. FREE ACCESS
  • Locked
    13.  Protecting your document in Excel 2016 for Mac
    4m 52s
    If you need to protect the data that you have inserted into your Excel 2016 for Mac workbook, you can use the protection settings. You can choose to protect individual worksheets and their data contents, prevent users from restructuring your workbook or locking your entire document with a password. FREE ACCESS
  • Locked
    14.  Sending your document via email in Excel 2016 for Mac
    2m 23s
    You can use the integrated email function to very quickly send your Excel 2016 for Mac spreadsheet to other users via email. Your email is quickly created and you can adjust your email recipients and choose from different document formats, including XLS and PDF. FREE ACCESS
  • Locked
    15.  Sharing your document via OneDrive in Excel 2016 for Mac
    4m 16s
    OneDrive is a service offered by Microsoft which is used to store files online. It is associated with your Microsoft account (such as Live, Xbox and Hotmail) and can be used to access your documents from any location with an internet connection. This service can be accessed directly via Excel 2016 for Mac. FREE ACCESS
  • Locked
    16.  Following & tracking document changes in Excel 2016 for Mac
    5m 19s
    When there are lots of individuals working on the same shared document, it is vital that you can all keep track of the changes that have been made. In Excel 2016 for Mac, you can use the track changes tool to make sure that any changes that are made are highlighted in the document. These changes can then be viewed, accepted and rejected on an individual basis. FREE ACCESS
  • Locked
    17.  Commenting on a document in Excel 2016 for Mac
    3m 37s
    If there are multiple individuals working on your spreadsheet, you may find the comment tool a useful way of collaborating and coordinating your additions and modifications. You can use the comment tool to leave notes or questions attached to particular data entries in your Excel 2016 for Mac spreadsheet. These comments can be visualized by every user with access to the shared document. 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.5 of 234 users Rating 4.5 of 234 users (234)
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Rating 4.5 of 666 users Rating 4.5 of 666 users (666)