Wall Street Prep: Excel Crash Course Formulas Explained | 100% Correct |Latest 2025/2026 Update.

Wall Street Prep: Excel Crash Course
i,- i,- i,- i,- i,- i,-




Formulas Explained | 100% Correct i,- i,- i,- i,- i,-




|Latest 2025/2026 Update. i,- i,-




EOMONTH Function Definition: A function that allows you to
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-



create monthly date headers. By outputting the last day of the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



specified month. i,- i,-




Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-



argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



would like to go from that start_date.
i,- i,- i,- i,- i,- i,-




EDATE Functioni,- Definition: Similar to EOMONTH but this i,-i,- i,- i,- i,- i,- i,- i,- i,-



return the exact date from the start-date, after the specified
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



number of months. i,- i,-




Explanation: Start by inputting the start_date into the first
i,- i,- i,- i,- i,- i,- i,- i,- i,-



argument. Then input how many months ahead or behind you
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



would like to go from that start_date.
i,- i,- i,- i,- i,- i,-




ISNUMBER Function Definition: A function that is useful
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-



criteria in IF Statements/Functions, and it is basically test to see if
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



a cell has a number in it.
i,- i,- i,- i,- i,- i,-

, Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



comes out to true or false.
i,- i,- i,- i,- i,-




ISTEXT Function Definition: A function that evaluates if there
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,- i,-



is text inside a cell and will output TRUE or FALSE depending on
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



the result. Also a useful criteria to add to IF statements/functions.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-




Explanation: Simply input value to check to see if value inputtedi,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



comes out to true or false.
i,- i,- i,- i,- i,-




YEARFRAC Function Definition: A function that return the
i,- i,-i,- i,- i,- i,- i,- i,- i,- i,-



proportion of the year between two given dates, the start_date
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



and the end_date. An optional basis parameter can be used do
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



represent the number of days per month/year used to calculate
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



the proportion of the year.
i,- i,- i,- i,-




Optional Basis Parameters: i,- i,-




1. 0 - or Omitted = U.S. 30/360
i,- i,- i,- i,- i,- i,- i,-




2. 1 - Actual/Actual
i,- i,- i,-




3. 2 - Actual/360
i,- i,- i,-




4. 3 - Actual/365
i,- i,- i,-




5. 4 - European 30/360
i,- i,- i,- i,-




Explanation: Simply input the start_date and the end_date with i,- i,- i,- i,- i,- i,- i,- i,- i,-



the desired basis argument and the function will output the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



proportion of the year between the two given dates. i,- i,- i,- i,- i,- i,- i,- i,-