December 28, 2018
I am at a beginner in excel (even I don't know many shortcut keys in Excel)
I am looking to become an expert in Excel, VBA & Micro, Power BI.
for this, I know that tons of data available to learn but it is very confusing and looking like a never-ending process.
It would be great if someone can share a systematic approach to learn all parts.
Also, please guide topics which I should start learning in details.
July 16, 2010
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.myonlinetraininghu.....rt-upgrade
The next thing I would master is Power Query (https://www.myonlinetraininghu.....ery-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.myonlinetraininghu.....vot-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.myonlinetraininghu.....-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.
April 21, 2015
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).
November 1, 2018