Extra sections

Microsoft Excel & Sustainability Consulting

Microsoft Excel Services

Plan

Improve

Future-proof

Workbook scoping: Get help with forming a strategy to turn your data to the results you need

Workbook audits: Find errors and optimize sheets, formulas, tables, charts, and macros

Power Query setup:
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query

Services

Microsoft Excel

Custom eco-design tools
Experienced in developing product footprint and LCA tools.

Sustainability

Dashboards & Models

Workbook troubleshooting and audits
Find errors and optimize sheets, formulas, tables, charts, and macros

Power Query implementation
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query

One-on-one skill training
Learn and practice Excel skills with support from an experienced Excel user

Workbook scoping and architecture
Plan your data and calculations in advance - Measure twice, cut once!

Life cycle assessment
Specializing in LCAs of buildings.

Visualizations and dashboards
See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.

Scenario analysis
Explore how key parameters change your models and analysis.

Uncertainty analysis
Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.

Custom models
Reach out if you would like assistance with developing custom simulations and models.

Building energy modeling
Estimate the energy consumption of your building using EnergyPlus simulations.

Services

Provide a general summary of the services you provide, highlighting key features and benefits for potential clients.

Microsoft Excel

Custom eco-design tools
Experienced in developing product footprint and LCA tools.

black blue and yellow textile
black blue and yellow textile

Sustainability

Dashboards and Models

a man riding a skateboard down the side of a ramp
a man riding a skateboard down the side of a ramp
a man riding a skateboard down a street next to tall buildings
a man riding a skateboard down a street next to tall buildings

Worksheet audits
Troubleshoot and optimize sheets, formulas, tables, charts, and macros.

Power Query
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query.

One-on-one skill training
Learn and practice Excel skills with support from an experienced Excel user.

Worksheet scoping and architecture
Plan your data and calculations in advance - Measure twice, cut once!

Life cycle assessment
Specializing in LCAs of buildings.

Visualizations and dashboards
See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.

Scenario analysis
Explore how key parameters change your models and analysis.

Uncertainty analysis
Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.

Custom models
Reach out if you would like assistance with developing custom simulations and models.

Building energy modeling
Estimate the energy consumption of your building using EnergyPlus simulations.

Dashboards and Models

Hester Analytics has experience with applying genetic algorithms to identify low-cost, low-impact building designs. Reach out to discuss other applications.

Genetic algorithms

Microsoft Excel

Workbook audits

Workbook scoping and architecture

Troubleshoot and optimize sheets, formulas, tables, charts, and macros.

Power Query

Learn and practice Excel skills with support from an experienced Excel user.

Plan your data and calculations in advance - Measure twice, cut once!

One-on-one skill training

Save time and effort with recurring reporting by implementing repeatable data flows in Power Query.

Sustainability

Custom eco-design tools

Life cycle assessments

Product footprint and LCA audits

TEXT

Specializing in LCAs of buildings.

Dashboards and Models

Explore how key parameters change your models and analysis.

Visualizations and dashboards

Scenario analysis

See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.

Uncertainty analysis

Hester Analytics has experience with applying genetic algorithms to identify low-cost, low-impact building designs. Reach out to discuss other applications.

Genetic algorithms

Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.