Excel remains the everyday workhorse of M&E, and mastering its advanced features dramatically boosts how M&E professionals manage, analyse, and present data. This program equips participants with advanced Excel and data tools skills for M&E, covering the functions, analysis, and visualisation that turn Excel into a powerful M&E engine.
As data skills become essential in M&E, advanced Excel proficiency is highly valued. This course combines advanced Excel with M&E application and introduces emerging trends in M&E data tools.
Course Objectives
Upon the successful completion of this program, attendees will be able to:
- Apply advanced Excel functions for M&E
- Manage and structure M&E data
- Clean and prepare data in Excel
- Apply lookup and reference functions
- Apply logical and conditional functions
- Apply text and date functions
- Use PivotTables for M&E analysis
- Build PivotCharts
- Analyse indicators and disaggregation
- Apply data validation
- Apply conditional formatting
- Build M&E dashboards in Excel
- Apply charts for M&E reporting
- Automate repetitive tasks
- Apply Power Query basics
- Apply emerging trends in M&E data tools
Course Outline
- Module 1: Advanced Excel Functions for M&E
- Module 2: Managing & Structuring M&E Data
- Module 3: Cleaning & Preparing Data
- Module 4: Lookup & Reference Functions
- Module 5: Logical & Conditional Functions
- Module 6: Text & Date Functions
- Module 7: PivotTables for M&E Analysis
- Module 8: PivotCharts
- Module 9: Analysing Indicators & Disaggregation
- Module 10: Data Validation
- Module 11: Conditional Formatting
- Module 12: M&E Dashboards in Excel
- Module 13: Charts for M&E Reporting
- Module 14: Automating Repetitive Tasks
- Module 15: Emerging Trends: M&E Data Tools
Who Should Attend
This course is intended for M&E officers, data staff, and program professionals who want advanced Excel and data tools skills for M&E. A basic Excel foundation is helpful.
Registration & Inquiry
For more details & inquiry, please contact us at:
