Evaluation Talks Training

M&E Data Visualization Using Advanced Excel Tools

You are invited to attend January National Evaluation Talk due to take place

Date: Thursday 31st January 2019
Time: 2:00-4:00PM
Topic: Monitoring and Evaluation Data Visualization Using Advanced Excel Tools
Presenter: Mr. Ronald Waiswa, Co-Founder & Director Research and Training, Lida Africa, Uganda.
Venue: Uganda Management Institute -Main conference Hall

Have you ever wondered which software is most applied in visualizing Monitoring & Evaluation Data? Well, MS. Excel takes that crown because of its availability, simplicity and appealing graphics.

Often M&E professionals generate good statistics through credible methodologies but the use of such statistics especially by the decision makers is still a challenge. MS. Excel has powerful tools that can enable M&E professionals to set up simplified analysis and data visualization systems to enable users to devote their time to making decisions and taking corrective actions and become result based. Through visualization, complex ideas are communicated with clarity, precision, and efficiency.

This National Evaluation Talk (NET) will provide a brief understanding of data visualization process using advanced features of EXCEL to contribute to faster decision making through creating a bridge between complicated statistical analysis and use of data in decision making.

The Session will cover;

  • What is Data visualization and Why it matters?
  • The Principles of Visualizations
  • Elements of a good Excel Visuals
  • Choosing the right visual for your data.
  • Creating the visuals using Excel
    • Comparison Visuals
    • Composition Visuals
    • Distribution Visuals
    • Relationship Visuals

​NB: This is a practical session. Carrying a laptop installed with EXCEL 2016 is recommended.


Facilitator: Mr. Ronald Waiswa (Msc. Statistics, Msc. EPM, B. Statistics & Economics)

Ronald is the Co-founder and Director of Research and Training at Lida Africa, a social enterprise dedicated to working with private, public and civil society entities to reach their full impact potential by addressing strategic M&E challenges through designing and operationalizing impact-oriented M&E systems, developing M&E Frameworks, automated decision support systems, dashboards, staff capacity development, and support in conducting baseline, midline, and end line evaluation surveys.

Ronald holds a Master of Statistics and a Master of Economic Policy Management from Makerere University, and a Bachelor of Economics and Statistics from Kyambogo University. He has worked with many corporate organizations including the Uganda Revenue Authority as a Supervisor for Research and Policy Analysis, Data analyst, Trainer and officer Business Intelligence, the Ministry of Agriculture, Animal Industry and Fisheries as a Statistician and Kyambogo University -Department of Economics and Statistics as a Lecturer.

Ronald is a Researcher Consultant for The International Center for Tax and Development in UK and United Nations University- World Institute for Development Economics Research-Finland. He has spent his career in conducting researches and training people in data management, analysis and design of automated decision support systems. He has built the capacity of over 5,000 students and 200 professionals in MS. Excel. Recently Ronald held an Executive Workshop for Data Management, Analysis and Visualization at the 8th AfrEA International Conference.

6 Responses

  1. Hello I am so delighted I found your blog, I really found you by mistake, while I was looking on Yahoo for something else, anyways I am here now and would just like to say thanks for a tremendous post. Please do keep up the great work.

  2. Would like to receive a copy of the presentation to this Workshop

  3. Why viewers still use to read news papers when in this
    technological globe the whole thing is presented on net?

  4. hello,Morning
    lam so gratefully to read you information and l picked interest with the data,research skills,its in line with my target to become a senior data analyst you have shared with us and please keep that hard work and please l was also in need of the notes,workshop soft copy thanks you .

  5. Lovely,
    Nice page.
    Will love to be part of you next events

Comments are closed.