How to Install Analysis Toolpak/DataDiff Function for Excel 2010

0

Microsoft Office 2007 LogoImage via Wikipedia

The Analysis Toolpak provides data analysis tools for statistical and engineering analysis. It is possible to use the built-in statistical, financial, and engineering worksheet functions. But some are only available when you install the Analysis ToolPak. This article will show you how to install it.

You can perform addition & subtraction operations on dates.When you type date it will convert the date as per the regional settings of your computer you can play safe by typing dates as mmdddyy10oct09.If you want to calculate difference of dates for the intervals of months or years or even days over months and months over year you have a function DATEDIF which you can use

  1. Click the File ( Microsoft Office 2007) Button, and then click Excel Options button on the bottom of the window. Excel_1
  2. Click the Add-Ins category on the left panel. Excel_2
  3. On the right panel of Excel Options, in the Manage box, choose Excel Add-ins, and then click Go button. Excel_3
  4. In the Add-Ins dialog box, under Add-Ins available box, check the check box next to Analysis Toolpak and Analysis ToolPak-VBA, and then click OK button. Excel_4
  5. In the pop-up dialog box, click Yes button to install it.
  6. Just wait for some time. After Excel have configured it, then you can use the Analysis Toolpak .   Excel7

 

For more  coverage on iHelplounge:

 

My Facebook My Twitter My YouTubeMy TechnoratiMy Flickr  

 

Follow us on Twitter, subscribe to our Facebook Page, find us on LinkedIn, circle us on Google+