A basic excel class for Energy Auditors focusing on the the fundamentals of Excel.This training will be offered at a very basic level and is not recommended for anyone proficient with advanced Excel functionality, such as macros. Location: San Francisco, CA
REGISTER: https://pge-web.ungerboeck.com/classcalendar/Details.aspx?OrgCode=10&EventId=16873
This Excel class will be offered at a basic level and is not recommended for anyone proficient with fundamental Excel functionality. We will spend the bulk of the class on the following topics: navigation in excel, key-pad short cuts, formatting data, creating graphs, and calculations (formulas). We will use common energy audit applications for in-class exercises and examples. We will perform calculations on utility billing data, create project schedules and organize tables of information in this hands-on training. At the end of the day we will look at some of the more advanced capabilities of the software, including regressions, pivot tables, and macros. Individuals interested in just these three advanced excel topics are welcome to attend just the last hour of the “Basic Excel for Energy Auditors” class.