Làm chủ phân tích Năng lượng bằng Excel và BI - Từ con số 0 đến chuyên gia

Learn practical Excel skills while analyzing real energy and sustainability data. Build dashboards, clean and model data, estimate savings, and report GHG emissions (Scope 1, 2, 3) using recognized frameworks.

What you’ll learn

• Modeling & forecasting in Excel for baselines, savings, and scenarios.

• End-to-end projects: lighting and motor/VSD savings calculators, baseline & savings workbook.

• Energy analysis fundamentals and how to apply them to real projects.

• GHG reduction analysis and a clear walkthrough of Scopes 1, 2, and 3.

• Sustainability reporting basics: GRI and TCFD—what they are and how data flows into them.

• Excel mastery: tables, PivotTables, LOOKUPs/XLOOKUP, IF/SUMIFS, charts, and what-if tools.

• Data Visualization using Power BI

  
  

Who this course is for

• Beginners who want a practical start in energy/sustainability analytics.

• Professionals (energy analysts, renewable-energy and sustainability practitioners, engineers) who need Excel skills for day-to-day work.

• Students in engineering, environmental science, or sustainability who want portfolio-ready projects.

How you’ll learn

• Short, step-by-step videos with downloadable workbooks.

• Hands-on exercises and quizzes to lock in skills.

• Realistic datasets from conventional and renewable energy use cases.

• Lifetime access and updates.

Outcomes
By the end, you’ll be able to clean and analyze energy data in Excel, build interactive Power BI dashboards, calculate savings and KPIs, and summarize GHG emissions for reporting—skills you can apply immediately to energy and sustainability projects.