Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Functions and Solver Improvements in Excel 2010


12 Oct 2009   #1

 
Functions and Solver Improvements in Excel 2010

Quote:
There have been several improvements made in Excel 2010 to the function library and the Solver add-in. The function improvements have been made to address issues reported in academic papers as well as customer feedback. To quote the Excel team blog:

“In Excel 2010, we made many improvements to Excel's function library. Excel 2010 will feature an accurate and consistent function library while remaining compatible with previous versions of Excel. “

In addition to the accuracy improvements, we also have introduced various new functions to the Excel function library to ensure that users have a consistent function library with implementations that match standard practices. As are result of these improvements, we have also made some UI changes to help users adopt the new functions.



Here are the blog posts that describe the function work in detail:

Excel 2010 will also provide an updated version of the Solver add-in:

“In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems. “

The Excel 2010 Solver will offer a new user interface, new solving methods and new reports. The UI for the Solver Parameter dialog has been improved to make it easier for users to navigate.



In addition to the UI changes, the new Solver will also feature 3 solving methods for solving spreadsheet optimization problems:

  • Simplex Method
  • GRG Nonlinear Solver
  • Evolutionary Solver
New reports added in the Excel 2010 Solver are:

  • Linearity Report
  • Feasibility Report
  • Population Report
Enjoy!

More...

My System SpecsSystem Spec
.

Reply

 Functions and Solver Improvements in Excel 2010




Thread Tools



Similar help and support threads for2: Functions and Solver Improvements in Excel 2010
Thread Forum
Excel 2010 Microsoft Office
Solved Excel 2010 help Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007 Microsoft Office
excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
To-Do Bar Improvements in Outlook 2010. Microsoft Office
Office 2010 Improvements for Cropping Pictures News

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 07:19 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33