WALL STREET PREP
EXCEL CRASH COURSE
Enhanced Exam & Skills Study Guide — 2026
Purpose: Build practical Excel fluency for financial analysis, modeling, data analysis, and
exam-style problem solving.
This is an original study resource. It is not a reproduction of the paid Stuvia document, Wall Street Prep exam, answer key, workbook,
or proprietary course materials.
, 1. Excel Fundamentals & Navigation
The foundation of fast financial modeling is not knowing every menu item; it is navigating, editing, and referencing cells
accurately with minimal mouse use.
• Workbook vs worksheet: a workbook is the Excel file; a worksheet is an individual tab inside it.
• Active cell: the selected cell where an entry or formula will be placed.
• Formula bar: displays and allows editing of the active cell's contents.
• Relative reference: A1 changes when copied. Absolute reference: $A$1 stays fixed. Mixed: $A1 or A$1 fixes one
dimension.
• Cross-sheet reference: =Sheet2!B5 pulls a value from another worksheet.
• Ctrl+End: jumps toward the last used cell. Ctrl+Home returns toward the beginning of the sheet.
• Freeze Panes: keeps selected rows/columns visible while scrolling—especially useful for long financial schedules.
Q. Why are absolute references important in a financial model?
Answer / rationale: They prevent a key assumption—such as a tax rate, discount rate, or unit price—from shifting when a formula
is copied across rows or columns.
Q. What is the practical difference between a formula and a hardcode?
Answer / rationale: A formula derives a value from inputs; a hardcode is an entered constant. Good models minimize
unnecessary hardcodes and centralize assumptions so changes flow through the model.
Q. When should you use Paste Special?
Answer / rationale: When you need controlled copying—for example values only, formulas only, formats only, or mathematical
operations without overwriting the entire destination structure.
2. Formatting, Navigation & Error Control
• Conditional formatting highlights values based on rules and is useful for exceptions, thresholds, negative values, and
review flags.
• Go To Special can select blanks, formulas, constants, visible cells, or other subsets quickly.
• Formula auditing helps trace precedents/dependents and identify broken logic.
• Common errors: #DIV/0! usually indicates division by zero; #REF! indicates an invalid reference; #VALUE! often signals
incompatible data types; #N/A commonly means a lookup did not find a match.
• Custom number formats can change presentation without changing the underlying value.
• Find & Replace is powerful but should be used carefully in models because replacing formulas or references can
unintentionally alter logic.
Q. Why can formatting be more than cosmetic in finance?
Answer / rationale: Consistent formatting communicates model logic: inputs, formulas, outputs, percentages, multiples, dates,
and checks can be visually distinguished, reducing review errors.
Q. What should you do first when you see #REF!?
Answer / rationale: Inspect the formula's references. #REF! generally means a referenced cell, row, column, or sheet was
deleted or otherwise made invalid.
3. Logical, Date & Concatenation Functions
• SUM: adds values. AVERAGE: calculates the arithmetic mean.
EXCEL CRASH COURSE
Enhanced Exam & Skills Study Guide — 2026
Purpose: Build practical Excel fluency for financial analysis, modeling, data analysis, and
exam-style problem solving.
This is an original study resource. It is not a reproduction of the paid Stuvia document, Wall Street Prep exam, answer key, workbook,
or proprietary course materials.
, 1. Excel Fundamentals & Navigation
The foundation of fast financial modeling is not knowing every menu item; it is navigating, editing, and referencing cells
accurately with minimal mouse use.
• Workbook vs worksheet: a workbook is the Excel file; a worksheet is an individual tab inside it.
• Active cell: the selected cell where an entry or formula will be placed.
• Formula bar: displays and allows editing of the active cell's contents.
• Relative reference: A1 changes when copied. Absolute reference: $A$1 stays fixed. Mixed: $A1 or A$1 fixes one
dimension.
• Cross-sheet reference: =Sheet2!B5 pulls a value from another worksheet.
• Ctrl+End: jumps toward the last used cell. Ctrl+Home returns toward the beginning of the sheet.
• Freeze Panes: keeps selected rows/columns visible while scrolling—especially useful for long financial schedules.
Q. Why are absolute references important in a financial model?
Answer / rationale: They prevent a key assumption—such as a tax rate, discount rate, or unit price—from shifting when a formula
is copied across rows or columns.
Q. What is the practical difference between a formula and a hardcode?
Answer / rationale: A formula derives a value from inputs; a hardcode is an entered constant. Good models minimize
unnecessary hardcodes and centralize assumptions so changes flow through the model.
Q. When should you use Paste Special?
Answer / rationale: When you need controlled copying—for example values only, formulas only, formats only, or mathematical
operations without overwriting the entire destination structure.
2. Formatting, Navigation & Error Control
• Conditional formatting highlights values based on rules and is useful for exceptions, thresholds, negative values, and
review flags.
• Go To Special can select blanks, formulas, constants, visible cells, or other subsets quickly.
• Formula auditing helps trace precedents/dependents and identify broken logic.
• Common errors: #DIV/0! usually indicates division by zero; #REF! indicates an invalid reference; #VALUE! often signals
incompatible data types; #N/A commonly means a lookup did not find a match.
• Custom number formats can change presentation without changing the underlying value.
• Find & Replace is powerful but should be used carefully in models because replacing formulas or references can
unintentionally alter logic.
Q. Why can formatting be more than cosmetic in finance?
Answer / rationale: Consistent formatting communicates model logic: inputs, formulas, outputs, percentages, multiples, dates,
and checks can be visually distinguished, reducing review errors.
Q. What should you do first when you see #REF!?
Answer / rationale: Inspect the formula's references. #REF! generally means a referenced cell, row, column, or sheet was
deleted or otherwise made invalid.
3. Logical, Date & Concatenation Functions
• SUM: adds values. AVERAGE: calculates the arithmetic mean.
