"using Excel"

Excel Solver is applied to a fundamental nonlinear optimisation problem (mass balancing in mineral processing).

Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer.Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VBA and C/C++. This is the only complete how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book.

This textbook covers classical geometrical methods and modern analytical methods in kinematic synthesis of mechanisms. The methods discussed are all implemented geometrically using Geogebra and analytically using Excel®; two readily available tools for personal computers. After a brief history on how the machine science has developed throughout history from the viewpoint of mechanism design, the chapters explain two, three, four and five position synthesis of mechanisms in detail respectively. Geometrical and analytical methods of guiding a rigid body between the given positions, path generation with prescribed timing and correlation of crank angles are covered. Analytical methods are explained using complex numbers. Using relative motion concept, the position synthesis of six-link mechanisms is also taken into account. Roberts-Chebyshev theorem is described and proved, and the use of the theorem in practice is shown. Converting a continuous rotary motion into an oscillating or reciprocating motion has been the main task starting with the windmill or water wheel.

Learn to apply the important concepts and techniques of data analysis using Excel.

Solve linear algebraic equations with Numerical methods using Excel

This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book.

Learn core concepts in seven enterprise functional areas - CRM, CPQ, SCM, ACFI, HCM, EM, and KPI