Intended for university students studying computer science, applied mathematics and information technology, as well as for post-graduate students, scientific workers and other readers wishing to refine their skill in solving problems by using tabular processor Microsoft Office Excel 2007 a 2013. Elements of an environment for developing programs (macros) and base constructs of programming languages Visual Basic and VBA are considered. Modern and classical numerical methods and their program realization are also considered. As examples, Excel macros are developed for solving mathematical, physical, engineering and economic problems. A compact disk containing program modules and other text information is enclosed. No preliminary programming experience is required for grasping the material. This book is based on the authoras two previous books approved by the Scientific and methodical council in computer science at the Ministry of Education and Science of the Russian Federation as a manual on discipline aComputer sciencea for university students.Calculation a the calculation mode (see area Calculation options of the Excel Options window after fulfilling File agt; Options ... operation mode of Excel; 2) xlCalculationManual a the manual calculation, for example, when pressing the F9 key.

Title | : | Foundations of Excel VBA Programming and Numerical Methods |

Author | : | G. Z. Garber |

Publisher | : | Moscow: PRINTKOM - 2013-06-21 |

Continue