Contents
The Power Utility Pak for Excel  is a collection of utilities that virtually every user of Microsoft Excel for Windows can put to use immediately -- and use on a daily basis.

For specific information, select a help topic below.

Overview:

A description of what's included in the Power Utility Pak.

The Utilities:

Complete instructions for using each of the utilities included in the package.

New Worksheet Functions:

How to use the new Power Utility Pak worksheet functions.

Enhanced Shortcut Menus:

About the new commands available on the shortcut menus that appear when you right-click an object.

Configuring the Power Utility Pak:

Instructions for configuring the Power Utility Pak.

Technical Support:

How to get help if you need it.

Technical Information:

For technically-minded users, a description of how the Power Utility Pak works.


Overview

The Power Utility Pak is an add-in that works in conjunction with Microsoft Excel 5.0 or later. It consists of three parts:

1.	A set of 17 utilities that add new features to Excel. You can access these using the Power Utility Pak toolbar, or from the menu.

2.	A collection of 17 new worksheet functions that can be used just like Excel's built-in functions.

3.	Enhanced shortcut menus. These are the menus that appear when you right-click an object.

[Complete On-Line Help is available to registered users.]

See Also...

The Utilities

New Worksheet Functions

Enhanced Shortcut Menus

Configuring the Power Utility Pak


The Utilities

The Power Utlity Pak includes17 utilities, accessible from a custom toolbar or from Excel's menu. For information about a particular utility, choose from the list below.

Text Tools	Perpetual Calendar

Select By Value	Reminder Alarm

Interactive Zooming	Time Tracker

Reminder Note	Object Properties

Object Align, Size and Space	Super GoTo

Calculator	Workbook Contents

3D Cell Shading	Save With Backup

Date and Time	Batch Printing

Insert-a-Date


  Text Tools

[Complete On-Line Help is available to registered users.]


  Select by Value

[Complete On-Line Help is available to registered users.]


  Interactive Zooming

[Complete On-Line Help is available to registered users.]


  Reminder Note

[Complete On-Line Help is available to registered users.]


  Object Align, Size and Space

[Complete On-Line Help is available to registered users.]


  Calculator

[Complete On-Line Help is available to registered users.]


  3D Cell Shading

[Complete On-Line Help is available to registered users.]


 Date and Time

[Complete On-Line Help is available to registered users.]


  Insert-a-Date

[Complete On-Line Help is available to registered users.]


 Perpetual Calendar

[Complete On-Line Help is available to registered users.]


 Reminder Alarm

[Complete On-Line Help is available to registered users.]


 Time Tracker

[Complete On-Line Help is available to registered users.]


Object Information
  Object Properties

[Complete On-Line Help is available to registered users.]


  Super GoTo

[Complete On-Line Help is available to registered users.]


  Workbook Contents

[Complete On-Line Help is available to registered users.]


  Save With Backup

[Complete On-Line Help is available to registered users.]


  Batch Printing

[Complete On-Line Help is available to registered users.]


New Worksheet Functions

The Power Utility Pak includes 17 new functions that you can use in your worksheets. These functions work exactly like Excel's built-in functions. You can even use Excel's Function Wizard to select the function you need and get help with the arguments.

Note: In this help file, the functions are grouped into four categories. However, if you use the Function Wizard, look for them under the Power Utility Pak category.

To learn more about the new worksheet functions, choose a category from the list below.

Text functions

Date functions

Information functions

Other functions

See Also...

The Utilities

Enhanced Shortcut Menus


Text Functions Overview
Text Functions

These functions add new capabilities when dealing with text information in cells.

Contains

IsLike

ParseName

RemoveSpaces

Scramble

SelectOne

See Also...

Date functions

Information functions

Other functions


CONTAINS function

[Complete On-Line Help is available to registered users.]


ISLIKE function

[Complete On-Line Help is available to registered users.]


PARSENAME function

[Complete On-Line Help is available to registered users.]


REMOVESPACES function

[Complete On-Line Help is available to registered users.]


SCRAMBLE function

[Complete On-Line Help is available to registered users.]


Date Functions Overview
Date Functions

These functions add new capabilities when dealing with date information in cells.

DaysInMonth

MonthWeek

See Also...

Text functions

Information functions

Other functions


DAYSINMONTH function

[Complete On-Line Help is available to registered users.]


MONTHWEEK function

[Complete On-Line Help is available to registered users.]


Information Functions Overview
Information Functions

These functions return various types of information about your system.

DOSVersion

ExcelDir

FileName

GetINISetting

User

WindowsDir

WindowsVersion

See Also...

Text functions

Date functions

Other functions


DOSVERSION function

[Complete On-Line Help is available to registered users.]


EXCELDIR function

[Complete On-Line Help is available to registered users.]


FILENAME function

[Complete On-Line Help is available to registered users.]


GETINISETTING function

[Complete On-Line Help is available to registered users.]


USER function

[Complete On-Line Help is available to registered users.]


WINDOWSDIR function

[Complete On-Line Help is available to registered users.]


WINDOWSVERSION function

[Complete On-Line Help is available to registered users.]


Other Functions Overview
Other Functions

These three functions add new capabilities to your worksheet formulas.

NoExtremesAvg

SelectOne

StaticRand

See Also...

Text functions

Date functions

Information functions


NOEXTREMESAVG function

[Complete On-Line Help is available to registered users.]


SELECTONE function

[Complete On-Line Help is available to registered users.]


STATICRAND function

[Complete On-Line Help is available to registered users.]


Enhanced Shortcut Menus

[Complete On-Line Help is available to registered users.]

See Also...

The Utilities

New Worksheet Functions

Configuring the Power Utility Pak


  Configuring the Power Utility Pak

[Complete On-Line Help is available to registered users.]

See Also...

The Utilities

New Worksheet Functions

Enhanced Shortcut Menus


Technical Support

[Complete On-Line Help is available to registered users.]

See Also...

Technical Information


Technical Information

[Complete On-Line Help is available to registered users.]