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.
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.
Working knowledge of Microsoft Office Excel.
Business professionals who are seeking to stay abreast of major technology developments.
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.
Brian Tankersley, CPA, K2 Enterprises, LLC
Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). He has also served as the technology editor for a major accounting industry publication. Mr. Tankersley has over 20 years of professional experience, including accounting, auditing, technology, and education, and has been with K2 Enterprises since 2005. Tankersley has been recognized annually as one of the “Top 25 Thought Leaders in Public Accounting Technology” for 2011-2014 by Cygnus Business Media. Tankersley is also one of the principal authors of the 2015 Accounting Firm Operations and Technology Survey, which included over 500 US accounting firms. Brian has made presentations in 46 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He received the Outstanding Discussion Leader Award from the Tennessee Society of CPAs in 2009 and 2013, and was recognized for writing the Article of the Year for the Tennessee CPA Journal in 2011. Brian has presented sessions at many national conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group’s Solutions Conference, Sage Insights, CCH Connections, and Thomson Reuters Synergy User Conference. Brian is both a Certified Public Accountant and Certified Information Technology Professional, and has bachelor’s degrees in both Accounting and Finance, cum laude, from the University of Tennessee. He is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). Tankersley also holds numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs. Brian and his family make their home in Farragut, Tennessee.
Non-Member Price $59.00
Member Price $39.00