Advanced Data Management

Professionals working as planners, statisticians, economists, monitoring and evaluation officers, and academic researchers who need advanced Excel skills for data analysis and reporting.

To provide participants with robust knowledge and practical skills to use Excel for comprehensive data management tasks, perform descriptive and inferential analyses, and create professional charts and dashboards.

• 🗃️ Excel Basics and Data Entry: Understanding cell references, formulas, sorting, and filtering data.
• 📈 Pivot Tables and Visualization: Creating one-way and two-way pivot tables, and generating informative graphs (bar, column, line, pie charts).
• 🔬 Descriptive and Inferential Statistics: Central tendency, dispersion measures, correlation, and regression analysis.
• 📊 Advanced Reporting: Designing data presentations and summaries to support decision-making.