K2's Road to Excellence - Part 13
Excel's Security Tools and Xero

Securing documents and collaborating with others are mandatory techniques for success in today’s environment. Fortunately, Excel provides a number of powerful options for each of these two activities, and most of these options are available on the Review tab of the Ribbon. On the Review tab, you will find multiple options for securing your Excel documents and also for sharing and working with others in real-time on the same Excel workbook. In this session, you will learn how to work more effectively with Excel’s primary security and collaboration tools.

Major Topics

  • Securing Excel in the Trust Centre
  • Encrypting Documents
  • Workbook and Worksheet Protection
  • Sending Workbooks Via Email
  • Sharing Workbooks

Introduction to Xero

Approximately 12% of small businesses are currently using online accounting platforms for their bookkeeping today in Canada.  In 5 years, over 60% plan to be using online tools.  Bookkeepers and firms who are able to consult on and assist with this transition are positioned well to take advantage.  Learn how Xero can help your firm save time.  

More Ways to
Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
Catalogue of upcoming webinars

Questions & Answers

Excel Questions
Answers
Can you please do a session on how to update from Windows 7?
Early 2020
What is the difference between Office 365 and 2019?
Office 365 receives new features on a monthly basis, a listing of the latest features is available here. Other differences are listed here.
Can you do a session on free VPNs?
Early 2020
Password for Excel? Aren’t there a zillion tools on the Internet that can break this protection immediately – for <$100?
Any password is subject to brute force attach so a good password is required. A good password is “longer than 12 characters and has never been used before – which means it was generated by a password manager.”
Is there any way to encrypt just one worksheet?
Yes. Under File – Info – Protect Workbook and select Protect Current Sheet. Add a password and save the file.
Are files in OneDrive automatically included in your SharePoint?
OneDrive for Business and SharePoint online are different storage locations and storing a file in one does not store the file in the other.