Purchase textbook

Excel by Example,

Edition 1 A Microsoft Excel Cookbook for Electronics Engineers

Editors: By Aubrey Kagan

Publication Date: 19 May 2004

0 Reviews

Inaccessible, or known limited accessibility

Ways Of Reading

This e-publication is accessible to the full extent that the file format and types of content allow, on a specific reading device, by default, without necessarily including any additions such as textual descriptions of images or enhanced navigation.

Navigation

The contents of the PDF have been tagged to permit access by assistive technologies as per PDF-UA-1 standard.
Page breaks included from the original print source

Additional Accessibility Information

All (or substantially all) textual matter is arranged in a single logical reading order (including text that is visually presented as separate from the main text flow, e.g., in boxouts, captions, tables, footnotes, endnotes, citations, etc.). Non-textual content is also linked from within this logical reading order. (Purely decorative non-text content can be ignored).
The language of the text has been specified (e.g., via the HTML or XML lang attribute) to optimise text-to-speech (and other alternative renderings), both at the whole document level and, where appropriate, for individual words, phrases or passages in a different language.

Conformance

The publication was certified on 20250728
Accessibility addendum
For detailed accessibility information, see Elsevier’s website at https://www.elsevier.com/about/accessibility
For queries regarding accessibility information, contact [email protected]

Note

This product relies on 3rd party tooling which may impact the accessibility features visible in inspection copies. All accessibility features mentioned would be present in the purchased version of the title.

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.

Key Features

*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

About the author

By Aubrey Kagan, Senior Design Engineer, Weidmuller Canada.

IntroductionExcel Basics:- autofill- copying formulae- relative & absolute- naming cells- formatting cells- simple examples- amplifiersLookupTables, File I/O (comma delimited):- price break table- interface to Parts & Vendors- MTBF calculationMacros- Resistor value- Timer- Best Resistor pair selection- Voltage regulator model- 555 timer- XTR104 model- Automatic open- Goal seek- Timer- SolverGraphs- curve fitting- Bode plots- Polar plots- Simulating input/ monitor and plot output for a digital PID loop- non-linear response-Controls- pushbuttons- hex - decimal conversion- LCD initialization application- Spinners- Generate initialization code for microcomputer (e.g. 8051)- Serial number generation (or P.O. number etc.)- Hide Excel from viewVoice control of ExcelAnalysis Toolpak- statistical analysis- moving average- random number generation- Fourier analysisData base- sort bills of materialExternal input into Excel- linking to other applications, copying, dynamic updating- loading files- Enter data from serial port into spreadsheet- Invoke Excel from Visual BasicOther resourcesIndex

ISBN: 9780750677561

Page Count: 364

Retail Price :

S.C. Bloch, Excel for Engineers and Scientists, 280 pp., Wiley, 2000Bernard Liengme, Guide to Microsoft Excel 2002 for Scientists and Engineers, 314 pp., Newnes, 2002

Electronics/electrical engineers and technicians (500,000+ in U.S., according to Dept. of Labor statistics). Electrical/electronics engineering students.