Skip to main content

Billo, E. Joseph

Billo, E. Joseph

PERSONAL:

Male.

CAREER:

Boston College, Boston, MA, former associate professor of chemistry; currently presents computer program courses to scientists throughout the United States, Canada, and Europe.

WRITINGS:

Excel for Chemists: A Comprehensive Guide, Wiley-VCH (New York, NY), 1997, 2nd edition, 2001.

Excel for Scientists and Engineers: Numerical Methods, John Wiley (Hoboken, NJ), 2007.

SIDELIGHTS:

E. Joseph Billo, a former associate professor of chemistry at Boston College, has developed two short courses: "Advanced Excel for Scientists and Engineers" and "Excel Visual Basic Macros for Scientists and Engineers." He has presented these courses to thousands of scientists throughout the United States, Canada, and Europe via organizations such as the American Chemical Society, the National Cancer Institute, Procter & Gamble, Shell, and Texaco. He is also the author of books on how to use Excel that focus on a specific target audience of scientists in various disciplines. Excel, also known as Microsoft Office Excel, is a spreadsheet computer program that includes features such as graphing tools, pivot tables, and a programming language called Visual Basic Applications (VBA). It was the first spreadsheet that enabled users to define the appearance of their spreadsheets via fonts and character attributes, along with extensive graphing capabilities.

In his first book, Excel for Chemists: A Comprehensive Guide, published in 1997 with a second edition published in 2001, the author provides a comprehensive tutorial on using spreadsheets specifically for the chemist wishing to present scientific data. "Spreadsheets perform … repetitive calculations for you, automatically ensuring that any result which is dependent on a value which has changed will be recalculated, and the results of any change will be reflected throughout the whole sheet," explained Peter Biggs in a review of the first edition for Chemistry and Industry. "It doesn't take a leap of faith to see how this tool can be applied to repetitive scientific calculations."

The author pays special attention to teaching chemists how to make full use of the program's scientific calculating abilities to process, analyze, and present scientific data. In the second edition, the author updates information on changes to Excel and includes many new examples of how it can be used. The book includes illustrations and examples of chemical applications and step-by-step instructions for programming Excel to automate repetitive data-processing tasks. The author also includes tips on working with the program faster and more simply. A CD-ROM is included, containing spreadsheet templates, macros, and other tools. "With the lamentable decline in the ability of many researchers to program anything more complicated than their video recorder, it is becoming more important that they become familiar with tools such as Excel," wrote Biggs in Chemistry and Industry.

Excel for Scientists and Engineering: Numerical Methods contains many of the same features as the author's previous book and includes a CD-ROM, too. This guide focuses on a wider range of scientists and helps readers' improve their abilities to execute calculations needed to solve chemical, biochemical, physical, engineering, biological, and medicinal problems. "No background in programming is needed," noted a reviewer in SciTech Book News.

BIOGRAPHICAL AND CRITICAL SOURCES:

PERIODICALS

Chemistry and Industry, September 7, 1998, Peter Biggs, review of Excel for Chemists: A Comprehensive Guide, p. 694.

Choice, March, 1998, review of Excel for Chemists, p. 1217; October, 2007, D.A. Johnson, review of Excel for Scientists and Engineers: Numerical Methods, p. 314.

Journal of Chemical Education, June, 2000, Jeffery Greathouse, review of Excel for Chemists, p. 705.

SciTech Book News, September, 1997, review of Excel for Chemists, p. 34; September, 2001, review of Excel for Chemists, 2nd edition, p. 58; June, 2007, review of Excel for Scientists and Engineers.

Cite this article
Pick a style below, and copy the text for your bibliography.

  • MLA
  • Chicago
  • APA

"Billo, E. Joseph." Contemporary Authors. . Encyclopedia.com. 19 Nov. 2018 <https://www.encyclopedia.com>.

"Billo, E. Joseph." Contemporary Authors. . Encyclopedia.com. (November 19, 2018). https://www.encyclopedia.com/arts/educational-magazines/billo-e-joseph

"Billo, E. Joseph." Contemporary Authors. . Retrieved November 19, 2018 from Encyclopedia.com: https://www.encyclopedia.com/arts/educational-magazines/billo-e-joseph

Learn more about citation styles

Citation styles

Encyclopedia.com gives you the ability to cite reference entries and articles according to common styles from the Modern Language Association (MLA), The Chicago Manual of Style, and the American Psychological Association (APA).

Within the “Cite this article” tool, pick a style to see how all available information looks when formatted according to that style. Then, copy and paste the text into your bibliography or works cited list.

Because each style has its own formatting nuances that evolve over time and not all information is available for every reference entry or article, Encyclopedia.com cannot guarantee each citation it generates. Therefore, it’s best to use Encyclopedia.com citations as a starting point before checking the style against your school or publication’s requirements and the most-recent information available at these sites:

Modern Language Association

http://www.mla.org/style

The Chicago Manual of Style

http://www.chicagomanualofstyle.org/tools_citationguide.html

American Psychological Association

http://apastyle.apa.org/

Notes:
  • Most online reference entries and articles do not have page numbers. Therefore, that information is unavailable for most Encyclopedia.com content. However, the date of retrieval is often important. Refer to each style’s convention regarding the best way to format page numbers and retrieval dates.
  • In addition to the MLA, Chicago, and APA styles, your school, university, publication, or institution may have its own requirements for citations. Therefore, be sure to refer to those guidelines when editing your bibliography or works cited list.