Excel is a powerful application. With additional Add-ons, it can be used to solve very complicated problem. Recently, one of my friends ask me how to solve neural network problem in Excel. Sure it can do the job. I will start with solving a very simple non-linear problem by using Excel Solver and extend the [...]
We usually use Excel to store a lot of data. To process these data, especially fit nonlinear model, is complicated. Excel provides a optimization tool called Solver that can be utilized to solve nonlinear problem numerically. In the past, we have experiences to solve neural network in Excel. If you run the Excel Solver from [...]
Excel Solver is a powerful tool to solve any nonlinear problem in Excel. Excel provide a interface to allow use to select options and fill target and parameters. If you only work on one set of data and explore multiple non-linear function, it is fine to use the Excel Solver interface. More often you are [...]