This course covers advanced solver. In it you will learn the different types of solver models. Models such as Simplex LP (Linear) , GRG (Nonlinear) , and Evolutionary.
Learn how Simplex LP can be used to find the optimal solution
Learn how GRG can be used to smooth nonlinear optimization problems
Learn how the Evolutionary solver can find the optimal solution to non-smooth, nonlinear optimization problems. This includes optimization models involving functions such as IF, COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF, and AVERAGEIFS.
How to assign workers to jobs using the evolutionary solver
How to schedule production of products
How to estimate elasticities using GRG Multistart
How to use the Evolutionary Solver for Cluster Analysis
How to use the Evolutionary Solver to resolve process bottlenecks
Who Will Benefit?
Any professional that uses Microsoft Excel and wants to learn how to optimize processes with the different Excel Solver Models.
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world's foremost Microsoft Excel Expert that teaches at some of the world's largest organizations including Microsoft and government organizations such as the Navy and Army.