Cart
Free US shipping over $10
Proud to be B-Corp

Excel by Example Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)

Excel by Example By Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)

Excel by Example by Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)


$14.28
Condition - Good
Only 2 left

Summary

Suitable for electronics engineers and technicians, this work shows how to use Excel's features for computations, circuit modeling, graphing and data analysis as applied to electronics design. It covers lookup tables and file I/O, and using Analysis Toolpak for statistical analysis, databases and linking into Excel from other sources.

Faster Shipping

Get this product faster from our US warehouse

Excel by Example Summary

Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers by Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)

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.

Excel by Example Reviews

Excel by Example...shows you how you can use the ubiquitous spreadsheet application to model and analyze parts of your design...can help you become more efficient in many of the small-scale aspects of design. These aspects can take a suprisingly large amount of your time and yield many benefits when you work efficiently. The author has written for Circuit Cellar, and he must know his subject... - EDN August 2004 This is an excellent resource for electronics engineers (and enthusiasts), and a great guide to the use of spreadsheet programs to high-end applications. Very well written and presented. - PC Update Online, Major Keary Anyone involved with engineering applications will find useful information in this book ... Kagan presents complete examples that show how commands work together. The author provides examples that include a voltage-to-current converter, a mean-time-between-failures (MTBF) calculator, and a voltage-regulator circuit calculator. The examples are not static. In the MTBF example, you can create what-if conditions that let you apply variables to see how they affect an outcome. - Jon Titus, Design News, May 15, 2006

About Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)

Aubrey Kagan is a registered professional engineer with 24 years of experience in electronics design, specializing in industrial controls. He has a BSEE from the Technion, Israel Institute of Technology, and an MBA from the University of Witwatersrand (South Africa). He has designed projects that have operated two miles underground in a mine to 600 miles above the earth in the International Space Station. He is currently a senior design engineer for Weidmuller Canada. He has written a series of tutorial articles for Circuit Cellar magazine on using Excel capabilities specifically for electronics applications, as well as numerous other technical articles.

Table of Contents

Introduction Excel Basics: - autofill - copying formulae - relative & absolute - naming cells - formatting cells - simple examples- amplifiers LookupTables, File I/O (comma delimited): - price break table - interface to Parts & Vendors - MTBF calculation Macros - Resistor value - Timer - Best Resistor pair selection - Voltage regulator model - 555 timer - XTR104 model - Automatic open - Goal seek - Timer - Solver Graphs - 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 view Voice control of Excel Analysis Toolpak- statistical analysis - moving average - random number generation - Fourier analysis Data base - sort bills of material External input into Excel - linking to other applications, copying, dynamic updating - loading files - Enter data from serial port into spreadsheet - Invoke Excel from Visual Basic Other resources Index

Additional information

CIN0750677562G
9780750677561
0750677562
Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers by Aubrey Kagan (Senior Design Engineer, Weidmuller Canada.)
Used - Good
Paperback
Elsevier Science & Technology
20040611
364
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel by Example