Login to Your Account
Regular Price: $99.00 Member Price: $59.00 Your Price: $99.00 Regular Price: $ Member Price: $ Your Price: $
This engaging presentation by David Ringstrom, CPA, will empower you to quickly accomplish tasks that might currently be taking you several minutes or even hours to complete. David explains a variety of Excel’s time-saving features and shares helpful tips, such as how to filter data faster, streamline repetitive tasks, create keyboard shortcuts, and access folders and workbooks easily.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Access to the online course ends when you complete the course or 6 months after registration, whichever comes first.
Cancellation Policy
Close
In this valuable one-hour course, Excel expert David Ringstrom gets you up to speed on the What-If-Analysis tools available within Excel’s Data menu. David explains how and when to make use of Excel’s Scenario Manager, as well as how to use the Data Table feature to compare calculation results based on two or three inputs. In addition, David provides a brief overview of Excel’s Solver feature and demonstrates how to use Excel’s Goal Seek feature.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Topics Covered:
Using a financial calculator, real estate expert Eric Storey, CPM, CCIM, will do analysis of cash-on-cash returns, net present value (NPV), and internal rate of return (IRR) and discuss how they are used to measure investment performance. Eric will demonstrate how to:
Eric will demonstrate keystrokes using the HP 10bII+ calculator. Feel free to follow along on your calculator or a comparable app available on your smartphone or tablet.
In this one-hour course, Eric Storey, CPM, CCIM, examines and analyzes mortgage, leverage, and lease aspects of properties and how they all impact the bottom line. He’ll use a financial calculator to:
This application-heavy one-hour course will explore in depth the concept of the time value of money and its importance in real estate financial analysis. Utilizing a financial calculator, real estate expert Eric Storey, CPM, CCIM, will:
Eric Storey CPM, CCIM is a Senior Vice President of Corporate Real Estate for Zions Bank in SLC, Utah. Eric is an IREM instructor for the Asset Track and Finance 402. Eric is also a Licensed Real Estate Broker and Certified General Appraiser in Utah.
* Course qualifies for early pricing.Classroom offerings: Register 30 days or earlier prior to the start date of an eligible course to save $100.
Regular Price: $745.00-$845.00* Member Price: $599.00-$699.00* Your Price: $745.00-$845.00* Regular Price: $ Member Price: $ Your Price: $ Course meets program requirements: CPM, ACoM
* Course qualifies for early pricing. Classroom offerings: Register 30 days or earlier prior to the start date of an eligible course to save $100. Online courses are excluded from early pricing.
On-Demand Open Enrollment
On-Demand
Vancouver, CAN12/09/2019 - 12/10/2019Early Pricing has Ended Please call 1(800)837-0706 ext. 4650 to register.
Canada Morgage & Housing Corp.450-99 Canada Pl. Vancouver, CAN V6C 3E1 Sponsored by REIC - Real Estate Institute of Canada
Milwaukee, WI01/27/2020 - 01/28/202021 Days Remainingfor Early Pricing
Wisconsin Assoc. Management11801 W. Silver Spring Dr. Suite 200Milwaukee, WI 53225 Sponsored by Milwaukee Chapter No. 13
Englewood, CO02/24/2020 - 02/25/202049 Days Remainingfor Early Pricing
Colorado Assoc of Realtors309 Inverness Way S, Englewood, CO 80112 Sponsored by Greater Denver Chapter No. 17
Tysons Corner, VA03/09/2020 - 03/10/202063 Days Remainingfor Early Pricing
TBD Tysons Corner, VA Sponsored by Region 3 Education Committee
Livonia, MI03/23/2020 - 03/24/202077 Days Remainingfor Early Pricing
Powerscourt17199 N. Laurel Park Drive Livonia, MI 48152 Sponsored by Michigan Chapter No. 5
San Diego, CA03/23/2020 - 03/24/202077 Days Remainingfor Early Pricing
IREM San Diego ChapterChapter Office 4849 Ronson CourtSan Diego, CA 92111 Sponsored by San Diego Chapter No. 18
Sacramento, CA03/23/2020 - 03/24/202077 Days Remainingfor Early Pricing
191 Lathrop Way191 Lathrop Way, Suite A Sacramento, CA 95815 Sponsored by Sacramento Valley Chapter No. 22
New Orleans, LA04/06/2020 - 04/07/202091 Days Remainingfor Early Pricing
1515 Poydras1515 Poydras St. New Orleans, LA 70012 Sponsored by Mr. Casey J. Moriarty, CPM
Ft. Lauderdale, FL04/20/2020 - 04/21/2020105 Days Remainingfor Early Pricing
Nova Southeastern University3301 College Avenue, Building 37 Ft. Lauderdale, FL 33314-7796 Sponsored by South Florida Chapter No. 19
Braintree, MA04/27/2020 - 04/28/2020112 Days Remainingfor Early Pricing
The Simon Companies639 Granite St. Lower Level Conference RoomBraintree, MA 02184 Sponsored by Boston Metropolitan Chapter No. 4
Santa Monica, CA04/27/2020 - 04/28/2020112 Days Remainingfor Early Pricing
Santa Monica Business Park (SMBP)3200 Ocean Park Blvd. Santa Monica, CA 90405 Sponsored by Greater Los Angeles Chapter No. 6
Addison, TX04/27/2020 - 04/28/2020112 Days Remainingfor Early Pricing
Spectrum Center 5080 Spectrum Drive Suite 122 WAddison, TX 75001 Sponsored by Dallas Chapter No. 14
Kansas City, MO05/04/2020 - 05/05/2020119 Days Remainingfor Early Pricing
Yarco Company, Inc.7920 Ward Parkway Kansas City, MO 64114 Sponsored by Kansas City Chapter No. 15
Atlanta, GA05/18/2020 - 05/19/2020133 Days Remainingfor Early Pricing
Northcreek Office Park3715 Northside Pkwy., NW Building 200Atlanta, GA 30327 Sponsored by Georgia Chapter No. 67
New York, NY06/15/2020 - 06/16/2020161 Days Remainingfor Early Pricing
Cushman & Wakefield51 Madison Ave. Conference CenterNew York, NY 10010 Sponsored by Greater New York Chapter No. 26
Kirkland, WA06/15/2020 - 06/16/2020161 Days Remainingfor Early Pricing
IREM Training Room12131 113th Ave., NE Touchstone Bldg.Kirkland, WA 98034 Sponsored by Western Washington Chapter No. 27
Portland, OR07/27/2020 - 07/28/2020203 Days Remainingfor Early Pricing
Sixth+Main1050 S.W. 6th Ave. 1st Floor Training RoomPortland, OR 97204 Sponsored by Oregon-Columbia River Chapter No. 29
Charlotte, NC08/17/2020 - 08/18/2020224 Days Remainingfor Early Pricing
Carole Hoefener Center615 East Sixth Street Charlotte, NC 28202 Sponsored by Western North Carolina Chapter No. 40
Oakbrook, IL09/21/2020 - 09/22/2020259 Days Remainingfor Early Pricing
IREM Chicago Chapter No. 232901 Butterfield Road Oakbrook, IL 60523 Sponsored by Chicago Chapter No. 23
Las Vegas, NV09/21/2020 - 09/22/2020259 Days Remainingfor Early Pricing
Nevada State Apartment Association6276 S. Rainbow Blvd. Las Vegas, NV 89118 Sponsored by Las Vegas Chapter No. 99
Princeton, NJ10/05/2020 - 10/06/2020273 Days Remainingfor Early Pricing
TBD Princeton, NJ Sponsored by New Jersey Chapter No. 1
Baltimore, MD10/26/2020 - 10/27/2020294 Days Remainingfor Early Pricing
TBD Baltimore, MD Sponsored by Region 3 Education Committee
Houston, TX11/02/2020 - 11/03/2020301 Days Remainingfor Early Pricing
Millennium Tower1st Flr Training Room 10375 Richmond Ave.Houston, TX 77042 Sponsored by Houston Chapter No. 28
Phoenix, AZ11/02/2020 - 11/03/2020301 Days Remainingfor Early Pricing
Sunland Asphalt1625 E. Northern Ave. Phoenix, AZ 85020 Sponsored by Greater Phoenix Chapter No. 47
Orange, CA11/09/2020 - 11/10/2020308 Days Remainingfor Early Pricing
Granite Properties 770 The City Drive South, Suite 1400 Orange, CA 92868 Sponsored by Orange County Chapter No. 91
While it may not seem important on a day to day basis, understanding financial concepts can help you build value and increase income for your business holdings. Let’s be honest. Fluctuations in the financial and real estate market are inevitable. But with this course, you’ll learn to produce higher revenue for your portfolio – despite the turbulence of the market.
Register and learn the ins and outs of financing and leverage:
Take this course on its own or together with Performance and Valuation of Investment Real Estate (ASM604) and Asset Analysis of Investment Real Estate (ASM605) with the Asset Management Track.
Financial Calculator or App Required: The HP10bII or HP10bII+ financial calculator or similar financial calculator app is required. Course materials illustrate keystrokes for the HP10bII+ calculator. Students are encouraged to download the HP10bII Financial Calculator Quick Reference Guide and review it prior to taking this course.
Laptop Computer Required : In addition to the financial calculator, course materials extensively use the IREM Financial Analysis Spreadsheet to facilitate hands-on learning in the classroom. With your registration confirmation, you will receive a link to the IREM Financial Analysis Spreadsheet. It is strongly recommended that you download the spreadsheet to your laptop prior to attending the class.
Review the learning objectives of this course.
Please note: taking FIN402, ASM603, ASM604, ASM605, and MPSAXM in consecutive order is strongly recommended.
Classroom: The classroom course is 2 days, including lunch and breaks. Typical course timeframe is 8:30 a.m. to 5:00 p.m. each day. Select a specific offering of the course from the dropdown menu above for exact dates and times. The course exam is taken online within 7 days after completing the course; instructions to access the exam are provided during the course.
Accelerators: Live Webinars
Accelerators: On-Demand
If you’re tired of trying to manage large Excel spreadsheets, you’ll find this course to be extremely helpful. Excel expert David Ringstrom demonstrates multiple ways you can tame cumbersome spreadsheets with confidence. He shares time-saving techniques and keyboard shortcuts, outlines how to avoid repetitive tasks, explains ways to improve the integrity of your spreadsheets, and more.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Learning Objectives:
Do you or your staff work in the accounting function at the property? Accurate and efficient accounting helps to ensure the overall financial health of the asset. In this entry-level course, real estate expert and IREM instructor Sal Dragone, CPM, CCIM will:
Do you or your staff prepare and review budgets at the property? An accurate and error-free budget can be one of the property’s most important tools. In this entry-level course, real estate expert and IREM instructor
Sal Dragone, CPM, CCIM will:
In this valuable course, Excel expert David Ringstrom teaches you how to create and use Excel pivot tables so you can crunch numbers like a pro! Pivot tables enable you to easily create reports from complex data simply by using your mouse. David shows you how to initiate a pivot table from a list of data, add fields, dig deeper into the numbers, and more. In addition, he points out pivot tables traps and shares tricks to help ensure your reports are accurate.
Join Excel expert David Ringstrom, CPA, as he introduces several lookup functions, including VLOOKUP, HLOOKUP, MATCH, and CHOOSE. These powerful Excel functions allow you to rapidly develop accurate spreadsheets and look up information, such as pay rates, item prices, and accounting results, versus manually linking to specific cells. David explains the context of when to use lookup functions, demonstrates troubleshooting techniques, and prepares you to deal with subtle issues that can prevent them from working properly.
Regular Price: $199.00 Member Price: $119.00 Your Price: $199.00 Regular Price: $ Member Price: $ Your Price: $
Waterfall calculations are used to allocate cash flow among two or more partners based on their agreed-upon return parameters. In this course, Excel expert David Ringstrom, CPA, brings his prior commercial real estate experience to the forefront by walking you through assembling a waterfall calculation from scratch. David starts with a blank worksheet and details every input and formula. He covers such concepts as range names, although he provides cell-address references you can use in lieu of range names if so desired. David contrasts using the IRR worksheet function versus the XIRR worksheet function for computing investment returns. Additional worksheet functions—MIN, ROUND, DATE, SUMIF, and others—are included in David’s discussion. Check figures are used extensively throughout the model to ensure data integrity. Check figures also empower users to easily follow the calculations through the tiers.
Excel Speed Tips
Regular Price: $99.00 Member Price: $59.00
Regular Price: $ Member Price: $
Excel’s What-If Analysis Tools
Financial Concepts and Calculations: Cash-on-Cash, Net Present Value, and Internal Rate of Return
Financial Concepts and Calculations: Mortgage, Leverage, and Lease Analysis
Financial Concepts and Calculations: The Time Value of Money
Financing and Loan Analysis for Investment Real Estate - ASM603
Regular Price: $745.00-$845.00* Member Price: $599.00-$699.00*
26 Upcoming Courses
Gaining Control of Large Excel Spreadsheets
Introduction to Accounting
Introduction to Budgeting
Introduction to Excel Pivot Tables
Introduction to VLOOKUP
Introduction to Waterfall Calculations
Regular Price: $199.00 Member Price: $119.00
Download a printable course registration formView All Products
You have (0) items in your cart
Continue ShoppingProceed to Checkout