Trinity Consultants
- Home
- Companies
- Trinity Consultants
- Training
- Advanced Spreadsheet Functionality for ...
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.
Most popular related searches
air quality compliance
emissions accounting
electronic reporting
environmental reporting
air compliance
compliance reporting
emissions reporting
environmental design
environmental data
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
Course Topics
- Basic application of Excel for environmental tasks
- Improved spreadsheet design and flexibility
- Using build-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 record keeping using Excel
- Electronic reporting using Excel
- Introduction to email functionality in Excel