K2's Supercharging Your Spreadsheet Collaboration - On Demand (2 CPD Hours)

K2's Supercharging Your Spreadsheet Collaboration - On Demand (2 CPD Hours)

  • $60.00

Course Description

Working from home and social distancing has made it much more difficult for team members to collaborate on spreadsheets in person.  Fortunately, business versions of Microsoft Office and Microsoft 365 include features like portals with check-in, check-out, and version control as well as comment tracking and file comparisons tools like Inquire which can be used to facilitate cloud-based as well as offline collaboration.  Attend this course and learn how you and your team can work together effectively from anywhere using tools you have already licensed.

Major Topics Covered

  • Collaboration methods using Microsoft Office and Microsoft 365
  • Ways to track changes to sheets and compare different versions of a file
  • Tools for sharing and responding to comments among a team from within a file

Learning Objectives

Upon completing this course, you should be able to:

  • Select from a list Excel features associated with collaboration (Track Changes, Comments, Notes, Custom Views)
  • Explain how the Excel Inquire tool facilitates comparing the differences in two spreadsheets
  • Differentiate between the capabilities of Excel’s old Notes function and the newer Comments function
  • Choose the correct definitions for key terms associated with file storage such as check-in/check-out and version control from a list of options

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.

    Course Information

    • CPD credit: Recommended for 2 hours Computer Software and Applications
    • Prerequisites: A basic understanding of Microsoft Excel
    • Program level: Intermediate
    • Advance preparation: None
    • Who should participate: Accounting professionals who need to collaborate on spreadsheets and other analyses with distributed teams