Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers
| 2004-05-19 00:00:00 | | 0 | Microsoft Excel
The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how to best use Excel's features for computations, circuit modeling, graphing, and data analysis as applied to electronics design. Separate chapters cover lookup tables and file I/O, using macros, graphing, controls, using Analysis Toolpak for statistical analysis, databases, and linking into Excel from other sources, such as data from a serial port. The book is basically an engineering cookbook, with each chapter providing tutorial information along with several Excel `recipes` of interest to electronics engineers. The accompanying CD-ROM features ready-to-run, customizable Excel worksheets derived from the book examples, which will be useful tools to add to any electronics engineer's spreadsheet toolbox.
Engineers are looking for any and all means to increase their efficiency and add to their `bag of design tricks.` Just about every electronics engineer uses Excel but most feel that the program has many more features to offer, if they only knew what they were! The Excel documentation is voluminous and electronics engineers don't have the time to read it all and sift through looking for those features that are directly applicable to their jobs and figure out how to use them. This book does that task for them-pulls out those features that they need to know about and shows them how to make use of them in specific design examples that they can then tailor to their own design needs.
*This is the ONLY book to deal with Excel specifically in the electronics field
*Distills voluminous and time-consuming Excel documentation down to nitty-gritty explanations of those features that are directly applicable to the electronics engineer's daily job duties
*The accompanying CD-ROM provides ready-to-use, fully-customizable worksheets from the book's examples
User review
Excel for electronic 100%
Great book that explore a lot Excel using all the examples on calculus in the electronics area.
A lot of examples let easier the electronic enginner live, using Excel in the best way for it.
User review
Excel Cookbook for Electronics Engineers
Great examples of real applications. His method of transference is one of ease, if you pay attention! Before finishing it, I was using several tidbits that had been doging me at work,,.
My boss sent me home early on a Friday with the instructions to take the wife out to dinner on him! Is this book worth it? What do you think?
User review
An excellent, practical book
I recommend this book highly.
The Excel spreadsheet software includes many capabilities most people do not think about when they use Excel for general business purposes. In this useful book, the author presents 16 complete examples from day-to-day electronics. Those examples include a voltage-to-current converter, a mean-time-between-failures (MTBF) calculator, a resistor color-code decoder using voice input, a voltage-regulator circuit calculator, and others. Instead of simply presenting and describing the examples, the author steps readers through the creation of the needed spreadsheets, formulas, graphs, formats, and other portions of the project.
The examples are not static. In the MTBF example, you will have an opportunity to create `scenarios` that let you try combinations of variables to determine what happens under `what if` conditions. The book comes with a CD-ROM that contains all the examples as well as an eBook version of the book. As you learn by doing, you'll gain experience using Excel so you can better apply it to your own engineering problems.
(Disclosure: I write for several magazines owned by Reed Elsevier, the parent company of the Newnes series of books. I do not work with the book-publishing group, however.)
User review
Its Handy,,.
This is a book you keep around because you forget all the tricks you pick up. I have a copy of the book and have used it a few times. Very handy in those situations where you need to use excel because everyone else is - its good that its for electrical engineers. Its good that it has those things that no one will teach you how to use.
User review
Practical and Useful to Electronic Engineers
This is book provide practical examples which are useful and helpful to me in my analogue design work, e.g. the variation of anlaogue reference voltages. Besides, this book also covers some digital applications. The book is easy to read and the spreadsheets are available in the enclosed CD ROM and we can use it as a reference, this saves me much time to regenerate the spreadsheet.