How do I become an expert in Excel?

Data Science, AI and ML
,
#1

Some major things:

  • Expertise in VBA - to do tasks that Excel otherwise can’t handle.
  • Expertise in Array formulae - which open up the world of complex analysis.
  • Ability to use more sophisticated, efficient lookup-type functions (e.g. INDEX/MATCH, INDIRECT etc etc)
  • Ability to pull in really extensive data sets and run calculations efficiently across them, i.e. set the calculations up for efficiency using the fundamentals that underpin major database programs etc.
  • Ability to link automatically to other sources (for example, undertake web scraping directly from Excel without the need for manual intervention).