Log In
Register
Home
Active Member
December 28, 2018
Offline
Hi all,
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.
Thanks,
Jay
July 16, 2010
Offline
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.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.
Mynda
VIP
April 21, 2015
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
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. 🙂
1 Guest(s)
