Creating, Saving & Sharing Workbooks in Excel 2016 for Mac
Excel 2016 (Mac)
| Beginner
- 17 videos | 1h 7m 47s
- Earns a Badge
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 Macuse document templates in Excel 2016 for Macmanage your worksheets in Excel 2016 for Macsave your spreadsheets in Excel 2016 for Macsave your spreadsheets as PDFs in Excel 2016 for Macrecover previous versions of your spreadsheets in Excel 2016 for Macinsert headers and footers in Excel 2016 for Maccheck and set your print area in Excel 2016 for Macmake sure your spreadsheet is properly adjusted before printing
-
print spreadsheets in Excel 2016 for Maccreate an accessible spreadsheet using Excel 2016 for Macedit your document properties in Excel 2016 for Macprotect your spreadsheets in Excel 2016 for Macsend your spreadsheets via emailshare your spreadsheet via OneDrivefollow and track changes in Excel 2016 for Maccomment on spreadsheets in Excel 2016 for Mac
IN THIS COURSE
-
4m 19sThe 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… FREE ACCESS
-
4m 30sExcel 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… FREE ACCESS
-
4m 34sWorksheets 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… FREE ACCESS
-
3m 43sKnowing 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… FREE ACCESS
-
2m 59sA 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… FREE ACCESS
-
3m 38sIf 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… FREE ACCESS
-
5m 2sIf 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… FREE ACCESS
-
3m 26sBefore 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… FREE ACCESS
-
3m 57sBefore 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… FREE ACCESS
-
4mWhen 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… FREE ACCESS
-
3m 55sIndividuals 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… FREE ACCESS
-
3m 17sYour 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… FREE ACCESS
-
4m 52sIf 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… FREE ACCESS
-
2m 23sYou 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… FREE ACCESS
-
4m 16sOneDrive 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… FREE ACCESS
-
5m 19sWhen 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… FREE ACCESS
-
3m 37sIf 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… 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.