I love using formulas in Excel. They are the heartbeat of a spreadsheet.
They turn a static spreadsheet into a dynamic and interactive spreadsheet that can make decisions, change over time, and react to user requests.
Excel has many tools now to create powerful reports including Power Query, VBA, and Power Pivot. However, formulas are still the heartbeat of a smart spreadsheet.
Many users learn to use a function to complete a specific task at work. And they will often learn this from a colleague or from a Google (or Bing) ...