- Taschenbuch: 512 Seiten
- Verlag: John Wiley & Sons; Auflage: 2. Auflage (23. April 2001)
- Sprache: Englisch
- ISBN-10: 0471394629
- ISBN-13: 978-0471394624
- Größe und/oder Gewicht: 18 x 2,6 x 25,3 cm
- Durchschnittliche Kundenbewertung: 1 Kundenrezension
- Amazon Bestseller-Rang: Nr. 3.462.379 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
Excel for Chemists: A Comprehensive Guide (Englisch) Taschenbuch – 23. April 2001
Dieses Buch gibt es in einer neuen Auflage:
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
"...designed to help chemists in industry, academia, or government make use of the full capacity of Excel." (SciTech Book News, Vol. 25, No. 3, September 2001)
"As a venture capitalist, I negotiate every day. Michael Watkins' book is the first I have found that truly grapples with complications of real-world negotiations. The book provides the reader with a practical framework for plotting strategy and is chock full of relevant case studies and solid advice on getting the most from every negotiation. As I read this book, I was struck at how often I was able to apply the tools and techniques to my past and current experiences in negotiation. Watkins' book is a powerful tool for anybody who wants to take control and come out on top. I wish I had read it 20 years ago," (John F. Eckert Founder and Managing Partner, McLean Watson Capital Inc.: and President, Canadian Venture Capital Association)Alle Produktbeschreibungen
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
Dies ist sicherlich für alle die mit Excel im Bereich der Chemie arbeitet eine gute Investition.
PS: Ein paar Teile von VBA Programmen funktionieren in Excel 2003 nicht da M$ anscheinend die Objekte der Toolbar anders geregelt hat. Dies ist jedoch kein allzu großes Hindernis.
Die hilfreichsten Kundenrezensionen auf Amazon.com
If you already know the basics about spreadsheets, then this book is packed with pearls that enhance your productivity and get you powerful results. It will take me years to exhaust the potential.
The CD ROM with the book is very good as well, with examples for the more complex subjects.
I use this reference to evaluate complicated data with multiple interactions on animal and human data in biomedical research. I do research in PET (Positron Emission Tomography) imaging.
While this book is no substitute for a professional biostatistician, the book has helped me to not only follow the progress and interrelationships of the data but also to more clearly communicate my needs to a professional biostatistics firm. This also saves me money since it saves the biostatisticians time. I also think it improves results.
I highly recommend this book.
AMAZON SAID THEY COULD DO NOTHING FOR ME. BUT THEY WILL GIVE A PRICE MATCH ON TVS.
I HAVE ALWAYS HAD GOOD LUCK ON SCHOOL BOOKS BUT THIS IS SOMETHING THE COLLEGE BOOK
STORE WOULD DO. I AM NOT HAPPY WITH THIS PURCHASE IF I DIDN'T NEED IT FOR CLASS
I WOULD HAVE SENT IT BACK.
AS FOR THE BOOK IT IS GOOD
The first chapter is an introduction to Excel. Even the experienced user will find something new here. My favorite was learning that a shortcut menu listing all sheets in a workbook is available by right-clicking on any of the sheet tab scroll buttons.
The second chapter (10 pages) explains how to make basic graphs in Excel. Many people have Excel, but are unaware of how easy it is to make graphs with Excel. Chapter 5 shows how to construct advanced charts with, for example, multiple axis, error bars, and smoothed lines.
Chapter 3 starts to get into the power user stuff, such as making formulas more understandable by using named ranges. I had quit using names because they apply to every sheet in a workbook; this chapter shows how to make the name apply to just one sheet. The chapter also does a very good job of showing how to construct huge formulas ("megaformulas").
Chapter 4 explains how to use array formulas. This chapter is valuable because Excel's help file doesn't provide much information on using arrays. Arrays make for much cleaner-looking spreadsheets.
Chapter 6 shows how to use Excel's database features to keep track of, for example, a chemical inventory list. Since I don't use these features very often, it is nice to have them described where I can use them when I need them. The same can be said about appendix E, "Shortcut Keys for the PC and Macintosh".
Chapter 7 describes how to import data into a spreadsheet. If you have more data than you want, this chapter shows how to extract every, say, 10th data point.
Chapter 8 shows how option buttons, check boxes, list boxes, etc. can simplify use of a spreadsheet. For example, I needed to enter a number and convert it to pH, pOH, Ka, or Kb, depending on what was entered. Using the info in this chapter, I now just click on an option button, and the sheet does the appropriate conversions.
Chapters 9-12 are about spreadsheet mathematics. Goal Seek, linear regression and Solver are covered. What really makes this material useful is that it tells how to do a statistical analysis of the results, even for non-linear regression.
Chapters 13-19 illustrate how to use Visual Basic for Application (VBA), the programming language built into Excel. The code examples are clearly the work of an amateur programmer. "Option Explicit" is omitted, only arrays are dimensioned, the standard method of indenting to improve readability is not used, and-horrors-the author uses GoTo statements. Nonetheless, these chapters do show the basics of programming with VBA. The CD includes many code examples, including a neat program for formatting chemical equations. For example, it will subscript the 2 in H2O.
Chapters 20-23 are more applications. I especially liked learning how to deconvolute a spectrum with Excel.
The book isn't perfect-a few typos, organization could be improved, one of the files on the CD wouldn't open-but if you are a chemist and want to become better at using Excel, this is the book you need. I wish my company had given me this book when I started using Excel in industry. It would have saved a lot of time.