Decision Tools For Excel Mac 2011

  

Power Utility Pak for the Mac, Add-in Tools for Excel 2011

Briefly! Power Utility Pak (PUP/MAC v1) is a useful collection of add-ins that brings significant new functionality to Excel 2011 for the Mac. When PUP is installed, you can do things with Excel that you never thought were possible. Regardless of your experience level, you'll find features in PUP that can make your job easier. PUPMAC v1 augments Excel with about 60+ new commands including a mail tool for Apple Mail or Outlook and also 53 new worksheet functions. The product is designed to work seamlessly with Excel.
Note: The original add-in is created for Windows by John Walkenbach, click here to visit John's site.
http://spreadsheetpage.com/index.php/pupmac

Many thanks to John for allowing me to make a PUP version for the Mac of his Power Utility Pak. The goal is to make every component of PUP/MAC error-free and accurate. If you have problems or want to give feedback use the mail address in the 'About Power Utility Pak' menu option in the PUP/Mac v1 menu.
Download PUP/MAC Add-in collection
Download version 1.1
File date 25-Nov-2012 : version history

Note: Power Utility Pak for the Mac is available as freeware. But you can use the Contact button in the menu if you want to support the development of this add-in.
How to Install the PUP/MAC add-in
1: Click on the Download link
2: Double-click the dmg file if it does not mount automatically
3: You see a folder named PupMacFolder in the Disk Image
In this folder there is one folder and the main add-in
4: Drag the complete PupMacFolder to the folder you want on your Mac
5: Open Excel
6: Choose Tools>Add-ins... in the menu
7: Click on Select to browse to the main add-in in the PupMacFolder
8: Select pupmac.xlam and choose Open
9: There is a checkmark now before the add-in name in the list
10: Press OK and you have installed the add-in
Note: Every time you open Excel it will load the add-in now, if you not want to load it by default use
Tools>Add-ins again and remove the checkmark before the pupmac.xlam.
If correct you see a new menu item in the menubar name PUP/MAC v1

When you click on it you can use the 60+ add-ins that you see in the menu

Note 1 :

Mac

Because of a bug in Excel 2011 it is possible that it will display a security warning when you use one of the menu options. To avoid this you can uncheck 'Warn before opening a file that contains macros' in
Excel > Preferences.... Security. Be aware that this will open every file with code without a warning. Open only Excel files from people you trust.

Decision Tools For Excel Mac 2011 Freeze Top Row

Simple Decision Tree. This is an Excel Add-in released under the terms of GPL v3 with additional permissions. It is initially created for the Stanford Decisions and Ethics Center and open-sourced it for the Decision Professionals Network. It is good if you need a really simple open source decision tree solution. You've read a help topic that mentions a command on the Table Tools or the PivotTable Tools, but you don't see these tools. If you don't see Table Tools or PivotTable Tools on your worksheet, do this: Click any cell in the table or PivotTable. If you've selected an Excel table, you'll see the Table Tools with a Design tab. 8 cool tools for data analysis, visualization and presentation Last year, we looked at 22 data analysis tools. This year, we add 8 more to the mix.

Decision Tools For Excel Mac 2011

Microsoft Excel For Mac 2011

Note 2 :

Decision Tools For Excel Mac 2011 Edition

There are 3 shortcuts that are very useful :

Excel mac gratuit

Decision Tools For Excel Mac 2011 Free

Activate Bookmarks : Command-Option-b
Run last Utility that you have opened : Command-Option-l (lowercase L)
Call the DatePicker : Command-Option-n

On the New keyboards 'Command' can also be 'CMD' and 'Option' can also be 'Alt'

Note 3 :

Decision Tools For Excel Mac 2011 Basic Formulas

In every menu option you can find a small help button that you can click on if you need help. Use 'Power Utility Pak Options' in the PUP/MAC menu to set the max number of utility files in memory.