Advanced Spreadsheet Functionality for Air Quality Compliance

Microsoft® Excel® is widely used by environmental professionals in calculating emissions, compiling environmental reports, keeping operational records, and complying with permit limits. A properly designed spreadsheet can significantly reduce the time spent and potential errors in permitting, compliance and reporting tasks. In this 1-day workshop, new and seasoned environmental professionals learn to use advanced Microsoft Excel functions to streamline environmental tasks. Exercises throughout the class demonstrate real life applications of each function.

This course includes hands-on exercises requiring the use of a computer. Attendees should bring a laptop or notify the instructor if they are unable to do so.

Topics include:

  • Optimizing spreadsheet design and flexibility
  • Most commonly used Excel functions by environmental professionals
  • Introduction to Pivot Tables
  • Tips and keyboard shortcuts
  • Electronic recordkeeping/reporting using Excel
  • CEUs:

    Course topics
    • Basic application of Excel for environmental tasks
    • Improved spreadsheet design and flexibility
    • Using built-in Excel functions for environmental tasks
    • Case studies:
      • Excel functions for emission calculations at Mass Balance operations
      • Excel functions for emission calculations at Combustion operations
    • Electronic recordkeeping using Excel
    • Electronic reporting using Excel
    • Introduction to email functionality in Excel
    Register now


    Apr 09, 2020 -- Orlando, FL
    8:00 AM - 5:00 PM
    Oct 08, 2020 -- Seattle, WA
    8:00 AM - 5:00 PM
    Oct 22, 2020 -- New Orleans, LA
    8:00 AM - 5:00 PM
    What others are saying about this course
    • The instructors showed us how to apply what they were teaching within real tables/databases. This was very helpful and the instructors were very knowledgeable and helpful.
    • Instructors are very helpful and patient.

    Related courses

    You may be interested in these related training courses.

    Introduction to Environmental Regulations (Multimedia)

    This 2-day course is for those who wish to learn about or gain a better understanding of environmental regulations. The course covers such essential topics as air quality permitting and compliance; water quality permitting and compliance; waste management; spill prevention, control and countermeasures planning; emergency planning and community right-to-know; and toxics substances control. The course format includes practice sessions and discussions to review key concepts culminating in a multi-media group exercise of a real scenario. Course completion enables attendees to:

    • Determine which regulations apply and why
    • Understand environmental compliance requirements
    • Develop smart strategies for ensuring on-going compliance

    3 sessions are available starting on Feb 25 - 26, 2020 in Albuquerque, NM ».

    Introduction to Air Quality Regulations

    This 2-day course is for industry and environmental professionals seeking a broad exposure to current U.S. air quality regulations. The course looks at current U.S. regulations, and covers such essential topics as ambient air quality standards, attainment status, construction and operating permits, and various regulatory programs such as NSPS, NESHAPs, NSR and Title V.  Course completion enables attendees to:

    • Determine the applicability of final regulations, and ways to avoid becoming subject to new regulations
    • Identify common compliance pitfalls, and ways to reduce your facility’s air regulatory risks
    • Understand how various federal regulatory programs fit together and the distinguishing characteristics of these programs

    4 sessions are available starting on Mar 19 - 20, 2020 in Houston, TX ».

    Title V Compliance Workshop

    This 1-day course is for new and experienced professionals interested in learning how to minimize the impact of Title V operating permits, reduce duplicate or unnecessary monitoring, and standardize permits across agencies. It provides strategies on how to ensure compliance while minimizing operational intrusions required by Title V permits. Example permit conditions are discussed to illustrate how agencies and companies have approached compliance demonstration requirements. Information on when to re-open a permit and the modification process will be provided.

    5 sessions are available starting on Feb 20, 2020 in Charlotte, NC ».

    Introduction to Environmental Reporting and Recordkeeping Requirements

    This 2-day course is designed for plant and corporate staff who need to know how to perform or manage compliance reporting and recordkeeping activities. The course covers such essential reporting topics as Tier II, TRI, air emissions, Title V, releases, hazardous waste, toxic substances, and water discharges. The course format includes best practices, common problems, and group exercises intended to maximize understanding of this challenging material. Course completion will enable attendees to:

  • Set up and organize a recordkeeping system
  • Determine reporting applicability and correctly complete required reports
  • Improve compliance and minimize NOVs due to reporting and recordkeeping problems
  • 2 sessions are available starting on Feb 27 - 28, 2020 in Albuquerque, NM ».