1. If you could choose one financial metric to assess a stock, what would it be?
  • P/E — market capitalization(value of the company)/earnings
  • Free cash flow — available cash flows for companies to spend e.g. dividends, pay debt.




  • find the match you want and return the row where the result is at.
  • provide the formula with the row and column and it will search through the array table and return the results.
  • count all cells that are not empty
  • gets the last data
  • equivalent to a leftward V-lookup
  • used to search first/last data by specifying how you want to search from. ie. top to bottom or bottom to top
  • Lets say you want to search for the name “Rick” from “McGee, Rick”,
    type “*, “&Rick
  • * means…

My Personal Learning

Some beautiful paths can’t be discovered without getting lost.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store