K2's Road to Excellence with Excel Part 8 and VohCom
Tuesday May 15, 2018 at 12:00pm ET

This is the eighth of sixteen sessions in Excel that will provide you with the information you need to become an Excel expert. This session will focus on formula tips.

Formulas are a necessary component of most Excel workbooks. If you know which functions you should insert into formulas to achieve specific results, you are far more likely to be successful when working with Excel. Further, if you are familiar with some of the fundamentals of formulas such as absolute and relative cell referencing, it will help to minimize the likelihood of errors in your workbooks. In this session, we will explore these and other formula fundamentals.

Learning Objectives

  • A review of Relative, Absolute, and Mixed Address Formulas
  • Utilize Parsing and Accruals and Deferrals with Date Arithmetic
  • Manage the combining of Labels with String Arithmetic
  • Parsing Data with Text to Columns
  • Understand the importance of using Defined Names
  • Using Names in Formulas

Accelerate Your Practice with VohCom Page
Accelerate workflow in your office by eliminating your paper files and streamlining your processes with VohCom Page.  Learn key elements to creating time savings of up to 20%.  Explore the inefficiencies that effect your time management and bottom line.  Time saving steps from the initial intake of records, through to file completion and on to invoicing and collection will be explored.  Learn some of the efficiencies employed by Page power users to accelerate you practice.

Learning Objectives

Upon completing this session, you will understand: 
  • The benefits of digital data management and workflow vs traditional methods
  • Best practices in tracking client and internal communications
  • Benefits of built in real time reports and budget monitoring
  • Advantages of one Page to go to for everything for your client
Earn verified PD credits - Attendees must answer at least 75% of poll questions during the live webinar to earn 1 verified PD credit. Attendees who do not answer at least 75% of poll questions during the live webinar earn 1 non-verifiable PD credit.

Register to attend a live webinar and you'll receive the recording and the teaching files within 10 days of the session. Recorded webinars can be viewed when it's convenient for you at the office or at home, and on any device. 

More Ways to
Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
K2's Critical Tips for Avoiding Identity Theft - April 19

Calendar of upcoming webinars