Webinars

Webinars / Online training courses On-Demand

M&Excel Training I: Data input and management in Excel

This hands-on training will show you how you can use a handful of Excel formulas and some creativity to structure and process monitoring data. Macros and Visual Basic knowledge are not necessary! 

Contents:

• Comparisons and totals: Set limits and calculate totals according to certain criteria
• Working with dates: Keeping track of deadlines and simplifying bookkeeping
• Conditional formatting: Creation of "traffic lights" system

This Excel training focuses on data processing and visual data output, not on statistical analysis.

Please note that the participation in this Excel training is recommended only with certain basic knowledge of Excel (see checklist).

Language: English

Training time: 2 Hours

The participation fee is 99€. Please contact support@energypedia-consult.com if you wish to register for this online training.

M&Excel Training II: Building a management cockpit in Excel

A management cockpit prepares the most important information of a project in a visually compressed form. This training will provide you with step by step instructions for the structuring of individual elements of such a cockpit in Excel. One important focus will be on diagrams and traffic light systems. We will also introduce you to working with the free Microsoft Software "Power BI", which makes it easy to create interactive and attractive dashboards. 

In addition, we will cover other elements such as top tables, which filter out the top three elements from a list, for example in projects with the highest expenditure or with the least reached of beneficiaries.

Please note that the participation in this Excel training is recommended only with certain basic knowledge of Excel (see checklist).

Language: English

Training time: 2 Hours

The participation fee is 99€. Please contact support@energypedia-consult.com if you wish to register for this online training.

What attendees say about our webinars

"I think the fact that the two facilitators brought their own life experience to the webinar was useful and one always learns something from such lived experience."

Sem Mabuwa

"Very good examples and easy to understand."

Mathilde Laval

"The presenters were really practical and had the live examples."

Francis Xavier Wasswa

Webinar Terms and Conditions:

Read terms and conditions