Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
Excel Function A predefined formula used to perform calculations
efficiently using inputs called arguments.
Function Arguments Inputs inside a function (numbers, references, or
formulas) that determine the output.
OFFSET Returns a reference to a cell or range shifted by a
specified number of rows and columns from a
starting point.
CHOOSE Returns a value from a list based on an index
number; commonly used for scenario switching.
Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
, Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
MIN Returns the smallest value in a range.
Form Controls Interactive Excel tools (e.g., check box, combo
box, scroll bar) used to adjust inputs dynamically.
Check Box Form control that toggles TRUE/FALSE input.
Combo Box Dropdown selector allowing users to pick from a
list of options.
Scroll Bar Form control used to adjust a value within a
defined range.
Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
Excel Function A predefined formula used to perform calculations
efficiently using inputs called arguments.
Function Arguments Inputs inside a function (numbers, references, or
formulas) that determine the output.
OFFSET Returns a reference to a cell or range shifted by a
specified number of rows and columns from a
starting point.
CHOOSE Returns a value from a list based on an index
number; commonly used for scenario switching.
Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
, Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
MIN Returns the smallest value in a range.
Form Controls Interactive Excel tools (e.g., check box, combo
box, scroll bar) used to adjust inputs dynamically.
Check Box Form control that toggles TRUE/FALSE input.
Combo Box Dropdown selector allowing users to pick from a
list of options.
Scroll Bar Form control used to adjust a value within a
defined range.
Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf Excel & Financial Modeling_ Key Concepts and Frameworks.pdf
