Excel 2013 for Scientists

Equivalent to a three-day course in Excel, this thorough and entertaining CD-ROM contains 600 slides of self-paced training revolving specifically around how scientists can best utilize the popular spreadsheet program. With updated information on Excel 2010 and 2013, the CD-ROM is based on the author's professional training sessions and provides multiple-choice questions as efficient progress markers. Among the techniques taught are how to add a trend line to a chart in two clicks, when to use PEARSON instead of CORREL, creating a multifactorial or polynomial trendline, including error bars on a chart, using a hidden worksheet for data validation lists, and many others tailored to what scientists need most when using Excel and the common pitfalls that may occur.