Microsoft Excel for Water and Wastewater Operators

Discover how you can excel at Microsoft Excel in this class that focuses on practical applications for workplaces in the water and wastewater fields.

Main Content

Man Working With Spreadsheet Data on Computer

Course Status: Not Currently Scheduled

We do not have an offering of this course scheduled at this time. Please join our email list to be notified when the next offering is scheduled!

Jump to: Overview | Instructor | Reviews | CE Credits | Contact Us | Related Courses | Join Email List

Register Now

Pay with Credit Card:

Pay with Check, PO, or Money Order:

Course Details

Course Name: Microsoft Excel for Water and Wastewater Operators
Course Code: EO0137WB22

Date: March 30, 2022
Time: 8:30 am – 12:30 pm EDT

Location: Online
Format: Live, instructor-led

Registration Fee: TBD
Multi Person Discount Fee: TBD (save when you sign up with a colleague!)

Registration Closes: TBD

Paying with a check, money order, or purchase order?
Payments should be made out to: Rutgers, The State University of New Jersey
Checks and money orders should be mailed to: Office of Continuing Professional Education, Attn: Registration Dept., 102 Ryders Ln, New Brunswick, NJ 08901-8519
Purchase Orders can be mailed to the address above or electronically sent to registration@njaes.rutgers.edu.

Course Overview

Water and wastewater operators often have tasks that include the monitoring of complex water quality parameters, preparation of state forms, and analysis of financial information, just to list a few items that deal with a lot of numbers and sometimes calculations. This class will introduce you to Microsoft Excel and fundamental techniques to help you obtain critical information from the data you have collected and to be able to distill this information so that it may be provided to others.

NOTE: The class will include some exercises for the attendees to work on as a technique is explained. It is therefore essential that all attendees have Microsoft Excel installed on the computer that they are using during the class.

  • Introduction to Navigating in Microsoft Excel
  • Organizing Your Data into Fields
  • Copying and Pasting Data
  • Creating Worksheets within a Workbook
  • Performing Calculations and Creating Formulas (starting with basic and working up to some higher order calculations)
  • Cell and Worksheet References
  • Conditional Formatting
  • Graphing
  • Plus some other tips and tricks of the trade!

Who Should Attend?

If you work in the water or wastewater operations field and want to learn how to work more quickly and efficiently with Excel spreadsheets, this class is for you! Past participants have included:

  • EHS Consultants
  • Laborers
  • Project Managers
  • Technical Assistance / Facilities Maintenance Supervisors
  • Water and Wastewater Treatment Operators
  • Utility Technicians

Meet Your Instructors

Stacy A. Cacallori

Headshot of instructor Stacy Cacallori

Stacy’s career includes consulting experience and over twenty-five years of increasing responsibility for leadership and hands-on project management of a 61,000-customer public water utility, including reporting and administrative functions. Her formal education encompasses leadership, business administration, management, and communication skills, as well as a certificate of proficiency in training adults.

William Mitchell, Jr.

Headshot of instructor William Mitchell, Jr.

William Mitchell, Jr.’s professional experience includes 32+ years of experience with Trenton Water Works and 2+ years at CME Associates. He holds the following licenses: NJDEP T4 license for water treatment, NJDEP W-4 license for water distribution, and PA A-1 license for water treatment. His educational background includes a B.S. degree in Biology with minors in Chemistry and Psychology from the College of New Jersey and a B.S. degree in Civil Engineering from Drexel University.

Student Reviews

Most useful part of the course: “Use of IF/Then Formulas, Use of Anchors, and Creating Charts.”

– Past Participant

“Expanded my knowledge of Excel formulas and tasks.”

– Past Participant

“[I learned] The formula for Pi in Excel! Useful for volume measurements!”

– Past Participant

Continuing Education Credits

The most recent offering of Microsoft Excel for Water and Wastewater Operators was approved for the following credits from professional organizations. We will reapply for similar credits the next time the course runs, but we cannot guarantee credit approval for future offerings.

The Microsoft Excel for Water and Wastewater Operators course is approved for 0.35 Rutgers CEUs, as well as the following credits from professional organizations.

State of New Jersey map iconNew Jersey

NJ Certified Public Works Managers (CPWM): Pending

NJ Drinking Water and Wastewater Operators: 3.5 TCHs (Approval #01-102101-30)

Course Requirements and Policies

electronic devices iconTechnology Requirements

This online course will be facilitated on the Canvas Virtual Platform. It is recommended that you access the course using a computer (desktop or laptop) with a high-speed internet connection. A built-in laptop microphone or external microphone can be used. You also have the option to call in to hear the live class. Webcams are optional. Kindly note that this training is best viewed using the Chrome web browser. Tablets can also be used. If you plan to access the course using a mobile device, you should download the Canvas app. Please review this link for information: https://community.canvaslms.com/docs/DOC-10567.

Once you register with OCPE, you will receive an email from “Rutgers University Canvas” saying, “Click here to finish the registration process,” to create your new account in the Canvas Virtual Platform. The course shell will not open until a week before the start date of class. You will receive an email from Claudine Oleskin with directions and more details for the class.

email iconEmail Requirement

A unique email address is required for each registrant to register and access our courses.

  • If this is your first time registering with us, please provide your own unique email address when registering; do not provide an email address that you share with co-workers.
  • If you have previously taken classes with us and have used an email address that you share with your co-workers or supervisor, your account must be updated with a unique email address. To do this, please send an email to us at registration@njaes.rutgers.edu stating that your email address needs to be changed and include:
    • Your full name
    • The shared email address that needs to be changed
    • Your unique email address
    • A phone number where you can be reached if we have any questions

camera iconPhoto ID Requirement

Each registrant will be asked provide a photo of him/herself holding their government-issued photo ID. This is required by credit boards so that you may receive credits for participating in this online course.

  • You will receive a reminder email prior to the start of the class with further instructions. Wait to receive these instructions before you attempt to upload your ID.
  • The photo must be clear enough that we can read your name and verify that the person pictured on the ID is in fact the person holding it.
  • The photo must be clear enough that we can read your name and verify that the person pictured on the ID is in fact the person holding it.
  • After an OCPE staff member reviews the picture and verifies your identity, you will have access to participate in the course when it begins.

x icon with circle around itCancellations and Substitutions

A $100 cancellation fee applies for this course. Substitutions are permitted. View our cancellation policy.

Program Questions? We’re Here to Help!

If you have any questions about Microsoft Excel for Water and Wastewater Operators, please don’t hesitate to reach out to us.

Headshot of Rutgers Assistant Director Carol Broccoli

Assistant Director: Carol Broccoli
848-932-7207
carolbr@njaes.rutgers.edu

Rutgers University Shield

Administrative Assistant: Claudine Oleskin
848-932-7204
coleskin@njaes.rutgers.edu

For registration assistance, please contact our Registration Department at 848-932-9271, option 2 or email registration@njaes.rutgers.edu.

Big Data and related icons over image of two professionals looking at bar graph on computer screen

Big Data – What It Is and Why You Need to Know

Group of wastewater operators assessing plant performance

Math Refresher for Water and Wastewater Operations

Chemistry concept with atomic model and vials of liquid

Water and Wastewater Chemistry: Back to the Basics

white envelope icon with @ sign representing email

Join Our Email List!