Creating Formulas that Work
Tuesday, October 31st, 2023 | 8:30AM – 4:30PM Central Time
Instructor: Brent Bowen
**Registration closes at 7AM Central Time on 10/31/2023**
$155.95
COURSE APPROVAL INFORMATION
AL – Course #CO2861
*AZ – Accepts
AR – Course #AE039
CA – Course #2310501057
CO – Course #2477
FL – Course #3766
GA – Course #76915
HI – Course #PENDING
*ID – Accepts
IL Course #575.010683
IN – Course #PENDING
*IA—Accepts
KS – Course #496.C23.N
KY – APPROVED
LA – Course #A0044
MD – Course #PENDING
MA – Course #1360036
MI – Course #20-103968
MN – Course #1035989
MS – Course #50528
MO – APPROVED
MT – Course #REA-CEC-REC-17077
NE – Course #2233490.33
NV – Course #CE.0009801-A
NH – Course #PENDING
NJ – Course #2023-217
NM – Course #4329
NY – Course #A5689-07
NC – Course #4596
*ND—Accepts
OH – Course #Q04302309A 23
OK – Course #728
OR – Course #APEL-C-0923-0062
PA – APPROVED
RI – Course #PENDING
SC – Course #CE2137
TN – Course #2711
TX – Course #47540
UT – Course #AC230911
VA – APPROVED
WA – Course #A23025814
WV – APPROVED
WI – Course #PENDING
*States with an asterisk will accept CE which is approved in the state where it is being taught.
Pending approval in many states!
If you don’t see your state listed, CLICK HERE to send an email to our education director, Ben Maxwell, and request approval or ask questions.
This course tackles one of the toughest problems we face as appraisers: applying mathematical analysis to inherently irrational human behavior.
As appraisers, we analyze the real estate market. But residential market data isn’t just cold, hard numbers; it reflects human hopes and fears, egos and aspirations. How do we make logical sense of how people buy homes—decisions that are often irrational?
In the course, we’ll start with common valuation theory and use spreadsheets to build mathematical models (formulas in Excel and Google sheets) that incorporate behavioral economics—to reframe our analyses in a more sophisticated and nuanced way.
After you enroll, you’ll get a free, ready-to-use formula template, which you can easily adapt to your local market. Once you apply your favorite research tools, the template will empower you to deploy advanced formulas that’ll supercharge your analytical methodologies, improving your speed and precision.
If you’re an experienced appraiser with basic proficiency in Excel or Google Sheets, this course is for you. (And if you’re new to these platforms, you’ll get a lot more out of this course if you take a Excel and Google Sheets tutorial first.) You should have a working knowledge of market research methods such as paired sales, grouped data analysis, and depreciated cost analysis. And if you’re already using research applications like Solomon Adjustment Calculator, Synapse, Gandysoft, Appraiser Toolkit, or others, it’ll be a snap for you to integrate data from those tools into this practical formula template.
Take this course, and you’ll come away with a robust, customizable template and the ability to use it. You’ll understand how and why we integrated appraisal theory with behavioral economics to structure this template. And you’ll be able to apply advanced formulas to help you analyze how real people actually behave in the real estate market.
Course Policies
Refund/Cancellation/Transfer Policy:
- Refund requests must be made at least 24 hours prior to the start of class. Cancellation must be in writing. No refunds will be given within 24 hours of class start.
- If you register within 24 hours of Class Start, you will only be eligible for a transfer. This transfer credit expires 30 days after the original class date. After this 30 day period, we are unable to issue a transfer, and you will forfeit the class cost.
CE Requirements/Attendance Policy:
- The class is offered via Zoom Meeting.
- Computer audio/video, reliable internet connection, and 100% attendance are required for CE credit.
- We must be able to see and hear your camera, and driving or riding in a car is not allowed during class. These are state requirements for CE.
Software/System Requirements:
Class is offered via Zoom Meeting.
- If you’re new to Zoom, the links below may be helpful:
- Click the following link to download Zoom: https://
zoom.us/download - Click the following link to launch a Zoom Test Meeting: https://zoom.us/test
- Click the following link to download Zoom: https://
Reminders:
- *KNOW YOUR TIMEZONE: We’re on CENTRAL TIME. Class starts promptly at 8:30am Central.
*If you are on Pacific Time, Classis from 630am-230am PT (doors open at 530am)
*If you are on Mountain Time, Classis from 730am-330pm MT (doors open at 630am)
*If you are on Central Time, Classis from 830am-430pm CT (doors open at 730am)
*If you are on Eastern Time, Classis from 930am-530pm ET (doors open at 830am)
Everything you need to know about our live virtual class offerings via Zoom
How do I register?
- Add any live-zoom course(s) to your cart and proceed to checkout.
- IMPORTANT: Be sure to provide the correct state and license number information during checkout, as this will be automatically pulled into our system for your completion certificate and reporting to your state.
- Once purchased, you’ll be automatically registered for the Zoom class meeting and you will receive a receipt via email.
What happens once I purchase?
- You will receive a confirmation email with your JOIN MEETING link (save this! This is the link you will click to join the zoom class meeting on Class Day.)
- If this is your first purchase with us, you will also receive an email with your Student Login Credentials, which give you access to your Student Account; Your student account is where you will access any online courses or completion certificates.
- If your Zoom Class comes with Course materials, they will be made available in your student account and also emailed to you in reminder emails (see “What to expect on class day.” below)
- If you don’t see your confirmation email (and you’ve checked your spam folder), just email us (we make typos too, and we’re happy to help).
- We highly recommend you download zoom for an even better in-class experience.
- You’ll receive reminder emails the day before and the morning of class. (NOTE: If you register within 24 hours of class start time, you might not receive reminder emails.)
- Be sure to click the Zoom meeting link and join the meeting 30 minutes before class start time, so we can get you checked in.
What do I need prior to class?
- Check your time zone! All classes are listed in CENTRAL TIME, so adjust your calendar accordingly. Our reminder emails the day before and the morning of class will list the correct times for all time zones, for reference.
- Download any course materials. You can find all appropriate documents for your course under “My Courses” in your student account.
- If you are taking a USPAP update course, have the current USPAP publication on hand.
- It is required that you keep your camera on for the duration of the class. Be sure to have a device with a working webcam, audio, and microphone, as well as good internet access.
Use the Zoom meeting link to join the class 30 minutes before class start time, so we can get you checked in.
Where is my link to join class?
- You should have received a confirmation email immediately after purchase, as well as reminder emails the day before and the morning of class. Your Zoom link to join class can be found in any of those emails.
- Be sure to check your spam folder if it is not in your inbox.
What should I expect on class day?
- Remember to use the Zoom meeting link to join class at least 30 minutes before the official start time, so we can get you checked in.
- Zoom Confirmation Emails (how you join the class): We will resend everyone’s Zoom confirmation emails 1 hour prior to class start
- Class Reminder emails with handouts (if any) and reminders: We send reminder emails on the day before and the day of class (unless class falls on a Monday or Friday; we don’t work weekends)
- Reminder emails will include: Any class handouts (if applicable), important expectations and requirements; REMINDERS ABOUT KNOWING YOUR TIME ZONE (we’re on Central Time); and student support / instructor contact information.
- Remember: you must be present with your camera on 100% of the class time. (This is a state requirement, not ours. We cannot make exceptions.)
What is your refund/cancellation Policy if I have to miss the class?
- Refunds require a 24-hour written notice.
- BUT if you miss class and forget to notify us, no worries! Just reach out to our team, and we’re happy to transfer you to a later class.
- We can only provide one transfer, so if you miss the second class, you will not have the option for a transfer and will forfeit the purchase cost.
What’s required for CE credit?
- You must be present with your camera on for the duration of class. (This is a state requirement, not ours. We cannot make exceptions.)
- You must be visible and prepared to answer instructor questions (please do not drive, work on other tasks, walk your dog, or anything else that might be distracting to the class).
- If you have an emergency or are otherwise prevented from being present and visible on camera, please contact one of the class moderators.
What features should I be aware of on the Zoom platform?
- Chat Feature
- Raise Hand Feature (alt + Y is the keyboard shortcut, or click the Reactions button)
- Mute/Unmute & Stop Video (you should only turn cameras off when on breaks)
- In addition to the live instructor, we’ll have a team member available to help everything run smoothly during class.
What happens after class ends?
- Ben Maxwell, our Education Director, will email a Course Evaluation link to all students immediately after class.
- Once you complete the evaluation, you’ll receive an emailed certificate from our LMS. Please keep in mind that failure to complete this survey will delay your certificate (it is REQUIRED).
- If you have any issues with the automated certificate, just reply to Ben’s Course Evaluation email and request a PDF copy.
- If you’re in a state that requires the provider to report on your behalf, we will report your CE after class. Please give us 24 hours to do so. (States in which we report on your behalf include: FL, GA, IL, NC, NV, OH, SC, TX, and UT.)
- If you have any questions, the instructor and class moderator will stick around for a few minutes after class ends.
How can I reach out if I still have questions?
- Feel free to reach out to our team Monday – Friday from 9:00 AM to 5:00 PM CST. Call us at (615) 965-5705 or email us at support@appraiserelearning.com | support@agentelearning.com
Course Author
Brent Bowen
Brent is the President of Texas Valuation Professionals, and has been a real estate professional in north Texas since 1997. He graduated from Baylor University with an enthusiasm for both economics and real estate, and found that becoming a Certified Appraiser engaged both disciplines perfectly. Brent has written several articles featured in industry publications and has trained many appraisal professionals throughout his career. As a Certified Distance Education Instructor (CDEI), Brent now shares his techniques and perspectives with the appraisal community in a classroom setting.
