Excel pages
- Cover
- Assumptions
- Calculates
- Debt
- Income Statement
- Balance Sheet
- Cash
Steps
- Optimal excel settings
- History: sub-total
- Forecast income statement for Year1
- Balance B/S
- Extend formula from Year1 to subsequent years
- Beauty save the model
File > Options (Windows: Alt+F+T; Mac: cmd+comma)
Ctrl + R: copy formula to the right.
Ctrl + C / Enter 一次性复制粘贴
Ctrl + page up/page down: move excel page.
=FORMULATEXT(): show the formula of this cell.
Shift+fn+f2: add a comment to a cell