ATU Sligo /ATU St Angela's

go

Amazon cover image
Image from Amazon.com

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.369
Contents:
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.
Summary: This edition provides a guide to Excel 2007 and explores all the applications that allow chemists to process, analyse and present scientific data efficiently.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Copy number Status Date due Barcode Item holds
Standard Loan Standard Loan ATU Sligo Yeats Library Main Lending Collection 005.369 BIL (Browse shelf(Opens below)) 1 Available 0092120
Standard Loan Standard Loan ATU Sligo Yeats Library Main Lending Collection 005.369 BIL (Browse shelf(Opens below)) 2 Available 0092119
Total holds: 0

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.

Share