Learn Advanced Excel – 3 Month Roadmap with Resources
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.
Technical Skills
Course
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.
Domain Skills
In Month 1, learn about your industry / domain by:
Project
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.
Technical Skills
Domain Skills
In Month 2, learn about your industry / domain by:
Project
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.
Technical Skills
Domain Skills
In Month 3, learn about your industry / domain by:
Project
In Month 3, here are a few projects you can try:
Got a question about this roadmap or have suggestions? Please share your thoughts in the comments section below.
The post Learn Advanced Excel – 3 Month Roadmap with Resources appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
