SPb. : Peter, 2009. — 320 s: il. This book is devoted to methods of solving financial and economic problems using Microsoft Excel 2007. Here are collected a significant number of practical examples of financial modeling and optimization, covering the main range of tasks arising in the work of the financial analyst and economist. Having mastered the material of the book, the reader will learn how to solve the problems of investment management and securities management, carry out logistics calculations and create optimization models. In addition, the publication describes in detail the mathematical and statistical capabilities available to the user when working with Excel 2007.