- 364 pages
- English
- PDF
- Available on iOS & Android
About this book
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
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Front Cover
- Excel by Example: A Microsoft® Excel Cookbook for Electronics Engineers
- Copyright Page
- Contents
- Acknowledgments
- Introduction
- What’s on the CD-ROM?
- Example 1: Voltage-to-Current Converter
- Example 2: Baud Rate Selection
- Example 3: Mean Time Between Failures (MTBF)
- Example 4: Counting Machine Cycles
- Example 5: Character Generator
- Example 6: 8052 Microcomputer Register Setup
- Example 7: Finding the Optimal Resistor Combination: LP 2951
- Example 8: Resistor Color Code Decoder Using Speech Input
- Example 9: RTD to 4–20 mA Converter: XTR10S
- Example 10: Voltage Regulator: LM 317
- Example 11: TL431 Adjustable Voltage Reference
- Example 12: 555 Timer
- Example 13: Purchase Order Generator
- Example 14: Interface to a Digital MultimeterUsing a Serial Port
- Example 15: Vernier Caliper Interface
- Example 16: Function Generator Interface
- Appendix A: VBA and Excel
- Appendix B: Parallel and Serial I/O
- References
- About the Author
- Index
- Elsevier Science CD-Rom License Agreement