K2's Road to Excellence with Excel Part 17 and Intuit ProFile

This is the seventeenth in a series of sessions in Excel that will provide you with the information you need to become an Excel expert. This session will focus on the use of security.

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.

Learning Objectives

  • Understanding the benefits of shared workbooks and utilize this feature to facilitate collaboration
  • Securing Excel in the Trust Centre
  • Securing Documents
  • Encrypting Document
  • Workbook and Worksheet Protection

Make the Most with Intuit ProFile
ProFile is Canada’s #1 professional tax software application. See the new features and enhancements to help you collaborate more efficiently with your clients and streamline your workflow.

Learning Objectives

Upon completing this session, you will understand:
  • The top 10 Reason why customers love ProFile
  • Other great features and what’s new with ProFile
  • The Quickbooks and ProFile Ecosystem and why Quickbooks and ProFile are better together

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 from the Webinar

Excel Questions
Answers
If a workbook is protected, does this not also protect the worksheets in the workbook?
No, it only protects the structure of the sheets in a workbook. To protect a sheet is a different process.
Can I protect against access to macros within this workbook?
Yes, by locking the macro and entering a password. Here are the steps to do this:
  1. Open the Excel worksheet where you wish to place the macro and then activate the Visual Basic for Applications options by turning on the Developer tab. To do so, select “Options” from the “File tab, click on “Customize Ribbon,” check the “Developer” box and click “OK” to add the tab to the Excel Ribbon.
  2. Click on the “Developer“ tab on the Ribbon and then select “Visual Basic” to launch the Visual Basic work area.
  3. Open the “Tools” menu and then select the “Visual Basic Properties” option to open the “VBA Project –Project Properties” window.
  4. Click the “Protection” tab and place a check in the box labeled “Lock project for viewing.”
  5. Input a password and confirm the password in the selected sections. Click "OK" to save the password. Now to view the macro content you must enter the password.
Tell us more about Onedrive?
Check out this website.
Is "real time" sharing only available if individuals are on the same network or can this be done over the internet/cloud/some other?
Co-authoring requires an Office 365 subscription and the file must be stored on OneDrive, OneDrive for Business or a SharePoint online library.
Intuit ProFile Questions
Answers
How can we make suggestions on items to update in Profile?
Within the ProFile software there is a Suggestion button option and also under the Help Menu called “What should we build next?”
With the ProFile import function from prior year.  If I have 10 years of client returns from 2008 to 2017 in Cantax, could I import all ten years into ProFile to retain customer history in the new software?
You can carryforward the information into ProFile from 2008 Cantax.
The option to import straight from 2008 Cantax and forward… to 2008 ProFile and forward is not an option available at the moment.
Are the in cloud backups on Canadian Servers?
Our cloud backups are in several server locations in North America and are very secure using Bank grade encryption.
Who has access to your cloud backup files?
Only the account holder who creates the ProFile Review account will have access to the data.
With ProFile 20, how far back can you go for T1s?
ProFile 20 supports T1/TP1 returns for tax years 2015, 2016, and 2017