Sold Out. We do not maintain a wait list.
Regional Learning Alliance (MSA Auditorium) 850 Cranberry Woods Drive DIRECTIONS Cranberry Twp., PA
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:
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.