These 5 Excel functions are silently slowing down your spreadsheets — use these instead

These 5 Excel functions are silently slowing down your spreadsheets — use these instead
https://www.makeuseof.com/excel-functions-to-use-instead-of-volatile-functions/

• The NOW function
  Log time without triggering endless recalculations
• The OFFSET function
  Dynamic ranges shouldn’t come with a performance penalty
• The INDIRECT function
  It’s better when Excel can see what depends on what
• The RAND / RANDBETWEEN Function
  Random is good, but constant recalculation isn’t