Aug 25, 2016 Learn about data analysis with Excel, see effective ways to use Excel to solve business problems, and explore data visualization tools in Excel. To simplify your tech training journey, we are consolidating our learning resources and retiring Microsoft Virtual Academy in phases, with the next phase finishing on April 30, 2019. Start Excel, then click Tools and look for Data Analysis and for Solver. If both are there, press Esc (escape) and continue with the respective assignment. Otherwise click Tools, Add-Ins, and check the boxes for Analysis ToolPak and for Solver, then click OK.
Welcome to
Introducing a new approach to learning
The skills required to advance your career and earn your spot at the top do not come easily. Now there’s a more rewarding approach to hands-on learning that helps you achieve your goals faster. Earn points, levels, and achieve more!
Start learning today
Up your game with a module or learning path tailored to today's developer and technology masterminds and designed to prepare you for industry-recognized Microsoft certifications.
![Excel Excel](/uploads/1/2/5/8/125858226/315155528.png)
Hands-on learning
Master core concepts at your speed and on your schedule. Whether you've got 15 minutes or an hour, you can develop practical skills through interactive training.
![Excel Excel](https://www.datapine.com/images/visual-drag-and-drop-interface.png)
Learn for free
When we say free, we mean it. Instant in-browser access to Microsoft tools and modules. No credit card required.
Learn Azure
Explore more advanced Azure topics with online courses.
Additional Azure training
Explore more ways to learn Azure with self-paced video courses provided free in partnership with Pluralsight and Microsoft Hands-on-labs to practice what you learn.
Learn Dynamics
Microsoft Dynamics 365 is a set of applications that are connected by data and intelligence. Use Dynamics 365 to unleash your organization’s potential.
Additional training
Partner eLearning resources to meet your learning needs and take your skills to the next level.
Learn Power Platform
Use PowerApps, Power BI, and Microsoft Flow to customize, extend, and build all the apps you need for your business and unlock the potential of Office 365 and Dynamics 365.
Additional training
Partner eLearning resources to meet your learning needs and take your skills to the next level.
Learn Windows Development
Start developing Windows applications.
Microsoft Learn is just the beginning
Start with the basics, then move to advanced methods that address real-world challenges. Microsoft Learn meets you where you are and takes you where you want to go.
Certifications
Jump-start your career and demonstrate your achievements through industry-recognized Microsoft certifications.
Instructor-led training
Sharpen your technology skills with in-depth, on-demand training in virtual classrooms led by Microsoft Certified Trainers.
More learning
Choose from a wide range of programs designed to fit your learning needs and help you take your IT skills and your career to the next level.
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.
To load the Analysis ToolPak add-in, execute the following steps.
1. On the File tab, click Options.
2. Under Add-ins, select Analysis ToolPak and click on the Go button.
3. Check Analysis ToolPak and click on OK.
4. On the Data tab, in the Analysis group, you can now click on Data Analysis.
The following dialog box below appears.
5. For example, select Histogram and click OK to create a Histogram in Excel.