Using blue font for hard-coded numbers and black font for formulas is not a specific financial modeling technique. Instead, it is a formatting convention that some financial modelers or spreadsheet users follow to make their Excel models easier to read and understand.
The "Go To Special" Excel capability enables you to select or highlight every cell that contains a formula.
The shortcut keys on the keyboard for inserting a table in Excel are:
ALT + N + T
Pressing "ALT + N + T" keys together will open the "Create Table" dialog box, allowing you to quickly create a table from a selected range of data in Excel.
The AutoSum shortcut keys in Excel are:
ALT and =
Pressing "ALT" and "=" (equal sign) keys simultaneously in Excel will quickly insert the AutoSum function, allowing you to sum the numbers in the column directly above the active cell. This shortcut is a convenient way to perform a quick summation of a column of numbers without manually typing the formula.
The correct shortcut in an Excel spreadsheet to add a new row is:
ALT + H + I + R
Pressing the keyboard shortcut "ALT + H + I + R" in Excel will insert a new row above the currently selected row. This is a quick way to add a new row without having to use the mouse and right-clicking on the row number to choose the "Insert" option. The "ALT + H + I + R" shortcut provides a more efficient method to add rows when working with Excel spreadsheets.
The key combination "F4" on the keyboard is used to lock cell references in a formula in Excel. When you create a formula with relative cell references (e.g., A1, B2, C3), you can use the "F4" key to toggle between different types of cell references: relative, absolute, and mixed references.
Pressing "ALT + SHIFT + RIGHT ARROW" in Excel will quickly group or outline the selected rows, allowing you to collapse and expand the grouped rows to show or hide the detailed data.
