More than a data table: Get More From Your Groundwater Data Using MS Excel (435 mins.)

  • March 12, 2019
  • 8:00 AM - 4:30 PM
  • PSU Great Valley, 30 E. Swedesford Rd., Malvern, PA
  • 0


  • Registration closes March 7 or when sold out.
  • Non-member registration opens February 3 and closes March 7, or when sold out. To save $90 on the cost of this event, return to home page and Join PCPG.

Be sure your browser settings allow pop-up windows. System automatically emails receipt upon payment completion. If online payment transaction is unsuccessful, enrollment record is discarded.
Registration is closed
PSU Great Valley
Rooms 205/206 CCB Building
30 E. Swedesford Rd.     DIRECTIONS
Malvern, PA

8:00-8:30  Registration and AM Refreshments
12:00        Lunch Provided
4:30          Adjourn/Complete Course evaluation and pick-up certificate of attendance

Professional Development Conversion
DE, SC 60 mins. = 1 CEU
PA 50 mins. = 1 PDH

Steven Sayko, P.G. (Services Environmental, Inc.)

Download Agenda

Overview:  Geologists and Environmental Professionals collect lots of site data and typically use Microsoft Excel to prepare attractive report tables.  Excel has the power to enable you to get more from your data than attractive tables. The objective of this course is to demonstrate how Excel can be used to explore your data and better understand site conditions using groundwater data from actual investigations. Approximately 40% of the class will be hands-on working with Excel.  Effectively presentation of data will also be discussed.  The case history examples are based on the instructor's 30-year career as a hydrogeologist.  

Course topics include:

  • Structuring tables for data analysis,
  • Database vs a Crosstab (matrix or Pivot Table style) tables,
  • Numeric formatting and conditional formatting,
  • Sorting and Filtering data,
  • Constructing and deconstructing Pivot Tables,
  • Preparing hydrographs, concentration vs time, histograms, and well detail graphs,
  • Using slider bars for dynamic graphs,
  • VLOOKUP and OFFSET functions, and
  • An assortment of experienced-based issues with spreadsheets, data collection, spotting outlier data, and working with transducer data.


IMPORTANT:  To get the most from this class, please come prepared.  Past classes using the attendee's computers have encountered difficulties opening files and running software.  There will be no one-on-one IT support in class to address hardware or software issues.  Before the class, please check that your computer will open the example worksheets and will run without attachment to your company network.    See additional requirements below.

Attendees should have “intermediate” skills with Excel, e.g., you know what “=SUM(A2:A14)” is, can copy and paste, and can create a basic graph.  The course will be about 60% lecture and 40% hands-on practice using example spreadsheets.  The example spreadsheets will be made available and should be downloaded before coming to the class.

You will need your own computer with Excel.  The course will be presented using Excel 2016 and this is the recommended version of Excel.  However, most of the examples will work in Excel 2010 and 2013.  If possible, make sure the Add-in for Data Analysis is active.  An internet connection is not required for the course. 

Pennsylvania Council of Professional Geologists
116 Forest Drive, Camp Hill, Pennsylvania 17011

Powered by Wild Apricot Membership Software