Descripciones mejoradas de Syndetics:

In one volume, this book offers the reader a complete instructional and reference manual on using Microsoft Excel for chemical applications. The first half of the book is a sourcebook of instructions on Excel using chemical example throughout. The writing style and illustrations are far superior (for scientists) to manuals currently available. The second half of the book shows how to use Excel's built-in worksheet functions to perform advanced calculations, and illustrates these techniques with applications in chemistry. It also offers numerous useful macros and spreadsheets for solving a variety of chemistry problems. The book will be packaged with two diskettes, for Macintosh and Windows environments, respectively, that will include many spreadsheets and macros presented in the text.

Tabla de contenidos provista por Syndetics

• Preface(p. xix)
• Preface to the First Edition(p. xxi)
• Before You Begin(p. xxiii)
• Part I The Basics(p. 1)
• Chapter 1 Working with Excel(p. 3)
• The Excel Document Window(p. 3)
• Navigating Around the Workbook(p. 5)
• Navigating Around the Worksheet(p. 7)
• Entering Data in a Worksheet(p. 9)
• Excel's Menus: An Overview(p. 13)
• Opening, Closing and Saving Documents(p. 15)
• Printing Documents(p. 18)
• Editing a Worksheet(p. 21)
• Formatting Worksheets(p. 29)
• Number Formatting(p. 35)
• Protecting Data in Worksheets(p. 40)
• Controlling the Way Documents Are Displayed(p. 41)
• Copying from Excel to Microsoft Word(p. 44)
• Useful References(p. 46)
• Chapter 2 Creating Charts: An Introduction(p. 47)
• Only One Chart Type Is Useful for Chemists(p. 47)
• Creating a Chart(p. 47)
• Formatting Charts: An Introduction(p. 50)
• Formatting the Elements of a Chart(p. 51)
• Part II Advanced Spreadsheet Topics(p. 57)
• Chapter 3 Creating Advanced Worksheet Formulas(p. 59)
• The Elements of a Worksheet Formula(p. 59)
• Entering Worksheet Formulas(p. 63)
• Using Names Instead of References(p. 64)
• Worksheet Functions: An Overview(p. 71)
• Math and Trig Functions(p. 72)
• Statistical Functions(p. 73)
• Logical Functions(p. 73)
• Date and Time Functions(p. 76)
• Text Functions(p. 78)
• Lookup and Reference Functions(p. 81)
• Using Insert Function(p. 83)
• Creating "Megaformulas"(p. 85)
• Troubleshooting the Worksheet(p. 87)
• Useful References(p. 89)
• Chapter 4 Creating Array Formulas(p. 91)
• Using Array Formulas(p. 91)
• Evaluating Polynomials or Power Series Using Array Formulas(p. 96)
• Using Array Formulas to Work With Lists(p. 97)
• Using an Array Formula to Sort a 1-D List(p. 104)
• Using an Array Formula to Sort a 2-D List(p. 105)
• Chapter 5 Advanced Charting Techniques(p. 109)
• Good Charts vs. Bad Charts(p. 109)
• Charts with More Than One Data Series(p. 110)
• Extending a Data Series or Adding a New Series(p. 114)
• Customizing Charts(p. 116)
• Changing the Default Chart Format(p. 121)
• Logarithmic Charts(p. 122)
• 3-D Charts(p. 123)
• Charts with Secondary Axes(p. 124)
• Getting Creative with Charts(p. 126)
• Linking Chart Text Elements to a Worksheet(p. 130)
• To Switch Plotting Order in an XY Chart(p. 131)
• Some Chart Specifications (Excel 2000)(p. 132)
• Chapter 6 Using Excel's Database Features(p. 133)
• The Structure of a List or Database(p. 133)
• Sorting a List(p. 133)
• Using AutoFilter to Obtain a Subset of a List(p. 136)
• Defining and Using a Database(p. 138)
• Using Database Functions(p. 145)
• Chapter 7 Getting Data into Excel(p. 147)
• Direct Input of Instrument Data into Excel(p. 147)
• Transferring Files from Other Applications to Excel(p. 147)
• From Hard Copy (Paper) to Excel(p. 151)
• Selecting Every Nth Data Point(p. 154)
• Chapter 8 Adding Controls to a Spreadsheet(p. 159)
• You Can Add Option Buttons, Check Boxes, List Boxes and Other Controls to a Worksheet(p. 159)
• How to Add a Control to a Worksheet(p. 160)
• A List Box on a Worksheet(p. 163)
• A Drop-down List Box on a Worksheet(p. 163)
• Option Buttons and a Drop-down List Box(p. 165)
• Part III Spreadsheet Mathematics(p. 167)
• Chapter 9 Some Mathematical Tools for Spreadsheet Calculations(p. 169)
• Looking Up Values in Tables(p. 169)
• Interpolation Methods: Linear(p. 171)
• Interpolation Methods: Cubic(p. 173)
• Numerical Differentiation(p. 175)
• Numerical Integration(p. 179)
• Differential Equations(p. 182)
• Arrays, Matrices and Determinants(p. 186)
• Polar to Cartesian Coordinates(p. 189)
• Useful Reference(p. 191)
• Chapter 10 Graphical and Numerical Methods of Analysis(p. 193)
• Finding Roots of Equations(p. 193)
• Solving a Problem Using Goal Seek(p. 198)
• Solving a Problem by Intentional Circular Reference(p. 201)
• Solving Sets of Simultaneous Linear Equations(p. 203)
• Chapter 11 Linear Regression(p. 207)
• Least-Squares Curve Fitting(p. 207)
• Multiple Linear Regression(p. 212)
• Using the Regression Statistics(p. 218)
• Useful References(p. 222)
• Chapter 12 Non-Linear Regression Using the Solver(p. 223)
• Non-Linear Functions(p. 223)
• Using the Solver to Perform Non-Linear Least-Squares Curve Fitting(p. 224)
• Statistics of Non-Linear Regression(p. 233)
• Useful References(p. 238)
• Part IV Excel Visual Basic Macros(p. 239)
• Chapter 13 Visual Basic for Applications: An Introduction(p. 241)
• Visual Basic Procedures and Modules(p. 241)
• The Visual Basic Editor(p. 243)
• Getting Started: Using the Recorder to Create a Sub Procedure(p. 245)
• Getting Started: Creating a Simple Custom Function(p. 248)
• Renaming a Macro(p. 250)
• How Do I Save a Macro?(p. 250)
• Chapter 14 Programming with VBA(p. 251)
• Creating Visual Basic Code(p. 251)
• Components of Visual Basic Statements(p. 254)
• Objects, Properties and Methods(p. 255)
• VBA Data Types(p. 261)
• Program Control(p. 265)
• Looping(p. 267)
• Subroutines(p. 269)
• Interactive Macros(p. 270)
• Testing and Debugging(p. 273)
• Useful References(p. 278)
• Chapter 15 Working with Arrays in VBA(p. 279)
• Visual Basic Arrays(p. 279)
• Working With Arrays in Sub Procedures: Passing Values From Worksheet to VBA Module(p. 282)
• Working With Arrays in Sub Procedures: Passing Values From VBA Module to Worksheet(p. 285)
• Working With Arrays in Function Procedures: From Worksheet To Module(p. 288)
• Chapter 16 Creating Command Macros(p. 291)
• Creating Advanced Macros in VBA(p. 291)
• Creating a Simple Sub Procedure to Format Text as a Chemical Formula(p. 291)
• Creating a Sub Procedure to Apply Data Labels in a Chart(p. 295)
• Chapter 17 Creating Custom Functions(p. 299)
• A Custom Statistical Function(p. 299)
• A Function That Takes an Optional Argument(p. 302)
• A Function That Takes an Indefinite Number of Arguments(p. 303)
• Providing a Description for a Function in the Paste Function Dialog Box(p. 306)
• Assigning a Custom Functionto a Function Category(p. 307)
• Creating Add-In Function Macros(p. 307)
• Advantages and Disadvantages of Using Function Macros(p. 308)
• Chapter 18 Creating Custom Menus and Menu Bars(p. 309)
• Modifying Menus or Menu Bars(p. 309)
• Modifying Menus or Menu Bars by Using Visual Basic(p. 313)
• Chapter 19 Creating Custom Tools and Toolbars(p. 317)
• Customizing Toolbars(p. 317)
• Creating Custom Toolbuttons(p. 321)
• Creating a Custom Toolbutton Image(p. 325)
• How to Add a ToolTip to a Custom Button(p. 326)
• Creating Toolbuttons or Toolbars by Means of a Macro(p. 326)
• Part V Some Applications(p. 327)
• Chapter 20 Analysis of Solution Equilibria(p. 329)
• Species Distribution Diagrams(p. 329)
• Analysis of Titration Data(p. 332)
• Simulation of Titration Curves Using a Single Master Equation(p. 337)
• Chapter 21 Analysis of Spectrophotometric Data(p. 339)
• Calibration Curves for Spectrophotometry(p. 339)
• Analysis of Spectra of Mixtures(p. 341)
• Deconvolution of Spectra(p. 344)
• Chapter 22 Calculation of Binding Constants(p. 349)
• Determination of Binding Constants by pH Measurements(p. 350)
• Determination of Binding Constants by Spectrophotometry(p. 359)
• Determination of Binding Constants by NMR Measurements(p. 368)
• Chapter 23 Analysis of Kinetics Data(p. 373)
• Experimental Techniques(p. 373)
• Analysis of Monophasic Kinetics Data(p. 373)
• Analysis of Biphasic Kinetics Data(p. 379)
• Simulation of Kinetics by Numerical Integration(p. 386)
• Part VI Appendices(p. 389)
• Appendix A Selected Worksheet Functions by Category(p. 391)
• Appendix B Alphabetical List of Selected Worksheet Functions(p. 397)
• Appendix C Selected Visual Basic Keywords by Category(p. 417)
• Appendix D Alphabetical List of Selected Visual Basic Keyword(p. 421)
• Appendix E Shortcut Keys for PC and Macintosh(p. 441)
• Appendix F Selected Shortcut Keys by Category(p. 457)
• Appendix G About the CD-ROM That Accompanies This Book(p. 463)
• Index(p. 469)

Reseñas proporcionadas por Syndetics

CHOICE Review

Billo has provided the scientific community with an excellent reference for applying the spreadsheet program Microsoft Excel to chemical calculations, from the most simple to the highly complex. Most scientists effectively use spreadsheet programs to record, summarize, graph, and report numerical data; here, there is explicit information for taking advantage of Excel's extensive calculating power. What is unique and most beneficial to the practicing chemist is that the recording, graphing, and calculating processes are combined into one powerful spreadsheet program that is clearly described and documented. This reviewer, who has used Excel for comprehensive research data, wishes the book had been available earlier. Billo describes the basic operation of Excel and its functions related to recording, summarizing, and graphing so someone with a basic background in science and chemistry can follow. Knowledge of research methods is required to understand and input experimental data directly into Excel. Examples of useful applications of Excel's computing and graphical capabilities are found throughout, as well as examples of the treatment of solution equilibria, spectrophotometric, binding constant, and kinetic data. 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. D. A. Johnson Spring Arbor College

Notas de autor provistas por Syndetics

E. Joseph Billo is an Associate Professor in the Department of Chemistry at Boston College in Chestnut Hill, Massachusetts