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

  • April 30, 2019
  • 8:00 AM - 4:30 PM
  • Regional Learning Alliance, 850 Cranberry Woods Drive, Cranberry Twp., PA
  • 0

Registration

  • Registration closes April 24 or when sold out.
  • Non-member registration closes April 17, 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

Sold Out.  We do not maintain a wait list.



Regional Learning Alliance (MSA Auditorium)
850 Cranberry Woods Drive    DIRECTIONS
Cranberry Twp., 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 

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

Level:  Intermediate/Advanced

Download Agenda

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.

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.

    

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 closer to the event date 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.