Roadmap with Resources
This roadmap is for anyone interested in learning Advanced Excel Skills for Data Analysis or Reporting work. Follow this roadmap if you:
This month focus on how to get, clean & manage data within Excel. The key learning objectives will be how to use Power Query, Tables, Data management features and how to perform simple "Exploratory Data Analysis" with Excel.
If you need step-by-step course with clear examples, sample files and downloadable materials to teach you advanced Excel & dashboard reporting, please check out my Excel School program.
This comprehensive online class will teach you everything mentioned in this roadmap + more.
In Month 1, learn about your industry / domain by:
In Month 1, You can do a simple project to implement all the skills you have learned.
This month learn how to analyze the data by asking right questions, using formulas + pivot tables to answer them. Learn how to highlight important points and information with conditional formatting and how to make interactive analysis with slicers & data validation.
In Month 2, learn about your industry / domain by:
In Month 2, You can do a simple project to implement all the skills you have learned.
This month build skills to present your data. Understand how various charts work, how to create and customize them, how to make them interactive and how to lay them out. Learn when to "not" use charts. Build verbal and written communication skills to share your insights with others.
In Month 3, learn about your industry / domain by:
In Month 3, here are a few projects you can try:
Learn all the Advanced Excel Skills in one place with my Excel School Program. Rated 5 stars ⭐⭐⭐⭐⭐ by more than 10,000 students, this course will give you everything you need to be successful in workplace.
Got a question about this roadmap or have suggestions? Please share your thoughts in the comments section below.
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
© All rights reserved.
One Response to “Learn Advanced Excel – 3 Month Roadmap with Resources”
Im hungry to learn Power Bi advance excel with VBA and SQL as well. how I can learn with in 2 months. Because my company Kick on my ass.. so, Now I'm available to learn... 24/7.
I have basic knowledge about the Excel. But this is not much.. to became a analyst.
Waiting for your reply..
Thanks buddy for making all the videos i m damm fan of yours...