Using Excel 2016 for Windows with Office 365

Excel 2016 (Windows)    |    Beginner
  • 10 videos | 53m 45s
  • Earns a Badge
Likes 200 Likes 200
If you or your organization has a qualifying Office 365 subscription, you can use it to install Excel 2016 and get the latest software updates released by Microsoft. During this course, you will discover the power of Excel to organize, calculate, analyze, revise, update, and present your data. See how to use the full functionality of the Excel worksheet and workbook. Explore the expanded possibilities of cloud computing. With your qualifying Office 365 subscription, you can install Excel 2016, and download the latest releases from Microsoft. Recent Excel updates include streamlined document management, annotation, shared interfaces, additional PivotTable configuration tools, and icon insertion capabilities.

WHAT YOU WILL LEARN

  • Creating & opening a document
    Saving your document
    Inserting icons
    Configuring the default layout of PivotTables
    Annotating your workbook
  • Sharing your workbook via e-mail
    Sharing your workbook via a link
    Managing link access & permissions
    Collaborating on an Excel workbook
    Managing a workbook's version history

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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

Likes 5 Likes 5  
Likes 561 Likes 561  
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1300 Likes 1300