- Shopping Bag ( 0 items )
"Excel® for Chemists should be part of any academic library offering courses and programs in chemistry. There is no other book on the market that deals so thoroughly with the application of Excel for analyzing chemical data. Highly recommended, for upper-division undergraduates through professionals."
"I highly recommend this book; treat yourself to it; assign it to a class; give it as a gift."
Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the scientific calculating power within this program. Excel is capable of helping chemists process, analyze, and present scientific data, from the relatively simple to the highly complex. Excel® for Chemists, Second Edition has been revised and updated, not only to take into account the changes that were made in Excel, but also to incorporate an abundance of new examples.
Arranged in a user-friendly format, this book contains illustrations and examples of chemical applications, useful "How to" boxes outlining how to accomplish complex tasks in Excel, and step-by-step instructions for programming Excel to automate repetitive data-processing tasks. In addition, tips are provided to speed, simplify, and improve your use of Excel. Included is a CD-ROM, usable in either Macintosh or IBM/Windows environments with many helpful spreadsheet templates, macros, and other tools.
Entirely new chapters contained in this Second Edition feature:
Only One Chart Type Is Useful For Chemists
Excel 2000 provides a gallery of 14 standard chart types - bar charts, column charts, line charts and pie charts, among others. Since Excel originated as a financial tool, most of the chart types are those that are useful for displaying financial and related information - a bar chart to show sales figures for each business quarter, a line chart to show stock values each day over a one-month period, etc. Only one kind of chart, the XY or scatter plot, is of general usefulness for displaying scientific data. It is the only one in which numeric values are used along both axes. All other charts plot the numeric y values vs. equal increments on the X Axis and use the x values only for labels (called categories by Excel). The line chart, which looks like an XY chart, is actually only a bar chart of y values with the y values (the tops of the bars) shown as marker points connected by straight lines.
Creating a Chart
There are two ways to create a chart: either as a separate chart sheet in a workbook, or as a chart embedded in a worksheet, so that you can see both the data and the chart at the same time. An embedded chart is useful if you want to see how a curve changes as you change its parameters. As you change the values in worksheet cells, the chart will update automatically.
Creating a Chart Using The Chart Wizard
You can use the Chart Wizard toolbutton to create a chart. To use the Chart Wizard, first select the data to be plotted, e.g., a column of x values and a column of y values. The data can be in rows or columns. If the rows or columns are not adjacent, hold down the CONTROL key (Windows) or COMMAND key (Macintosh) while selecting the separate rows or columns of data. Then press the Chart Wizard toolbutton (alternatively, you can press the Chart Wizard button first and select the data range later). The first of a series of four dialog boxes will appear. The first Chart Wizard dialog box (Figure 2-1) lets you select the desired chart format. There are tabs for two categories: Standard Types and Custom Types (Custom Types are discussed in Chapter 5). When you select a chart type from the Chart Type category box, the chart subtypes will be displayed on the right. There are five subtypes of XY Scatter chart: marker points with no connecting lines, marker points connected by straight lines, straight lines with no marker points, points connected by a smooth curve and a smooth curve with no marker points.
In general, the Smooth Curve options are not useful, especially if you are plotting data that obeys a particular mathematical relationship, or data with some experimental scatter. To produce a chart with a smooth calculated curve through experimental data points, see "Plotting Experimental Data Points and a Calculated Curve" in Chapter 5.
The second dialog box (Figure 2-2) displays a preview of the chart and allows you to enter or change the range of data to be plotted. The second and subsequent dialog boxes also provide the Cancel and Back buttons, in case you want to change what you've already selected...
Preface to the First Edition.
Before You Begin.
Working with Excel.
Creating Charts: An Introduction.
ADVANCED SPREADSHEET TOPICS.
Creating Advances Worksheet Formulas.
Creating Array Formulas.
Advanced Charting Techniques.
Using Excel's Database Features.
Getting Data into Excel.
Adding Controls to a Spreadsheet.
Some Mathematical Tools for Spreadsheet Calculations.
Graphical and Numerical Methods of Analysis.
Non-Linear Regression Using the Solver.
EXCEL VISUAL BASIC MACROS.
Visual Basic for Applications: An Introduction.
Programming with VBA.
Working with Arrays in VBA.
Creating Command Macros.
Creating Custom Functions.
Creating Custom Menus and Menu Bars.
Creating Custom Tools and Toolbars.
Analysis of Solution Equilibria.
Analysis of Spectrophotometric Data.
Calculation of Binding Constants.
Analysis of Kinetics Data.
Appendix A: Selected Worksheet Functions by Category.
Appendix B: Alphabetical List of Selected Worksheet Functions.
Appendix C: Selected Visual Basic Keywords by Category.
Appendix D: Alphabetical List of Selected Visual Basic Keyword.
Appendix E: Shortcut Keys for PC and Macintosh.
Appendix F: Selected Shortcut Keys by Category.
Appendix G: About the CD-ROM That Accompanies This Book.
This book is designed to help you review or relearn basic arithmetic skills. It is more like a private tutor than a lecturer; you participate in the process rather than simply reading, listening, or sleeping through it. The book is organized in a format that respects your unique needs and interests and teaches you accordingly:
It is a pleasure for us to acknowledge our debts to the many people who have contributed to the development of this book and to this third edition. Jeffrey Golick and the staff at John Wiley & Sons, Inc., have been most supportive and patient throughout the lengthy process of producing a book. We were fortunate to have W Royce Adams, formerly the director of the Reading Center at Santa Barbara Community College, read preliminary versions of the book and provide valuable assistance in improving its readability.
Finally, we wish to extend special thanks to our kindest critics and most enthusiastic helpers: our children-Pat, Laurie, Maire, and Ericour other works in collaboration.
The material concerning charts has been changed extensively to reflect the changes that were made to the ChartWizard. The chapters on programming with VBA have been revised, and the chapters on creating command macros and custom functions using VBA have been completely re-written.
There are three completely new chapters in this edition:
Much of the material in this book has been incorporated in a course titled "Excel for Scientists and Engineers" that has been presented to over 1300 scientists in the past four years - not only chemists, but also scientists in many other disciplines. Many changes in this edition were made in light of the experience gained in teaching these courses.