https://www.stuvia.com/user/allatopnotch
Wall Street Prep_ Excel.pdfhttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
Wall Street Prep: Excel
=AND() - ANS-True if all arguments are true
=CHOOSE() - ANS-index of value you want and then manually input cells
=COLUMN() and =ROW() - ANS-Can be used with indirect to be dynamic
=DATE() - ANS-Put in specific numbers and spits out date w/o serial number
=EDATE() - ANS-Gives exact date from specific start date
=EOMONTH() - ANS-Gives date at end of month from specific start date
=HLOOKUP() - ANS-(look up value, table range, row #)
=IF() - ANS-Condition, output for true, output for false
=IFERROR() - ANS-If there is an error, then a certain output is given
=IFS() - ANS-Better than nested IF, last argument is TRUE
=INDEX() - ANS-enter table range and then R&C of what you want; static
=INDIRECT() - ANS-Use with concatenation; put a cell in quotes and it returns value for you
=ISNUMBER() and =ISTEXT() - ANS-Determines if cell has numbers or text in it; if yes, certain
output is given, if not same thing; embedded in =IF()
=MATCH() - ANS-Relative position of an item in an array that matches a lookup value; use 0 at
end
=OFFSET() - ANS-start with reference point, then put in how many R&C you want to go down
=OR() - ANS-True if one of more arguments are true
=SUM() - ANS-Sums values; alt = is shortcut
=VLOOKUP() - ANS-(look up value, table range, column #); when using words add 0 to end
=YEARFRAC() - ANS-Percentage of year between two dates
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
Wall Street Prep_ Excel.pdfhttps://www.stuvia.com/user/allatopnotch
Wall Street Prep_ Excel.pdfhttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
Wall Street Prep: Excel
=AND() - ANS-True if all arguments are true
=CHOOSE() - ANS-index of value you want and then manually input cells
=COLUMN() and =ROW() - ANS-Can be used with indirect to be dynamic
=DATE() - ANS-Put in specific numbers and spits out date w/o serial number
=EDATE() - ANS-Gives exact date from specific start date
=EOMONTH() - ANS-Gives date at end of month from specific start date
=HLOOKUP() - ANS-(look up value, table range, row #)
=IF() - ANS-Condition, output for true, output for false
=IFERROR() - ANS-If there is an error, then a certain output is given
=IFS() - ANS-Better than nested IF, last argument is TRUE
=INDEX() - ANS-enter table range and then R&C of what you want; static
=INDIRECT() - ANS-Use with concatenation; put a cell in quotes and it returns value for you
=ISNUMBER() and =ISTEXT() - ANS-Determines if cell has numbers or text in it; if yes, certain
output is given, if not same thing; embedded in =IF()
=MATCH() - ANS-Relative position of an item in an array that matches a lookup value; use 0 at
end
=OFFSET() - ANS-start with reference point, then put in how many R&C you want to go down
=OR() - ANS-True if one of more arguments are true
=SUM() - ANS-Sums values; alt = is shortcut
=VLOOKUP() - ANS-(look up value, table range, column #); when using words add 0 to end
=YEARFRAC() - ANS-Percentage of year between two dates
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
Wall Street Prep_ Excel.pdfhttps://www.stuvia.com/user/allatopnotch
