Level 1 Bootcamp – Excel For Real Estate Bootcamp
Level1ThumbnailNew

Level 1 Bootcamp – Excel For Real Estate Bootcamp

$149.00

Academic Price – $99.00

To get Academic pricing, click Academic Verification in the header and follow the instructions. Once you have Academic status, the discounted pricing will show.

Sample Content

Product Description

An interactive Video Tutorial that teaches the basics of operating in Excel, as well as advanced techniques, specifically as they relate to real estate analysis.  You will follow along in Excel in real time and perform exercises to ensure you are grasping the lesson and are mastering the technical skills being taught.  This product is the REFM Excel for Real Estate Level 1 Certification Preparatory Material.

Product includes the following items, which never expire:

 Online access to an easily navigated 56-minute Video Tutorial, playable on any device including PC, Mac, phones and tablets

SelfStudy750pxwide

 Accompanying fully-unlocked Excel file, compatible with both PC and Mac

Topics Covered (All topics include Exercises and Solutions)

  • Arithmetic and Rounding
  • Statistics
  • Relative vs. Absolute Cell References
  • Inserting and Deleting Rows and Columns
  • Dates and Timelines
  • Conditional Statements
  • Function Wizard
  • Creating Summary Tables
  • Formatting Numbers
  • Conditional Cell Formatting
  • Data Table Lookup Functions
  • Custom Formatting
  • Format Painting
  • Paste Special
  • Transpose
  • Financial Functions for Compounding and Discounting
  • Internal Rate of Return (IRR)
  • Mortgage Payment Calculation
  • Formula Auditing
  • Data Tables for Sensitivity Analysis
  • Circular References
  • Keyboard Shortcuts
  • Best Practices

 Excel Formulas and Functions Taught

  • SUM
  • ROUND, ROUNDUP, ROUNDDOWN
  • MAX, MIN, AVERAGE, MEDIAN
  • Cell Anchoring using Dollar Signs
  • EOMONTH, EDATE, DATEVALUE
  • IF, AND, OR, and combinations thereof
  • SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • VLOOKUP, HLOOKUP
  • IFERROR
  • RATE
  • PV, FV
  • NPV and XNPV
  • IRR and XIRR
  • PMT, PPMT, IPMT

Bundle this product with Levels 2 and 3 and save!

The Half-Yearly sale is here! 40% off all digital products with coupon code: 201740
left to take 50% off with coupon code: yearend50