K2'S Supercharging Your Spreadsheet Collaboration
Overview
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments.
Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
Highlights
- 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
Prerequisites
Working knowledge of Microsoft Office Excel
Designed For
Accounting and financial professionals seeking to enhance their spreadsheet collaboration efforts
Objectives
- Select various Excel features associated with collaboration
- List the steps necessary to use Excel’s Inquire tool to identify differences between two spreadsheets
- Differentiate between the capabilities of Excel’s Notes feature and its Comments feature
- 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
Preparation
None
Notice
This course is offered by a 3rd party vendor and will not be accessible in the My CPE Tracker section of the ISCPA website. Course access information will be emailed directly to you by Accounting Continuing Professional Education Network (ACPEN).
Leader(s):
Leader Bios
Brian Tankersley, K2 Enterprises LLC
Brian Tankersley is a CPA and consultant based in Knoxville, Tennessee. Brian is a frequent speaker at continuing education courses on auditing and technology for the American Institute of CPAs and K2 Enterprises, and is a senior faculty member with Becker Professional Review. Brian writes and publishes a nationally recognized blog on accounting and technology (http://blog.bftcpa.com). Tankersley’s areas of practice include accounting systems, taxation, IT consulting, and general business consulting. Prior to forming his own firm Brian practiced in public accounting with both international and local firms, as well as industry. His financial experience includes accounting & auditing, accounting system implementations, tax returns, financial analysis, inventory costing, and audits of public and private companies. Brian’s non-financial experience includes retail, wholesale, and manufacturing industry experience, technology strategy, technology management, systems implementation, technical training and documentation. Brian is both a Certified Public Accountant and Certified Information Technology Professional, and has bachelors degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Mr. Tankersley has served on numerous board of directors and in leadership roles for both his church and in professional organizations. Brian is a member of the Tennessee Society of CPAs, the American Institute of CPAs, and the Information Technology Section of the American Institute of CPAs. He has also served as an officer and director for numerous area community and professional organizations. Brian, his wife Janette, and their four year old son make their home in Farragut, Tennessee. Entered 06/28/2006
Non-Member Price $59.00
Member Price $39.00