Regional Learning Alliance
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.
Instructor
Steven Sayko, P.G. (Services Environmental, Inc.)
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 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.
