Risks and Benefits of Excel 2016-Office 365- Video

Price: $29.99

CPE Credits: 2.0

Category: , ,

Course Number: VCX365DR

excel office 365

Description:
You’ll learn from Excel expert David Ringstrom, CPA, how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each version of Excel has been identical for all users, but that’s no longer the case. In this comprehensive course, David discusses the updated features and worksheet functions available in the Office 365 version of Excel 2016, and he shows you step-by-step how to use them. He also shares helpful keyboard shortcuts and tips.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel 2016. He draws your attention to any differences in the perpetual licensed versions of Excel 2016, 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. In addition, David provides an Excel workbook that includes most of the examples he uses during the webcast.

  • Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Understanding the risks and nuances of the AutoSave feature in Office 365.
  • Learning about the MAXIFS function available in certain versions of Excel 2016.
  • Embedding 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel.
  • Providing feedback about Microsoft Excel directly from within Office 365.
  • Using Microsoft’s free Excel Online service to view and edit spreadsheets that use features from Office 365 that aren’t compatible with other versions of Excel.
  • Removing the background from pictures within Microsoft Excel.
  • Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
  • Viewing historical versions of documents you’ve saved to Microsoft’s OneDrive service.
  • Using the Icons command in Office 365 to add emoji-style icons within spreadsheets.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Accessing the superscript and subscript commands with a mouse click instead of by way of the Format Cells dialog box.

Delivery Method: Online QAS Self Study.

Level:  Basic

Prerequisites: None

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: August 2018

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1:40:56

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • Recall which command on the Insert menu allows you to insert emoji into your spreadsheets.
  • Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
  • Recall which versions of Excel enable you to edit and rotate 3D objects.

Description:
You’ll learn from Excel expert David Ringstrom, CPA, how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each version of Excel has been identical for all users, but that’s no longer the case. In this comprehensive course, David discusses the updated features and worksheet functions available in the Office 365 version of Excel 2016, and he shows you step-by-step how to use them. He also shares helpful keyboard shortcuts and tips.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel 2016. He draws your attention to any differences in the perpetual licensed versions of Excel 2016, 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. In addition, David provides an Excel workbook that includes most of the examples he uses during the webcast.

  • Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Understanding the risks and nuances of the AutoSave feature in Office 365.
  • Learning about the MAXIFS function available in certain versions of Excel 2016.
  • Embedding 3D models into Office 365 spreadsheets while seeing what’s viewable in other versions of Excel.
  • Providing feedback about Microsoft Excel directly from within Office 365.
  • Using Microsoft’s free Excel Online service to view and edit spreadsheets that use features from Office 365 that aren’t compatible with other versions of Excel.
  • Removing the background from pictures within Microsoft Excel.
  • Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
  • Viewing historical versions of documents you’ve saved to Microsoft’s OneDrive service.
  • Using the Icons command in Office 365 to add emoji-style icons within spreadsheets.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Accessing the superscript and subscript commands with a mouse click instead of by way of the Format Cells dialog box.

Delivery Method: Online QAS Self Study.

Level:  Basic

Prerequisites: None

Advanced Preparation: None

AuthorDavid Ringstrom,CPA

Publication: August 2018

Format:  On-demand webcast. Powerpoint handout covering video is included as well.
Run-Time: 1:40:56

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • Recall which command on the Insert menu allows you to insert emoji into your spreadsheets.
  • Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
  • Recall which versions of Excel enable you to edit and rotate 3D objects.
  • “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

    - California Ethics Course

  • “Excellent Regulatory Review Course. The self-study format (E-Book) provided an excellent overview of the regulatory requirements for California CPAs. I will be using the E-Book as  a reference material. Thank you for providing a very comprehensive yet affordable option for this required CPE.”

    - Constance

  • “always love your site and prompt customer service !! ”  Dec. 2017

    - Thank you :)