Topic: Analysis ToolPak

The following articles are available. Click the article's title (shown in bold) to see the associated article.

AutoFill with Random Numbers AutoFilling is a great tool in Excel; it allows you to place a wide range of values into cells. If you want to use it to add random numbers to a worksheet, you’ll be disappointed—Excel won’t do it. You can, however, use one of the tools available in the Analysis ToolPak to generate a whole bunch of random numbers. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Calculating Business Days Excel allows you to determine the number of work days (business days) between two dates by using the NETWORKDAYS worksheet function. This tip explains different ways you can immediately put the function to work. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Calculating Fractions of Years Excel provides, as part of the Analysis Toolpak, a worksheet function that can use to determine what percentage of a year is represented by the difference between two dates. This tip explains how to put this function to work. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Calculating Future Workdays Excel makes doing math with dates quite easy. This tip starts with the simplest of date math—adding a few days to a date. Things get more interesting when you want to calculate only weekdays or work days, but this tip explains how you can conquer that need, as well. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Converting Units Using the Analysis ToolPak for the vast conversions the CONVERT function in an Excel worksheet has availabile. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Finding the Analysis ToolPak Add-In The Analysis ToolPak is used to add some very handy worksheet functions to Excel. If you don’t have it installed, and you can’t find your original Microsoft Office discs, then you may be at a loss as to what you can do. Here’s some ideas. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Leap Years and Fiscal Periods If your fiscal period ends in February, and you need to calculate the date either a year in the past or the future, then you will run into the problem of how to deal with leap years. This tip explains some of the formulas and functions you can use to achieve the desired calculation. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Random Numbers in a Range The RANDBETWEEN function is a valuable worksheet function that allows you to generate a random number between some boundary values that you specify. This tip explains how to use the function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Restoring the Analysis ToolPak Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you delete the ToolPak files by accident, you may be looking for a way to get the add-in back where it belongs. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Rounding to the Nearest $50 Excel provides a worksheet function, MROUND, that allows you to round a value to the nearest multiple of a given rounding value. This tip explains how you can use this function to round to the nearest $50, but it also provides other formulas you can use if you don't want to use MROUND. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using the MROUND Worksheet Function Need to round to the nearest multiple of some value? The MROUND worksheet function can round to any nearest value you want to specify. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using the WEEKNUM Function The Analysis Toolpak includes the WEEKNUM function, which returns the week of the year in which a particular date falls. Understanding how the function works is important to interpreting its results. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using the XIRR Function The XIRR function is used to determine the rate of return with irregular payments. This tip explains how to use the function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

Problems with Dates?

Helpful Links

Great Info!

RSS Feeds