From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Exploring the Analysis ToolPak

Exploring the Analysis ToolPak - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Exploring the Analysis ToolPak

If you watch some of the other movies in this chapter on data analysis, you saw that Excel has some pretty good tools to help you look at different possibilities and make decisions. What I want to do now is give you just a brief overview of a free add-in that comes with Excel called the Analysis ToolPak. If data analysis is something you need to do a lot of, you'll want to explore the ToolPak because it kicks these features up to a whole new level. We won't go into a lot of detail in this movie, but I want you to see what's there. But before we use it we have to enable it, because it's a plug-in. So, go up to the File tab to get into Backstage view and down here towards the bottom click Options. And on the left we have all the different categories of options. Let's click Add-Ins down towards the bottom. Now, if you see the Analysis ToolPak here listed under Active, you don't have to enable it because it's already active. But you should see it over here under Inactive Applications…

Contents