Skip to content
Register Sign in Wishlist
How to Use Excel® in Analytical Chemistry

How to Use Excel® in Analytical Chemistry
And in General Scientific Data Analysis

$120.00 (X)

  • Date Published: February 2001
  • availability: Available
  • format: Paperback
  • isbn: 9780521644846

$ 120.00 (X)

Add to cart Add to wishlist

Other available formats:
Hardback, eBook

Request examination copy

Instructors may request a copy of this title for examination

Product filter button
About the Authors
  • Spreadsheets provide one of the most easily learned routes to scientific computing. This book uses Excel®, the most powerful spreadsheet available, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of college textbooks in analytical chemistry: statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. The text contains many examples of data analysis, and uses spreadsheets for numerical simulations and testing analytical procedures. It treats modern data analysis methods such as linear and nonlinear least squares in great detail, as well as methods based on Fourier transformation. It shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet. It describes in detail how to simulate chemical kinetics on a spreadsheet. It also introduces the reader to the use of VBA, the macro language of Microsoft Office, which lets the user import higher-level computer programs into the spreadsheet.

    • The only up-to-date text on the use of spreadsheets in chemistry
    • Two-colour throughout
    • Uses powerful method for fitting experimental titration curves and a graphic introduction to Fourier transformation
    • Suitable for the most up-to-date version of Excel, compatible with Excel 97 (PC), Excel 5 (Windows 3.1), Excel 95 (Windows 95) and Excel 98 (Mac)
    Read more

    Reviews & endorsements

    "...smoothly written, excellent tutorial about how such spreadsheets are created...very good book. No analytical chemistry teacher, no serious analytical chemistry student, should fail to acquire this book." The Chemical Educator

    Customer reviews

    Not yet reviewed

    Be the first to review

    Review was not posted due to profanity


    , create a review

    (If you're not , sign out)

    Please enter the right captcha value
    Please enter a star rating.
    Your review must be a minimum of 12 words.

    How do you rate this item?


    Product details

    • Date Published: February 2001
    • format: Paperback
    • isbn: 9780521644846
    • length: 502 pages
    • dimensions: 249 x 176 x 26 mm
    • weight: 1.017kg
    • contains: 143 b/w illus. 13 tables
    • availability: Available
  • Table of Contents

    Part I. Introduction to Using the Spreadsheet:
    1. How to use Excel
    Part II. Statistics and Related Methods:
    2. Introduction to statistics
    3. More on least-squares
    Part III. Chemical Equilibria:
    4. Acids, bases, and salts
    5. Other ionic equilibria
    Part IV. Instrumental Methods:
    6. Spectrometry, chromatography, and voltammetry
    Part V. Mathematical Methods:
    7. Fourier transformation
    8. Standard mathematical tools
    9. Numerical simulation of chemical kinetics
    Part VI. Spreadsheet Programming:
    10. Macros.

  • Resources for

    How to Use Excel® in Analytical Chemistry

    Robert de Levie

    Find resources associated with this title

    Type Name Unlocked * Format Size

    Showing of

    Back to top

    This title is supported by one or more locked resources. Access to locked resources is granted exclusively by Cambridge University Press to instructors whose faculty status has been verified. To gain access to locked resources, instructors should sign in to or register for a Cambridge user account.

    Please use locked resources responsibly and exercise your professional discretion when choosing how you share these materials with your students. Other instructors may wish to use locked resources for assessment purposes and their usefulness is undermined when the source files (for example, solution manuals or test banks) are shared online or via social networks.

    Supplementary resources are subject to copyright. Instructors are permitted to view, print or download these resources for use in their teaching, but may not change them or use them for commercial gain.

    If you are having problems accessing these resources please contact

  • Instructors have used or reviewed this title for the following courses

    • Analytical Chemistry
    • General Chemistry ll
    • Instrumental Analysis
  • Author

    Robert de Levie, Bowdoin College, Maine

Sorry, this resource is locked

Please register or sign in to request access. If you are having problems accessing these resources please email

Register Sign in
Please note that this file is password protected. You will be asked to input your password on the next screen.

» Proceed

You are now leaving the Cambridge University Press website. Your eBook purchase and download will be completed by our partner Please see the permission section of the catalogue page for details of the print & copy limits on our eBooks.

Continue ×

Continue ×

Continue ×
warning icon

Turn stock notifications on?

You must be signed in to your Cambridge account to turn product stock notifications on or off.

Sign in Create a Cambridge account arrow icon

Find content that relates to you

Join us online

This site uses cookies to improve your experience. Read more Close

Are you sure you want to delete your account?

This cannot be undone.


Thank you for your feedback which will help us improve our service.

If you requested a response, we will make sure to get back to you shortly.

Please fill in the required fields in your feedback submission.