Excel for chemists : a comprehensive guide /
By: Billo, E. Joseph.
Publisher: Hoboken, N.J. : Wiley, 2011Edition: 3rd ed.Description: xxviii, 732 p. : ill. ; 26 cm + 1 CD-ROM.Content type: text Media type: unmediated Carrier type: volumeISBN: 9780470381236 (pbk.); 9780470381236:; 047038123X (pbk.).Subject(s): Microsoft Excel (Computer file) | Chemistry -- Data processing | Chemistry -- Computer programs | Electronic spreadsheets | Electronic spreadsheets -- Computer programsDDC classification: 005.369Item type | Current library | Call number | Copy number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|
Standard Loan | ATU Sligo Yeats Library Main Lending Collection | 005.369 BIL (Browse shelf(Opens below)) | 1 | Available | 0092120 | ||
Standard Loan | ATU Sligo Yeats Library Main Lending Collection | 005.369 BIL (Browse shelf(Opens below)) | 2 | Available | 0092119 |
Includes index.
Contents -- Preface to the third edition -- Before you begin -- Part I : the basics. Chapter 1 : working with Excel 2007 or Excel 2010. Chapter 2 : working with Excel 2003. Chapter 3: Excel formulas and functions. Chapter 4 : Excel 2007/2010 charts. Chapter 5 : Excel 2003 charts -- Part II : advanced spreadsheet topics. Chapter 6 : advanced worksheet formulas. Chapter 7 : array formulas. Chapter 8 : advanced charting techniques. Chapter 9 : using Excel's database features. Chapter 10 : importing data into Excel. Chapter 11 : adding controls to a spreadsheet. Chapter 12 : other language versions of Excel -- Part III : spreadsheet mathematics. Chapter 13 : mathematical methods for spreadsheet calculations. Chapter 14 : linear regression and curve fitting. Chapter 15 : nonlinear regression using the solver -- Part IV : Excel's visual basic for applications. Chapter 16 : visual basic for applications : an introduction. Chapter 17: programming with VBA. Chapter 18 : working with arrays in VBA -- Part V : some applications of VBA. Chapter 19 : command macros. Chapter 20 : custom functions. Chapter 21 : automatic procedures. Chapter 22 : custom menus. Chapter 23 : custom toolbars and toolbuttons -- Part VI : appendices. Appendix A : what's Wwere in Excel 2007/2010. Appendix B : selected worksheet functions by category. Appendix C : alphabetical list of selected worksheet functions. Appendix D : renamed functions in Excel 2010. Appendix E : selected visual basic keywords by category. Appendix F : alphabetical list of selected visual basic keywords. Appendix G : selected Excel 4 macro functions. Appendix H : shortcut keys by keystroke. Appendix I : selected shortcut keys by category. Appendix J : ASCII Codes. Appendix K : contents of the CD-ROM -- Index.
This edition provides a guide to Excel 2007 and explores all the applications that allow chemists to process, analyse and present scientific data efficiently.
System requirements for CD-ROM: Windows, most workbooks are in 2003 format (.xls) and can be read by users with Excel 97/2000/2003 or Excel 2007/1010.