Preview of Excel for Real Estate Certification Level 1 Bootcamp | Excel for Real Estate Course

This course includes:

• Chaptered video totaling 3 hours
• Fully-unlocked Excel file with solution set
• Lifetime access, even on mobile devices
• Access to the online Certification exam, which bestows Level 1 Excel for Real Estate Certification upon passing

Overview

In this 3-hour course, you will learn 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 bein

Topics Covered Include:

• 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
• COLUMNS, ROWS
• IFERROR
• RATE
• PV, FV
• NPV and XNPV
• IRR and XIRR
• PMT, PPMT, IPMT
• CUMPRINC, CUMIPMT.

Instructions

Download the Excel from the Materials tab above. Then watch the videos, and follow along and perform the exercises in the Excel.

Video Sample

• Introduction to Table of Contents
• Keyboard Shortcuts Introduction
• Spreadsheet and Formula Basics
• Insert Function Button
• Formatting Conventions Used
• Format Cells Box
• Custom Formatting
• Format Painting
• Arithmetic/Addition
• SUM Function
• Subtraction
• Multiplication
• Division
• Exponents

Excel File Tabs

The Excel file is 100% unlocked, and you can re-purpose the tabs and comprising code as you desire.

1. Keyboard Shortcuts
2. Spreadsheet and Formula Basics
3. Cell Formatting
4. Arithmetic
5. Statistics
6. Relative vs. Absolute References
7. Insert and Delete Rows and Columns
8. Dates
9. SUMIF and COUNTIF
10. Paste Special, Transpose
11. VLOOKUP and HLOOKUP
12. Conditional Statements
13. Conditional Statements Solution
14. Conditional Formatting
15. TVM and Financial Functions
16. Financial Functions Exercise
17. Mortgage Payment
18. Mortgage Payment Exercise
19. Mortgage Payment Exercise Solution
20. CUMPRINC and CUMIPMT
21. Formula Auditing
22. Data Source
23. Data Tables
24. Circular References
25. Best Practices