Menu for favorite macros in Excel 2011 for the Mac Very easy to add and edit menu items with this technique. Power Utility Pak collection for the Mac (Excel 2011) Briefly! Power Utility Pak 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. Starting with Excel 2011 Service Pack 1 (Version 14.1.0), Solver is once again bundled with Microsoft Excel for Mac. You do not have to download and install Solver from this page - simply ensure that you have the latest update of Excel 2011 (use Help - Check for Updates on the Excel menu). To enable Solver, click ‘Tools’ then ‘Addins’. The DecisionTools Suite is an integrated set of programs for risk analysis and decision making under uncertainty. DecisionTools Suite software integrates seamlessly with Microsoft Excel, and includes: @RISK for Monte Carlo simulation; PrecisionTree for decision trees; TopRank for “what if” sensitivity analysis. ToolsAdd-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: 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.
Skip to end of metadataGo to start of metadata| About | All Software | Software By Category | Info For Student Computers | Info For Faculty |
|---|
Access to Decision Tools during the pandemic
The physical labs and walk up help desk some students typically rely on to run Decision Tools or obtain help installing it will not be available until Spring 2021. If you require Decision Tools for your course work in Summer or Fall 2020 please follow the steps below.
- First install Decision Tools as you would normally be expected to do:
- If you are a Windows user you should download Decision Tools from https://utexas.box.com/v/dtsinstallerand install it directly onto your own computer.
- If you are a Mac user you should first follow the instructions at Installing OVA files with VirtualBox on a Mac to set up a Windows Virtual Machine (VM) on your Mac. Then download Decision Tools from https://utexas.box.com/v/dtsinstallerand install it directly into the VM.
- If you experience problems installing Decision Tools or a Windows VM you should submit a help request at https://www.mccombs.utexas.edu/tech.
- Someone from the McCombs Service Desk will reply and assist you via email if they can or else they will schedule a time to assist you via an individual Zoom remote support session if needed.
- If an unexpectedly large number of students require remote assistance, then the Service Desk will schedule group Zoom remote support sessions for you to sign up for.
- If the Service Desk is unable to resolve your issue, you will be asked to connect to certain remotely available lab computers at https://remotelab.mccombs.utexas.edu in order to run Decision Tools.
Decision Tools is a set of Microsoft excel add-ins for risk and decision analysis. It includes @Risk, StatTools, PrecisionTree, TopRank and other Excel add ins. It is a commercial product from Palisade Corporation. The McCombs School of Business has negotiated a number of licenses for student use. You will need to install Microsoft Office (free Office 365 subscription) first if you are installing Decision Tools on your computer - https://office365.austin.utexas.edu/
- Where Available: Mod Lab, Student Computer, NRG
- Decision Tools is one of the applications available on the Stat Apps terminal server maintained by the Department of Statistics and Data Sciences. For more information about this server please visit http://stat.utexas.edu/consulting/stat-apps-server. For more information about connecting to this server, pleasesee our wiki page at https://wikis.utexas.edu/display/MSBTech/Configuring+a+Remote+Desktop+Connection+for+the+Stat+Apps+Server.
- Decision Tools is available on the computers in the NRG. These computers are also remotely available at https://remotelab.mccombs.utexas.edu.
- Source: You can download Decision Tools for student computers at https://utexas.box.com/v/dtsinstaller(you will be prompted to login with your EID to download the installer). Download and run the file to install.
- Cost: Free
Attention Mac Users
This software is only available for Windows. To install this onto a Macintoshyou should first create a virtual machine on your computer and install Microsoft Windows and Office into it. If you do not currently have a Windows VM available on your computer (or a dual boot Mac/Windows computer), then you have a couple of options:
- Obtain a VirtualBox VM created by Computer Services that has DTools already installed. You can visit the SWAT Shop to request assistance in installing this VM or you can install it yourself by following the instructions at Installing OVA files using VirtualBox on a Mac.
- Use one of the computers setup in the NRG Reading Room (CBA 4.112A).
Excel Mac Torrent
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
Excel 2011 For Mac Download
When you click on it you can use the 60+ add-ins that you see in the menu
Note 1 :
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.
Note 2 :
There are 3 shortcuts that are very useful :
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 :
Excel Mac Trial
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.