Date: Wednesday, April 28, 2021
10:00am-11:15am PT / 1:00pm-2:15pm ET
Format: A BVR Webinar

Earn 1.5 CPE credits
Add this event to your calendar
Register for this program:

Priority Code:

*Training Packs include: a complete recording and transcript with all presentation and reading materials delivered via an electronic download
Please note: CPE credit is not available through Training Packs
More information is available below

Featuring  (click image for bio)

Shawn Hyde
Canyon Valuations

About This Program

Several Microsoft Excel functions are already available in most modern versions of the program that many valuation experts are unaware of. If you use Microsoft Excel for any sort of process, the use of certain functions can make your templates more accurate and allow you to complete an analysis quicker. Join valuation expert and Excel guru Shawn Hyde to learn about setting up dynamic text, which means typing a sentence in a cell in an Excel spreadsheet that has one or more numbers linked to other cells in that same spreadsheet. See how a forecast can be developed that will include the appraiser’s assumptions tied directly to the forecast, so any change in assumption will automatically be reflected in the forecast. Have you ever gotten tired of clicking through an Excel workbook to find just the right sheet? Learn how to set up an internal hyperlink to make finding those sheets easier and quicker.


  • Dynamic tools
  • Building a forecast
    • Linking  assumptions to the forecast
  • Report Organization
    • Internal hyperlink to make finding those sheets easier and quicker
  • Functions and where to apply them
    • MID
    • TEXT
    • FIND
    • INDEX
    • MATCH

    Learning Objectives

    • Demonstrate how to create and use Named Cell references
    • Demonstrate how to use functions like MID, TEXT, FIND, HYPERLINK, NUMBERVALUE, INDEX and MATCH
    • Describe how an business valuation professional can use these functions

Single Connection Policy

Admission to this event authorizes one computer and phone connection for one location. These connections may be transferred users and/or locations. Multiple concurrent connections for a single admission registration are not allowed.

Multi-User CPE Policy

Admission to this program includes one CPE certificate for one individual. Any additional listeners requesting CPE must pay a processing fee assessed at the completion of the online CE survey for this course.

CPE Processing Fees may be bypassed by entering a valid, unused CPE Authorization Code (for single event purchasers) or by logging into BVR's website (for subscribers to BVR's Training Series).

CPE Information

Prerequisites: Knowledge of Business Valuation
Program Level: Advanced
Preparation Required: None
Delivery Method: Group Internet-Based
Recommended CPE: 1.5 Credit Hours (Accounting Techncial)

Closed Captioning:

BVR now has closed captioning on all 2019 past programs. To try out this enhancement, subscribers can login to the Desktop Learning Center, select a program, and click play video. The captions will start to play automatically, and can be disabled from the player per your preference.

Business Valuation Resources is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
NASBA Sponsor

Training Packs: Conference Recordings & Transcripts
Now delivered as an electronic download.

BVR's Training Packs are an indispensable addition to any valuation reference library. Use them as training tools as many times as you'd like, wherever you are: play them at your computer at work or home, in your car, or on your personal audio device.

Delivered as an electronic download approximately four weeks after the program has aired, each Training Pack includes:

  • Recordings and transcripts of the presentation
  • All presentation visual aids and handouts
  • All ancillary reading materials suggested by our presenters

For a complete list of available Training Packs from past webinars, click here.

Subscriber Information

Subscribers to BVR's Training Passport are automatically registered for this event. For more information contact BVR or login to your account.

BVR's Satisfaction Guarantee:
Business Valuation Resources offers a 100% money-back guarantee on our training services. If you are not completely satisfied with your experience, or have any feedback, please contact Business Valuation Resources at 1-503-479-8200 or customerservice@bvresources.com.