This book is for people in technical fields, students and professionals alike. Its aim is to show the usefulness of Microsoft® Excel in solving a wide range of numerical problems. Excel does not compete with the major league symbolic mathematical environments such as Mathematica, Mathcad, Maple, and the like. Rather it complements them. Excel is more readily available and is easier to learn. Furthermore, it generally has better graphing features and ways of handling large datasets.
The examples have been taken from a range of disciplines but require no specialized knowledge, so the reader is invited to try them all. Do not be put off by an exercise that is not in your area of interest. Each exercise is designed to introduce and explain an Excel feature. The two modeling chapters will help you learn how to develop worksheets for a variety of problems.
This is very much a practical book designed to show how to get results. The problem sets at the ends of the chapters are part of the learning process and should be attempted. Many of the questions are answered in the last chapter. The Guide is suitable for use as either a textbook in a course on scientific computer applications, a supplementary text in a numerical methods course, or a self-study book. Professionals may find Excel useful to solve one-off problems rather than writing and debugging a program, or for prototyping and debugging complex programs. A few
topics are not covered by the Guide, such as database functions and making presentation worksheets.These are fully covered in Excel books targeted at the business community, and the techniques are applicable to any field.
I was agreeably surprised by the warm reception given to the first and subsequent editions of the Guide. I am grateful for the many e-mailed comments and suggestions from readers and academics. This edition has involved a major rewrite since Excel 2013 has several features that differ from earlier versions. The opportunity has been taken to add new exercises and problems.
I wish again to thank David Ellert, John Quinn, and Robert van den Hoogen for their earlier assistance. I am honored that Microsoft awarded me the Most Valuable Professional in Excel in 2014 for the eighth consecutive year. My final thanks go to my wife Pauline for her encouragement and word skills; without her, this book would never have seen the light of day. However, I claim responsibility for all errors and typos.
