7 Excel shortcuts every junior real-estate analyst should know.
The keystrokes that separate analysts who model fluently from the ones who waste their first month learning Excel on the desk. Free 6-page PDF. Delivered to your inbox in 60 seconds.
What’s inside.
- F4 absolute references — the muscle-memory shortcut for locking columns and rows in financial models
- Paste Special variants — values, formulas, formats, transpose; when each one matters
- Trace precedents and dependents — the keyboard-only auditing pattern senior modelers use
- Range navigation with Ctrl + arrows — how to move through a 5,000-row model without touching the mouse
- Iterative calculation toggle — the setting most analysts don’t know exists, until a circular reference breaks the model
- Custom number formatting — how to display millions, basis points, and percentages without changing the underlying values
- Group / outline shortcuts — collapsing schedules cleanly so your VP can review at a glance
Get the PDF.
Enter your email. We’ll send the PDF immediately. One email, one purpose — no marketing-email drip unless you opt in separately.
Built around the same Excel patterns taught in REIT Modeling — the self-paced REIT modeling course.