Real Estate Financial Modeling Tools

# USAA Level 1 Bootcamp – Excel For Real Estate

\$0.00

## Description

### Welcome USAA Real Estate Company Associates!

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 preparatory material for the REFM Excel for Real Estate Level 1 Certification.

Product includes the following items, which never expire:

Online access to an easily-navigated 3-Hour Video Tutorial, playable on any device including PC, Mac, phones and tablets. Video contains closed captions. 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
• IF, AND, OR, and combinations thereof
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• VLOOKUP, HLOOKUP
• COLUMNS, ROWS
• IFERROR
• RATE
• PV, FV
• NPV and XNPV
• IRR and XIRR
• PMT, PPMT, IPMT
• CUMPRINC and CUMIPMT

• Keyboard Shortcuts Introduction
• Insert Function Button
• Formatting Conventions Used
• Format Cells Box
• Custom Formatting
• Format Painting
• SUM Function
• Subtraction
• Multiplication
• Division
• Exponents
• Order of Operations
• Evaluate Formula Function
• Rounding
• ROUND Function
• ROUNDUP Function
• ROUNDDOWN Function
• Alt Hotkeys
• Statistics
• MAX Function
• MIN Function
• AVERAGE Function
• MEDIAN Function
• Relative and Absolute References
• Relative Reference
• Absolute Reference
• Inserting and Deleting Rows
• Inserting and Deleting Columns
• Dates
• Annual Timeline
• Monthly Timeline
• EOMONTH Function
• EDATE Function
• SUMIF Function
• SUMIFS Function
• COUNTIF Function
• COUNTIFS Function
• Paste Special
• Transpose
• VLOOKUP Function
• COLUMNS Function
• HLOOKUP Function
• ROWS Function
• Conditional Statements/IF Function
• OR Function
• AND Function
• Nesting Conditional Statements
• Nesting and Multiplying by the IF Function
• Conditional Formatting
• Time Value of Money/Discounted Cash Flow Model Introduction
• PV Function
• FV Function
• NPV Function
• IRR Function
• XNPV Function
• XIRR Function
• Mortgage Payment Introduction
• Mortgage Amortization Table Overview
• Beginning Balance
• Monthly Payment
• Principal Portion/PPMT Function
• Interest Payment Portion/IPMT Function
• Ending Balance
• CUMPRINC Function
• CUMIPMT Function
• Formula Auditing
• Trace Dependents
• Trace Precedents
• Remove Arrows
• Data Tables
• Circular References
• Best Practices