K2's Road to Excellence with Excel Part 21
and Wolters Kluwer, iFirm Ecosystem

This is the twenty first in a series of sessions in Excel that will provide you with the information you need to become an Excel expert, focusing on the use of lookups, an important analytical tool in Excel. A lookup formula returns a value from a table by looking up another related value.

Learning Objectives

  • Describe the various lookup options that are available in Excel
  • Understand how to use the LOOKUP, VLOOKUP and HLOOKUP functions
  • Utilize the IFERROR function to deal with data errors
  • Understand how to combine VLOOKUPs in a single formula
  • Utilize VLOOKUPs across multiple sheets

Accelerate Your Practice with the Cloud-Based Power of CCH iFirm!
CCH iFirm is an online solution that will help you run a better business and keep your staff and clients connected and happy. Join us for this informative webinar to learn how CCH iFirm can help you elevate the quality, accuracy, and efficiency of your firm’s work.

Learning Objectives
Upon completing this session, you will recognize the benefits of CCH iFirm which include:
  • Collaborate with staff in an organized, efficient, and intuitive online platform
  • Easily track and manage deadlines, job status, invoices, missing items, important dates to remember, and important questions to ask
  • Streamline your workflows
  • Monitor and optimize WIP
  • Strategically increase your team's efficiency and your firm's profitability by analyzing the built-in reporting features
  • Review your staff's performance and easily identify improvement and training opportunities
  • Improve your business relationships

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
In the first example, the lookup value should have been B2, not H2. The formula should be vlookup(b2, h2:j11,3,0)
That was my mistake. It is corrected in the recording.
Why the index is 3?
The 3 tells Excel what column to get the answer from.
In the first example don't understand why the lookup comes up at $600,000.  Shouldn't it be $1 million?
That was my mistake. It is corrected in the recording.
Wolters Kluwer Questions
Answers
Is it safe on a public network?
Yes, CCH iFirm is an https site.
Will iFirm scan your existing Outlook by client name to set up due date reminders, etc?
CCH iFirm is not integrated with Outlook yet.  This is on our Roadmap.
Will the notes be able to directly send email?
The Client Notes section in Contacts and Jobs do have an email option.
Will it show timesheet view?
There is a timesheets view – daily, weekly, monthly.
Does it allow data export to Excel?
Yes, the reports have an Export to Excel option.
How much does it cost? Pricing range?
I’m not in the sales role but it is modular so you pick and choose which modules suit you.  It is a monthly cost and you can increase/decrease users when you need to.  If you would like to be connect to a salesperson for pricing, please go to wolterskluwer.ca or ifirmtax.ca and you can request a quote.
One of the areas I keep contact info is on my mobile phone.  Is there a mobile phone integration with iFirm?
Anything you do in CCH iFirm’s Contact records on a mobile phone, tablet, ipad or laptop is logging into the same environment.  If you are speaking about your mobile phone contacts, no, these are not sync’d or integrated with the CCH iFirm contacts.
Can a T1 or T2 be locked down after e-filed?
Yes, all returns can be locked.