Using Excel 2016 for Windows with Office 365

IN THIS COURSE

• 1.  Creating & opening a Excel 2016 document in office 365
  5m 52s
  In order to be able to use your Office 365-activated version of Excel 2016, it is important to know how to create new workbooks and open your saved spreadsheets. You will see how to open a blank spreadsheet as well as an existing one. You will also see how to configure the number of recent workbooks to be displayed in the recent files list. FREE ACCESS
• 2.  Saving an Excel 2016 document in Office 365
  6m 8s
  You can save your documents in several different places when using an Office 365-activated installation of Excel 2016. You will see how to save a document for the first time as well as how to save it to the cloud on your professional OneDrive and SharePoint accounts. Saving your documents to the cloud also enables automatic saving and allows you to save a copy of your document in different locations. FREE ACCESS
• 3.  Inserting icons in Excel 2016 for Windows
  5m 38s
  With an Office 365-activated installation of Excel 2016, you can insert icons into your workbook to add visual elements to your document. You will see how to insert different icons into your workbook and how to format them. FREE ACCESS
• 4.  Configuring the default layout of PivotTables in Excel 2016 for Windows
  6m 5s
  When using your Office 365 installation of Excel 2016, you can configure the default layout of the pivot tables that you insert into your workbooks. You will see how to access the pivot table options and configure the layout to suit your needs. FREE ACCESS
• 5.  Annotating your workbook in Excel 2016 for Windows
  5m 42s
  With your Office 365 installation of Excel 2016, you can use the inking tools available via the Draw tab. You will see how to use the different pens and tools available in this tab in order to annotate and correct your workbook. FREE ACCESS
• 6.  Sharing your workbook via e-mail in Excel 2016 for Windows
  5m 30s
  When using your Office 365 installation of Excel 2016, you can share your workbook via email a couple different ways. You will see how to access the email options and share a workbook as an attachment in an email as well as how to open an Excel file that was shared with you via email. FREE ACCESS
• 7.  Sharing your workbook via a link in Excel 2016 for Windows
  4m 17s
  When using your Office 365 installation of Excel 2016, you can share your workbooks via a link. You will not only see how to share a file via a link but how to choose the editing permissions as well. You will also see how to view your shared files in Excel. FREE ACCESS
• 8.  Managing link access & permissions in Excel 2016 for Windows
  5m 18s
  With your Office 365 installation of Excel 2016, you can change the editing permissions for a link to be more restrictive or open, depending on your preferences. You will see how to modify the editing permissions and manage access to the shared link. FREE ACCESS
• 9.  Collaborating on an Excel workbook in Excel 2016 for Windows
  3m 49s
  When using your Office 365 installation of Excel 2016, you can easily collaborate on a document in real time. Once you share a document that has been saved to the cloud, you will see when other people are viewing and editing the document and you can even see who each person is, start a chat with them and access their contact card or SharePoint profile. FREE ACCESS
• 10.  Managing a workbook's version history in Excel 2016 for Windows
  5m 25s
  With your Office 365 installation of Excel 2016, you can manage a workbook's version history by opening a different version of the workbook and checking it out so no one else can edit it at the same time as you. FREE ACCESS