WALL STREET PREP ACTUAL 10 2026 COMPLETE CORPORATE FINANCE AND EXCEL MODELING PREPARATION MATERIALS

WALL STREET PREP ACTUAL 10 2026
COMPLETE CORPORATE FINANCE AND EXCEL
MODELING PREPARATION MATERIALS

◉ Key settings to change when starting new excel file.
Answer: -Make "workbook calculation" automatic except for data
tables
-Enable iterative calculations


◉ Autofit width of column.
Answer: alt h o i


◉ Change column width arbitrarily.
Answer: alt h o w


◉ Highlight a column.
Answer: ctrl spacebar


◉ Highlight a row.
Answer: shift spacebar

, ◉ Open a cell's dialogue box.
Answer: ctrl 1


◉ Paste special.
Answer: Alt e s


◉ Moving between workbooks.
Answer: ctrl tab


◉ Freezing panes.
Answer: alt w f f


◉ Splitting panes.
Answer: alt w s (f6 and shift f6 to jump back and forth between
panes)


◉ Redo.
Answer: ctrl y


◉ Go to beginning of cell while editing.
Answer: ctrl home