Decide Where to Start

Image Source

Quiz Questions

1.
If you had to join a group based on your expertise in Excel functions like IF, VLOOKUP and SUMIFS which group would you join?
Image Source
- A.
  The newbies
- B.
  The intermediates
- C.
  The experts
2.
Which version of Excel do you work with?
Image Source
- A.
  Office 365 subscription
- B.
  Office 2021
- C.
  Office 2019 or Office 2016
- D.
  Office 2013, 2010 or older
3.
Can you explain the difference between these formulas to another Excel user? =$A$1, =A1 and =A$1?
Image Source
- A.
  No. I'm not sure what the difference is.
- B.
  Yes. For sure.
4.
Do you know how to create the data bars in the Difference column?
Image Source
- A.
  No idea.
- B.
  Yes. Sparklines.
- C.
  Yes. Conditional Formatting.
- D.
  Yes. Number Formatting.
5.
Are you confident with Pivot Tables?
- A.
  Not really.
- B.
  Yes. Fully.
6.
What do you struggle most with right now?
- A.
  Understanding basic Excel functionality
- B.
  You need to create reports based on data from different places
- C.
  Clean data so it's in a structure you can report on
- D.
  Create interactive dashboards and charts in Excel
- E.
  Understanding the new formulas in Office 365 / Office 2021
- F.
  Automate report creation
7.
What do you struggle most with right now?
- A.
  Understanding basic Excel functionality
- B.
  You need to create reports based on data from different places
- C.
  Clean data so it's in a structure you can report on
- D.
  Create interactive dashboards and charts in Excel
- E.
  Automate report creation
8.
What do you struggle most with right now?
- A.
  Understanding basic Excel functionality
- B.
  Understanding Advanced Formulas
- C.
  Create interactive dashboards and Charts
- D.
  Automate tasks in Excel (cleaning and reporting data)

Quiz Outcomes

1.
Zero to Hero Learning Path (365/2021)
Excel Essentials for the Real World will give you the perfect start to mastering Excel.You'll find tons of practical, real-world examples so you can confidently understand the full potential of each feature. Once you're confident in the Essentials, I recommend you move on to Master Excel Functions in Office 365/2021 - that's because your Excel version has the newly released Microsoft functions like FILTER, XLOOKUP, SORT & UNIQUE. Calculations that used to be complex became super easy with these functions. This course will teach you to think outside the box and come up with easy creative solutions to your every day data analysis problems.After that start exploring the power side of Excel with our Power Query course. You don't have to take this course from start to finish. In the first stage it's enough if you cover the Power Query Essentials module (sections 1-13) . You can go to the advanced modules later on.Then go ahead and move on to the PowerPivot and DAX course. Again, here I recommend you complete the Essentials module first (sections 1-9). After that it depends on your tasks: If you work with interactive reports and charts, go on to the Dashboards and the charts courses. If you're interested to learn advanced Excel tips and formulas, move on to the Advanced Excel course. If you're interested in automation and learning about macros and VBA, start with Unlock Excel VBA and macros course. If you handle lots of data sets and need to create reports from multiple data sources, move on to the advanced sections of Power Query and Power Pivot courses.In summary your recommended path:1. Excel Essentials for the Real World2. Master Excel Functions in Office 3653. Master Excel Power Query (Essentials Module)4. Master Power Pivot & DAX (Essentials Module)5. Visually Effective Excel Dashboards & Excel Charts6. Advanced Excel - Top 10 Excel Tips & Formulas7. Power automation with Power Query (Remaining Modules) / Power Pivot (Remaining Modules) and Unlock Excel VBA & Macros
2.
Zero to Hero Learning Path (Excel 2016/2019)
Excel Essentials for the Real World will give you the perfect start to mastering Excel.You'll find tons of practical, real-world examples so you can confidently understand the full potential of each feature. After that start exploring the power side of Excel with our Power Query course. You don't have to take this course from start to finish. In the first stage it's enough if you cover the Power Query Essentials module (sections 1-13) . You can go to the advanced modules later on.Then go ahead and move on to the PowerPivot and DAX course. Again, here I recommend you complete the Essentials module first (sections 1-9). This way you'll be ahead of the curve.After that it depends on your tasks: If you work with interactive reports and charts, go on to the Dashboards and the charts courses. If you're interested to learn advanced Excel tips and formulas, move on to the Advanced Excel course. If you're interested in automation and learning about macros and VBA, start with Unlock Excel VBA and macros course. In case you handle lots of data sets and need to create reports from multiple data sources, move on to the advanced sections of Power Query and Power Pivot courses.In summary:1. Excel Essentials for the Real World2. Master Excel Power Query (Essentials Module)3. Master Power Pivot & DAX (Essentials Module)4. Visually Effective Excel Dashboards & Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Power automation with Power Query (Remaining Modules) / Power Pivot (Remaining Modules) and Unlock Excel VBA & Macros
3.
Zero to Hero Learning Path (Excel <=2013)
Excel Essentials for the Real World will give you the perfect start to mastering Excel. With the exception of a few features that will not be available in your Excel version, everything else will be the same. After that, you can move on to the Advanced Excel course - specially if you work with complex data analysis and need to learn advanced techniques to get your tasks done quickly.In case you need to create interactive Excel dashboards, you can then move on to the Dashboards course. If you're responsible for creating charts and visualizations, move on to the charts course.If you find yourself repeating tasks over and over again in Excel - whether it has to do with data cleaning or creating Excel reports, then you need to move on to the Unlock Excel VBA and macros course. There you'll learn how to create and write macros that automate boring tasks in Excel. Anything can be automated as long as there is some sort of logic to the process.Once you upgrade to Excel 2016 or Office 365, make sure you start the two power courses:Power Query and PowerPivot and DAX course. In summary your learning path for now is:1. Excel Essentials for the Real World2. Advanced Excel - Top 10 Excel Tips & Formulas 3. Visually Effective Excel Dashboards 4. Excel Charts5. Unlock Excel VBA & Macros
4.
Fill in the Gaps Learning Path (365/2021)
YAY! You're familiar with Excel. It doesn't feel like "home" yet. On some days you struggle getting Excel do what you want.Your job will get a lot easier once you fill in the gaps.I recommend you start with Excel Essentials for the Real World. I know you're not a beginner, but we've had Excel users with over 10 years of experience who found a lot of new tips and techniques in that course.You can skip sections (specially the first one) and complete the quizzes and challenges to see if you missed anything important. Download the course notes and review the key takeaways.Once you're happy with your progress, I recommend you move on to Master Excel Functions in Office 365/2021 - that's because your Excel version has the newly released Microsoft functions like FILTER, XLOOKUP & SORT. This course will teach you to think outside the box and come up with easy creative solutions to your every day data analysis problems.After that start exploring the power side of Excel with our Power Query course. You don't have to take this course from start to finish. In the first stage it's enough if you cover the Power Query Essentials module (sections 1-13) . You can go to the advanced modules later on.Then go ahead and move on to the PowerPivot and DAX course. Again, here I recommend you complete the Essentials module first (sections 1-9). After that it depends on your tasks: If you work with interactive reports and charts, go on to the Dashboards and the charts courses. If you're interested to learn advanced Excel tips and formulas, move on to the Advanced Excel course. If you're interested in automation and learning about macros and VBA, start with Unlock Excel VBA and macros course. You need to create reports from multiple data sources? Then move on to the advanced sections of Power Query and Power Pivot courses.In summary:1. Excel Essentials for the Real World2. Master Excel Functions in Office 3653. Master Excel Power Query (Essentials Module)4. Master Power Pivot & DAX (Essentials Module)5. Visually Effective Excel Dashboards & Excel Charts6. Advanced Excel - Top 10 Excel Tips & Formulas7. Power automation with Power Query (Remaining Modules) / Power Pivot (Remaining Modules) and Unlock Excel VBA & Macros
5.
Fill in the Gaps Learning Path (Excel 2016/2019)
YAY! You're familiar with Excel. It doesn't feel like "home" yet. On some days you struggle getting Excel do what you want.Your job will get a lot easier once you fill in the gaps.I recommend you start with Excel Essentials for the Real World. I know you're not a beginner, but we've had Excel users with over 10 years of experience who found a lot of new tips and techniques in that course.You can skip sections (specially the first one) and complete the quizzes and challenges to see if you missed anything important. Download the course notes and review the key takeaways.After that start exploring the power side of Excel with our Power Query course. You don't have to take this course from start to finish. In the first stage it's enough if you cover the Power Query Essentials module (sections 1-13) . You can go to the advanced modules later on.Then go ahead and move on to the PowerPivot and DAX course. Again, here I recommend you complete the Essentials module first (sections 1-9). After that it depends on your tasks: If you work with interactive reports and charts, go on to the Dashboards and the charts courses. If you're interested to learn advanced Excel tips and formulas, move on to the Advanced Excel course. If you're interested in automation and learning about macros and VBA, start with Unlock Excel VBA and macros course. You handle lots of data sets? Then move on to the advanced sections of Power Query and Power Pivot courses.In summary:1. Excel Essentials for the Real World2. Master Excel Power Query (Essentials Module)3. Master Power Pivot & DAX (Essentials Module)4. Visually Effective Excel Dashboards & Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Power automation with Power Query (Remaining Modules) / Power Pivot (Remaining Modules) and Unlock Excel VBA & Macros
6.
Fill in the Gaps Learning Path (Excel <=2013)
YAY! You're familiar with Excel. It doesn't feel like "home" yet. On some days you struggle getting Excel do what you want.Your job will get a lot easier once you fill in the gaps.I recommend you start with Excel Essentials for the Real World. I know you're not a beginner, but we've had Excel users with over 10 years of experience who found a lot of new tips and techniques in that course.You can skip sections (specially the first one) and complete the quizzes and challenges to see if you missed anything important. Be aware there are some features covered in that course that apply to newer versions of Excel, but basic formulas and features haven't changed. Once you're happy with your progress, I recommend you can move on to the Advanced Excel course - specially if you work with complex data analysis.In case you need to create interactive Excel dashboards, you can then move on to the Dashboards course. If you're responsible for creating charts and visualizations, check out the charts course.If you find yourself repeating tasks over and over again in Excel - whether it has to do with data cleaning or creating Excel reports, then you need to move on to the Unlock Excel VBA and macros course. There you'll learn to create and write macros that automate boring tasks in Excel. Anything can be automated as long as there is some sort of logic to the process.Once you upgrade to Excel 2016 or Office 365, make sure you start the two power courses:Power Query and PowerPivot and DAX course. In summary your learning path for now is:1. Excel Essentials for the Real World2. Advanced Excel - Top 10 Excel Tips & Formulas 3. Visually Effective Excel Dashboards4. Excel Charts5. Unlock Excel VBA & Macros
7.
Power Excel Path (Power Pivot then Power Query)
Congratulations! You know your way around Excel 🙌🏼. It's time to get to know the Power side of Excel well too! With that power you'll be able to quickly create reports from large messy data.I suggest you start with the PowerPivot and DAX course. You'll learn how to best combine data from different places and create a professional data model in Excel. You can then move on to the Power Query course.Since your Excel version has the newer Excel functions like FILTER, XLOOKUP and UNIQUE, I suggest you then go through the Master Excel Functions in Office 365/2021 course. You'll be able to combine your Power Pivot reports with the new functions to create interactive reports. Whenever you'd like a refresher drop by Excel Essentials for the Real World. You can download the key takeaways, have a go at the quizzes and challenges to test your knowledge. If you'd like to add interactivity to your reports, move on to the Dashboards and the charts courses. If you find yourself needing to learn more advanced functions like OFFSET and SUMPRODUCT, go through the Advanced Excel course. You might want to automate parts of your processes. If you'd like to learn macros and VBA, check out the Unlock Excel VBA and macros course.In summary:1. Master Power Pivot & DAX2. Master Excel Power Query3. Master Excel Functions in Office 3654. Visually Effective Excel Dashboards & Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Unlock Excel VBA & Macros
8.
Power Excel Path (Power Query then Power Pivot)
Congratulations! You know your way around Excel 🙌🏼. It's time to get to know the Power side of Excel well too! With that power you'll be able to quickly clean messy data so it's in a structure you can easily create reports on.I suggest you start with the Power Query course. You'll learn different tricks to quickly clean messy data so you can make sense of it. If you need to combine related data from different places and create reports then move on to the PowerPivot and DAX course. There you'll learn how to best combine data from different places and create a professional data model in Excel. Since your Excel version has the newer Excel functions like FILTER, XLOOKUP and UNIQUE, I suggest you go through the Master Excel Functions in Office 365/2021 course as well. You could combine your Power Pivot results with the new functions to create interactive reports. Whenever you'd like a refresher drop by Excel Essentials for the Real World. You can download the key takeaways, take part in the challenges and the quizzes to test your knowledge. If you'd like to add interactivity to your reports, go on to the Dashboards and the charts courses. If you find yourself needing to learn more advanced functions like OFFSET and SUMPRODUCT, go through the Advanced Excel course. You might want to automate parts of your processes. If you'd like to learn macros and VBA, check out the Unlock Excel VBA and macros course.In summary:1. Master Excel Power Query2. Master Power Pivot & DAX3. Master Excel Functions in Office 3654. Visually Effective Excel Dashboards & Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Unlock Excel VBA & Macros
9.
Get Better at Creating Dashboards
It looks like you can immediately jump to the Visually Effective Excel Dashboards Course! This course covers more than just interactive reports. You'll be able to handle complex situations with advanced formulas. You'll also be able to create impressive visualizations with advanced chart techniques and tricks.There are two steps when it comes to creating interactive dashboards:1. Get the data in the right format so your dashboard is easily setup2. Learn cool techniques to add interactivity to the dashboardYou get to cover both of these with the Dashboards course. Once you've completed that, move on to the PowerPivot and DAX course. Here you'll learn how to combine big data from different files and create impressive pivot-table-based dashboards. We have two dashboard milestones in this course. Make sure you check them out.Go on to the charts course to discover new visualization ideas you can add to your dashboards. The Master Excel Functions in Office 365/2021 course will introduce you to the newer Excel functions you can use to better prepare your data for your dashboards. Finally if you'd like to automate the data import process and creation of the reports, I suggest you move on to the Power Query course followed by the Unlock Excel VBA and macros course.In summary:1. Visually Effective Excel Dashboards2. Master Power Pivot & DAX3. Excel Charts4. Master Excel Functions in Office 3655. Master Excel Power Query6. Unlock Excel VBA & Macros
10.
Stay on the cutting edge
Congratulations! You know your way around Excel 🙌🏼. Problem is Excel keeps changing and evolving and you're starting to feel a bit behind. Since your Excel version has all the newer functions Microsoft released in the recent past, best would be to start with the course: Master Excel Functions in Office 365/2021. This will quickly get you up to speed with the new functions like FILTER, XLOOKUP, SORT, SEQUENCE and UNIQUE.New formulas aren't the only thing Excel's got recently. There's also the Power side of it. Many people hesitated learning Power Query because they thought it's for Excel pros, but in fact it's a Power tool for EVERYONE. Since you know your way around Excel already, learning Power Query will be very easy for you. Once you've completed the Power Query course you can move on to the PowerPivot and DAX course. In summary:1. Master Excel Functions in Office 3652. Master Excel Power Query3. Master Power Pivot & DAXAfter that it's up to you. You can improve your dashboard and charting skills with our Dashboards and charts courses or add more automation to your reports with the Unlock Excel VBA and macros course.
11.
Automate Your Work
Congratulations! You know your way around Excel 🙌🏼.You just wished you could automate a lot of your tasks. Automation can be achieved in different ways depending on the part of the process you want to automate. If you'd like to automate the preparation of data. For example cleaning and combining data, I suggest you start with the Power Query course. You'll get lots of ideas on how to improve the collection and preparation of your data. In case you deal with related data coming in from different places and you need to combine these to create reports, then move on to the PowerPivot and DAX course. If you'd like to use better formulas to automate your data analysis, move on to Master Excel Functions in Office 365/2021 and then to the Advanced Excel course. Once you find yourself reaching the limits of what's possible to automate with these tools, then you'll benefit from the Excel VBA & Macros Course. Since you have advanced Excel knowledge (by this time for sure), you're ready to learn to code. Which means you get to create automated applications that aren't possible with standard Excel features.In summary:1. Master Excel Power Query2. Master Power Pivot & DAX3. Master Excel Functions in Office 3654. Advanced Excel 5. Unlock Excel VBA & MacrosIf you'd like to learn about dynamic dashboards and using better visualizations in your reports, check out the Dashboards and charts courses too.
12.
Power Excel Path (Power Pivot then Power Query)
Congratulations! You know your way around Excel 🙌🏼. It's time to get to know the Power side of Excel well too! With that power you'll be able to quickly create reports from large messy data.I suggest you start with the PowerPivot and DAX course. You'll learn how to best combine data from different places and create a professional data model in Excel. You can then move on to the Power Query course.Whenever you'd like a refresher drop by Excel Essentials for the Real World. You can download the key takeaways, have a go at the quizzes and challenges to test your knowledge. If you'd like to add interactivity to your reports, move on to the Dashboards and the charts courses. If you find yourself needing to learn more advanced functions like OFFSET and SUMPRODUCT, go through the Advanced Excel course. You might want to automate parts of your processes. If you'd like to learn macros and VBA, check out the Unlock Excel VBA and macros course.In summary:1. Master Power Pivot & DAX2. Master Excel Power Query3. Visually Effective Excel Dashboards4. Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Unlock Excel VBA & Macros
13.
Power Excel Path (Power Query then Power Pivot)
Congratulations! You know your way around Excel 🙌🏼. It's time to get to know the Power side of Excel well too! With that power you'll be able to quickly clean messy data so it's in a structure you can easily create reports on.I suggest you start with the Power Query course. You'll learn different tricks to quickly clean messy data so you can make sense of it. If you need to combine related data from different places and create reports then move on to the PowerPivot and DAX course. There you'll learn how to best combine data from different places and create a professional data model in Excel. Whenever you'd like a refresher drop by Excel Essentials for the Real World. You can download the key takeaways, take part in the challenges and the quizzes to test your knowledge. If you'd like to add interactivity to your reports, go on to the Dashboards and the charts courses. If you find yourself needing to learn more advanced functions like OFFSET and SUMPRODUCT, go through the Advanced Excel course. You might want to automate parts of your processes. If you'd like to learn macros and VBA, check out the Unlock Excel VBA and macros course.In summary:1. Master Excel Power Query2. Master Power Pivot & DAX3. Visually Effective Excel Dashboards4. Excel Charts5. Advanced Excel - Top 10 Excel Tips & Formulas6. Unlock Excel VBA & Macros
14.
Get Better at Creating Dashboards
It looks like you can immediately jump to the Visually Effective Excel Dashboards Course! This course covers more than just interactive reports. You'll be able to handle complex situations with advanced formulas. You'll also be able to create impressive visualizations with advanced chart techniques and tricks.There are two steps when it comes to creating interactive dashboards:1. Get the data in the right format so your dashboard is easily setup2. Learn cool techniques to add interactivity to the dashboardYou get to cover both of these with the Dashboards course. Once you've completed that, move on to the PowerPivot and DAX course. Here you'll learn how to combine big data from different files and create impressive pivot-table-based dashboards. We have two dashboard milestones in this course. Make sure you check them out.Go on to the charts course to discover new visualization ideas you can add to your dashboards. Finally if you'd like to automate the data import process and creation of the reports, I suggest you move on to the Power Query course followed by the Unlock Excel VBA and macros course.In summary:1. Visually Effective Excel Dashboards2. Master Power Pivot & DAX3. Excel Charts4. Master Excel Power Query5. Unlock Excel VBA & Macros
15.
Automate Your Work
Congratulations! You know your way around Excel 🙌🏼.You just wished you could automate a lot of your tasks. Automation can be achieved in different ways depending on the part of the process you want to automate. If you'd like to automate the preparation of data. For example cleaning and combining data, I suggest you start with the Power Query course. You'll get lots of ideas on how to improve the collection and preparation of your data. In case you deal with related data coming in from different places and you need to combine these to create reports, then move on to the PowerPivot and DAX course. If you'd like to use advanced formulas to automate your data analysis, move on to the Advanced Excel course. Once you find yourself reaching the limits of what's possible to automate with these tools, then you'll benefit from the Excel VBA & Macros Course. Since you have advanced Excel knowledge (by this time for sure), you're ready to learn to code. Which means you get to create automated applications that aren't possible with standard Excel features.In summary:1. Master Excel Power Query2. Master Power Pivot & DAX3. Advanced Excel 4. Unlock Excel VBA & MacrosIf you'd like to learn about dynamic dashboards and using better visualizations in your reports, check out the Dashboards and charts courses too.
16.
Become an Excel Pro
Congratulations! You know your way around Excel 🙌🏼.It's time to become an Excel pro! Jump in to the Advanced Excel course to master important Excel features and functions. Whenever you'd like a refresher drop by Excel Essentials for the Real World. I know you're not a beginner, but we've had Excel users with over 10 years of experience who found a lot of new tips and techniques in that course.You can skip sections (specially the first one) and complete the quizzes and challenges to see if you missed anything important. Be aware there are some features covered in that course that apply to newer versions of Excel, but basic formulas and features haven't changed. If you find you've reached the limit of what you can achieve with Excel formulas and you find yourself repeating tasks over and over again in Excel - whether it has to do with data cleaning or creating Excel reports, then you need to move on to the Unlock Excel VBA and macros course. There you'll learn to create and write macros that automate boring tasks in Excel. Anything can be automated as long as there is some sort of logic to the process.In case you need to create interactive Excel dashboards, you can then move on to the Dashboards course. If you're responsible for creating charts and visualizations, check out the charts course.Remember once you upgrade to Excel 2016 or Office 365, make sure you start the two power courses:Power Query and PowerPivot and DAX course. In summary your learning path for now is:1. Advanced Excel - Top 10 Excel Tips & Formulas 2. Unlock Excel VBA & Macros 3. Visually Effective Excel Dashboards4. Excel Charts
17.
Get Better at Creating Dashboards
It looks like you can immediately jump to the Visually Effective Excel Dashboards Course! This course covers more than just interactive reports. You'll be able to handle complex situations with advanced formulas. You'll also be able to create impressive visualizations with advanced chart techniques and tricks.There are two steps when it comes to creating interactive dashboards:1. Get the data in the right format so your dashboard is easily setup2. Learn cool techniques to add interactivity to the dashboardYou get to cover both of these with the Dashboards course. Then move on to the charts course to discover new visualization ideas you can add to your dashboards. Dynamic charts require a good data preparation table. To get that you might need to use advanced Excel functions. You'll learn those in the the Advanced Excel course.Finally if you'd like to automate the data import process and creation of the reports, I suggest you move on to the Unlock Excel VBA and macros course.In summary:1. Visually Effective Excel Dashboards2. Excel Charts3. Advanced Excel - Top 10 Excel Tips & Formulas 4. Unlock Excel VBA & MacrosRemember once you upgrade to Excel 2016 or Office 365, make sure you start the two power courses:Power Query and PowerPivot and DAX course.
18.
Automate Your Work
Congratulations! You know your way around Excel 🙌🏼.You just wished you could automate a lot of your tasks. Automation can be achieved in different ways depending on the part of the process you want to automate. If you'd like to use better formulas to automate your data analysis, start with the Advanced Excel course. Once you find yourself reaching the limits of what's possible with formulas, then you'll benefit from the Excel VBA & Macros Course. Since you have advanced Excel knowledge (by this time for sure), you're ready to learn to code. Which means you get to create automated applications that aren't possible with standard Excel features.In summary:1. Advanced Excel - Top 10 Excel Tips & Formulas 2. Unlock Excel VBA & MacrosIf you'd like to learn about dynamic dashboards and using better visualizations in your reports, check out the Dashboards and charts courses too. Remember once you upgrade to Excel 2016 or Office 365, make sure you start the two power courses:Power Query and PowerPivot and DAX course.

Decide Where to Start

Answer these questions and get your customized learning path. It takes less than a minute.

Quiz Questions

Quiz Outcomes