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 = xlCalculationManual tunes Excel for the manual calculation. To tune Excel for the manual calculation, we can also fulfill the following operational sequence in the Excel window: File agt; Options agt; Formulas agt; turn on Manual agt; OK.
|Title||:||Foundations of Excel VBA Programming and Numerical Methods|
|Author||:||G. Z. Garber|
|Publisher||:||Moscow: PRINTKOM - 2013-06-21|