Foundations of Excel VBA Programming and Numerical Methods
Publisher: PRINTKOM
Published: June, 2013
Place of publication: Moscow, Russia
Format: Manual
Number of pages: 528
ISBN-13: 9785911468941
Description: 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 – 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 author’s 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 “Computer science” for university students.
Table of contents: pagenum: 8
label: Introduction; title: Programming in Visual Basic
pagenum: 12
label: Chapter 1; title: Programming in VBA
pagenum: 133
label: Chapter 2; title: Finite Difference Method for Solving Differential Equations
pagenum: 195
label: Chapter 3; title: Cubic Spline
pagenum: 281
label: Chapter 4; title: Quadratic and Linear Splines
pagenum: 352
label: Chapter 5; title: Numerical Methods for Nonlinear Programming
pagenum: 415
label: Chapter 6; pagenum: 510
label: Instead of Conclusions; title: Data Types of Visual Basic and VBA
pagenum: 513
label: Appendix 1; title: Greek and Russian Alphabets Denoted by Latin Letters
pagenum: 515
label: Appendix 2; title: The Main Mathematical Functions
pagenum: 517
label: Appendix 3; title: Material for Tasks
pagenum: 518
label: Appendix 4; title: Analytical Method for Solving the Cubic Algebraic Equation
pagenum: 520
label: Appendix 5; title: Realization of the Tangent Method by Using the Excel Circular Reference
pagenum: 521
label: Appendix 6; pagenum: 523
label: References List; pagenum: 525
label: Subject Index