This course offers over 52 lessons and 12 hours of video content to teach you how to take advantage of advanced Excel functions. If you are familiar with Excel and want to take your skills to the next level, enroll in Learn Microsoft Excel 2013 – Advanced now and join over four thousand students who are learning to use Excel like a pro. This tutorial will show you how solver works and how you can use it to determine how many units to sell in different branches of an organization.

The Excel solver function for example, can help you work out what optimum levels of production or sales will be based on various objectives and constraints. You should see a numeric sample value instead of #NAME.Excel 2013 contains powerful tools to save you hours of calculations.

If the #NAMEs don't disappear immediately, just close and reopen the workbook. You should see Analytic Solver Platform in the list - make sure the box is checked next to it (click the box to check or uncheck). This opens another dialog with a list of add-ins. The PSI functions are defined by the Excel Add-In.Īt the bottom of the dialog, you should see, or be able to select from the dropdown list, Manage Excel Add-Ins - then click the Go button. You should see both 'Analytic Solver Platform' Excel Add-In and 'Analytic Solver Platform Addin' COM Add-In in the list. On the File tab, click Options, then in the left column of the dialog box, click Add-Ins. in the list, this means the add-in functions are not enabled. If you don't see PSI Distribution, PSI Statistics, etc. When I run the simulations I see the same message.Īs a quick check, open the Function Wizard in Excel (click the fx icon), then open the dropdown list of function categories. In cells where I have '=PsiNormal(5%,10%)' formulas I now see the message #NAME? instead of a random variable. I have recently installed Excel 2013 and have reinstalled Analytic Solver Platform.

Install solver for excel 2013