The book reflects the latest version of Excel and introduces Ribbon Bar Navigation. It features 2 new chapters on data management capabilities (connectivity to external databases, organization of data, sorting, filtering and data lookup across worksheets using functions like VLOOKUP and HLOOKUP) and Office 365 and integration with cloud resources.
"What Every Engineer Should Know About Excel is a valuable reference material that can be readily utilized by Engineers, Financial Comptrollers, Investors and Technology professionals in all industries. This second edition to Dr. Holman's original collection of materials allows today's Excel users to sharpen their current Excel skills, and take them to the next level, even integrating with cloud resources."-David A. Schmidt, SCHMIDT & STACY® Consulting Engineers, Inc., Dallas, Texas, USA
"This book unleashes the incredible power Excel offers for engineers and scientists. Reviewing the book, I found myself simply browsing the many features of Excel that I had previously not explored. Every engineer and scientist will benefit from this book at some level and I only regret that I didn't have access to a guide such as this earlier in my career. This book is extraordinarily well-organized. Any topic of interest can be quickly and easily accessed simply by referring to the Table of Contents. Once located, the topic is clearly and concisely presented with helpful illustrations and examples."-Stephen M. Collard, St. David's Foundation, Austin, Texas, USA
"What Every Engineer Should Know About Excel is a timely, practical, thorough, and well-written book. It provides clear step-by-step directions on how to utilize Excel to solve simple and complex engineering-related tasks. The book displays excellent insight into the 'guts' of Excel's presuppositions (i.e., how Excel defines terms and formulas) and its powerful built-in functions. It demonstrates concepts in such a manner that a reader is enticed to explore Excel's virtues. The book serves the needs of both the novice and the expert. It can be used as either a university textbook or as a practical reference guide."-Mark A. Stone, Business Associate, Bryan, Texas, USA
"What Every Engineer Should Know About Excel is a book that every engineer will find valuable for his or her work. The book begins with an overview of commonly used spreadsheet functions in Excel, including writing and copying formulas, built-in functions, and creating visually appealing charts, graphs, and drawings. Advanced calculation methods are clearly described, with explanations of how to solve nonlinear problems, iterative solution methods, matrix methods, and optimization problems. Practicing engineers will also find the overview of financial functions valuable for engineering financial analysis. The second edition includes new chapters on data management and integrating Excel with the Cloud. The book presents material in a practical step-by-step approach using examples from engineering practice."-David A. Willis, Southern Methodist University, Dallas, Texas, USA
