Billo, E. Joseph.

Excel for chemists : a comprehensive guide / E. Joseph Billo. - 2nd ed. - New York ; Chichester : Wiley, 2001. - 512p.

Includes CD-ROM.

Includes bibliographical references and index.

Part I.The basics -- 1.Working wit Excel -- 2.Creating charts: an introduction -- Part II.Advanced spreadsheet topics -- 3.Creating advanced worksheet formulas -- 4.Creating array formulas -- 5.Advanced charting techniques -- 6.Using Excel\'s databse features -- 7.Imporiting data into Excel -- 8.Adding controls to a spreadsheet -- Part III.Spreadsheet mathematics -- 9.Some mathematical tools for spreadsheet calculations -- 10.Graphical and numerical methods of analysis -- 11.Linear regression -- 12.Non-linear regeression using the Solver -- Part IV.Excel visual basic macros -- 13.Visual basic for applications: an introduction -- 14.Programming with VBA -- 15.Working with arrays in VBA -- 16.Creating command macros -- 17.Creating custom functions -- 18.Creating custom menus and menu bars -- 19.Creating custom toolbuttons and toolbars -- Part V.Some applications -- 20.Analysis of solution equilibria -- 21.Analysis of spectrophotometric data -- 22.Calculation of binding constants -- 23.Analysis of kinetics data.

This edition provides a guide to Excel 2000 and explores all the applications that allow chemists to process, analyse and present scientific data efficiently.

9780471394624 (hbk.) : £35.95 9780471394624


Microsoft Excel (Computer file)


Microsoft Excel.
Chemistry--Data processing
Electronic spreadsheets
Chemistry--Computer programs
Science.
Chemistry
Spreadsheet software
Computer science

QD39.3

542.855369 BIL