ENRG 51: Excel for Energy Auditing

This 3-page outline provides information about the ENRG 51: Excel for Energy Auditing course that's part of the Commercial Building Energy Analysis and Audits program at City College of San Francisco. This program is intended to prepare students to conduct energy audits, evaluate building systems for efficiency, analyze energy data, and apply financial and business strategies in audit reporting.

This course provides an "overview of Microsoft Excel as used for common engineering applications, with a focus on energy savings calculations." Excel basics are covered. Some advanced topics are also covered and include regressions, pivot tables, lookup, dates, and macros. This outline includes a course description, learning outcomes, course topics, types of assignments, and textbooks and resources needed. Course topics include: Exel fundamentals, creating and interpreting graphs, excel functions, regression analysis, and excel macros.

After completing the course, students should be able to:

• Demonstrate fundamental use of spreadsheet basics.
• Create and interpret graphs.
• Illustrate the use of Excel's built-in functions and the functions commonly used by engineers
• Interpret simple regression analysis directly from graph data using various trend lines
• Create and apply macros and pivot tables on existing data