An advanced, up-to-date tutorial on programming with the Microsoft Excel spreadsheet program, this is currently the only book available for engineers and scientists that contains complete listings of spreadsheet programs and macros of technical applications. All program segments are based on computer tested code for engineering applications, making this a valuable reference source for engineers and scientists in any field of specialty. The book covers all the important and advanced spreadsheet features and requires no programming ability.
2. Basic Computation.
3. Numeric Functions.
5. Logic, Decisions, and Iteration.
6. Preparing Graphs.
7. Function Macros.
8. Command Macros, Menus, and Dialog Boxes.
9. The Database.
10. Linking, Importing, and Exporting.