Hi Jay,

Becoming an expert in Excel is a long process. I recommend you focus on one area at a time. A good place to start is with an Excel course that will bring your skills up to speed and also include some advanced topics. For that you can consider our Excel Expert course: https://www.myonlinetraininghub.com/excel-expert-upgrade

The next thing I would master is Power Query ( https://www.myonlinetraininghub.com/excel-power-query-course) . Power Query can automate a lot of the data gathering and cleaning tasks we used automate with VBA, but it’s much quicker and easier to learn.

Then I'd learn Power Pivot ( https://www.myonlinetraininghub.com/power-pivot-course), which allows Excel to work with big data spread across multiple tables like a relational database.
 
Once you've mastered Power Query and Power Pivot you'll be ready for Power BI ( https://www.myonlinetraininghub.com/power-bi-course), as Power BI uses those tools too.

After that I'd think about learning VBA and Macros.

I hope that gives you some direction for your Excel learning journey.

Mynda

In addition to Mynda´s advice I would say: practice, practice, practice!

I hope you have a working place where you can use Excel, because that'll help a lot. Solving the all day problems and difficulties and finding solutions for things that come up. Using the Forum here to look for directions or using the tutorials you can find here at MOTH and elsewhere on the internet (for instance at John Acampora's Excel Campus or at Dave and Lisa Bruns' Exceljet).

Good luck!

Frans

I'd also suggest that you are correct in your observation that it is a never-ending process. Excel as a product is constantly evolving and your chances of being an expert at all of it are really quite slim. I've yet to come across anyone who is. 🙂