What is PUP?
PUP, which stands for “Power Utility Pak,” is a unique collection of add-ins that enhance Microsoft Excel by adding new features and making existing features easier to use. It consists of general purpose utilities, new worksheet functions, enhanced shortcut menus, and a handy PUP Bookmarks toolbar. All told, PUP v6 (the current version of the software) adds more than 100 new (and non-trivial) features to Excel.