1
00:00:00,066 --> 00:00:00,999


2
00:00:01,000 --> 00:00:06,500
Hello, and welcome to a video on how to install the data analysis tool pack in Excel.

3
00:00:06,500 --> 00:00:07,866


4
00:00:07,866 --> 00:00:14,266
First, you'll want to make sure you don't already have it. If you navigate to your data tab on your ribbon,

5
00:00:14,266 --> 00:00:14,799


6
00:00:14,800 --> 00:00:20,933
there should be an option that says data analysis under a little spot that says

7
00:00:20,933 --> 00:00:27,199
analysis. If you don't have this, then you need to install the data analysis tool pack.

8
00:00:27,200 --> 00:00:30,466


9
00:00:30,466 --> 00:00:36,999
To do that, you'll go to File, Options,

10
00:00:37,000 --> 00:00:38,733


11
00:00:38,733 --> 00:00:43,699
Add-ins, and then where it says Manage Excel Add-ins, you'll click Go,

12
00:00:43,700 --> 00:00:46,666


13
00:00:46,666 --> 00:00:51,499
now select Analysis tool pack. Not the VBA one, just the regular one,

14
00:00:51,500 --> 00:00:52,833


15
00:00:52,833 --> 00:00:58,899
and click OK. You may need to restart Excel to see the changes, but now you

16
00:00:58,900 --> 00:01:04,966
should have a data analysis button in your data ribbon. All

17
00:01:04,966 --> 00:01:08,632
right, that's it. Have a wonderful day, and have fun learning Excel!