EGLL 1001 - EXCEL for Engineers and Scientists: Learning Enhanced Techniques

This web course is designed to teach you how to use some of the features of EXCEL that are particularly relevant to engineering and water resources analysis. The course will use various examples of applications of EXCEL that demonstrate the features presented in the course. Each topic will be presented using a computer-based video tutorial. Participants will have a companion spreadsheet that they develop following the detailed instructions in the video tutorials. The course will be based on EXCEL 2007. Note that many of the topics presented in the course are applicable to previous versions of EXCEL.

This course is open-entry which means that students can enroll at any time and have six months from their registration date to complete the course.

Noncredit courses do not produce academic credit nor appear on a Colorado State University academic transcript.

Important Information

This course is designed for all water managers, scientists and engineers that regularly use EXCEL. Participants should have a basic familiarity with EXCEL spreadsheets, including the ability to write formulas and create graphs. No prior experience with macros or Visual Basic for Applications programming is required. For more information email Darrell.Fontane@ColoState.Edu or call (970) 491-5248.

Textbooks and Materials

All of the course materials will be online and no textbook is required.

Instructors

Darrell Fontane
(970) 491-5248
fontane@engr.colostate.edu

Dr. Darrell G. Fontane is Director of the International School for Water Resources and Professor of Civil and Environmental Engineering at Colorado State University. He has been developing civil engineering models in spreadsheets and teaching civil engineering students to develop spreadsheet applications since 1989. He has conducted numerous training sessions on water resources systems analysis, decision support systems and computing technologies worldwide. He has presented the EXCEL for Engineers and Scientists: Learning Enhanced Techniques (EXCEL-LEnT) workshop to groups in the US Geological Survey and the US Bureau of Reclamation, at Federal Interagency Modeling Conferences, and internationally in Sao Paulo, Brazil, and in Taejon, South Korea.