The scientists and technicians at my workplace use MS Excel (several versions) as their default lab notebook. They vary greatly in their ability to analyze and summarize their data once it is gathered. I get "Can Excel do such-and-so?" questions frequently.
I'll gather useful techniques and tips in these posts. For those who are really new to using Excel, I recommend the following online tutorials:
GCF Global Learning®: Free tutorials in six areas, including Office 97, 2000, 2002(XP), and 2003. The Excel 2003 section has 27 modules. Free membership registration required.
Microsoft Online Training: Office 2003 and 2007. The Excel 2003 section has 38 courses, each with a few dozen modules.
You will also benefit from a book or two. I have three of the four listed below. Were I starting over, I'd get the "dummies" book first:
Excel for Dummies by Greg Harvey, PhD: http://www.dummies.com/WileyCDA/DummiesTitle/productCd-1568840500.html
Excel 2003 Bible and Excel 2007 Bible by John Walkenbach: http://www.amazon.com/exec/obidos/search-handle-url/index=stripbooks&field-keywords=excel%20bible&results-process=default&dispatch=search/ref=pd_sl_aw_tops-1_stripbooks_4245308_2&results-process=default
Excel for Chemists by E. Joseph Billo, PhD: http://www.amazon.com/Excel-Chemists-Comprehensive-Guide-2nd/dp/0471394629
Excel for Scientists & Engineers by Gerard Verschuuren: http://www.amazon.com/Excel-Scientists-Engineers-Professionals/dp/193280210X
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment