Main Content
Jump to: Register | Course Details | Overview | Instructor | Reviews | CE Credits | Requirements | 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: EO0137WA23
Date: November 9, 2022
Time: 8:30 am – 12:30 pm (Check-in time: 8:00 am)
Location: Online
Format: Live, instructor-led
Registration Fee: $135 per person
Multi Person Discount Fee: $99 per person (Save when you sign up with a colleague!)
NJLWO Discount Fee: $67.50 per person (available for T, W, and VSWS license holders only)
Registration Closes: November 7, 2022
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.
Featured Topics
- 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
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.
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 Microsoft Excel for Water and Wastewater Operators course is approved for 0.35 Rutgers CEUs, as well as the following credits from professional organizations.
New Jersey
NJ Certified Public Works Managers (CPWM): 3.5 Technical Contact Hours
NJ Drinking Water and Wastewater Operators: 3.5 TCHs (Approval #01-102101-30)
Course Requirements and Policies
Technology Requirements
This online course will be delivered via Rutgers Canvas learning management system and Zoom.
Equipment you will need to access this training:
- Laptop or desktop computers with Microsoft Excel installed are required for this class.
- Speakers and microphone are not necessary as a call-in option is available.
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. If you do not see this message in your inbox, please check your junk/spam folder. 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 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
Photo 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.
Cancellations and Substitutions
A $25 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.
Assistant Director: Carol Broccoli
848-932-7207
carolbr@njaes.rutgers.edu
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.
