Turn raw data into clear analysis and dashboards in just 3 weeks.
Start with the basics of Microsoft Excel and develop the skills to clean, analyse and visualise data with confidence. Whether you are a beginner or looking to improve your existing skills, replace time-consuming manual processes with smarter workflows that improve accuracy and help you present your findings with confidence.
8 Live Sessions • 20 Hours • Starts 25 Nov 2026
Registration closes in
CESAR's Data Analysis & Visualisation Using Excel (DAVE) is designed for researchers, data analysts and other professionals who want to take their Excel and data analysis skills further, through practical, hands-on training built on real-world data.
Working with Excel shouldn't mean spending hours fixing messy spreadsheets, repeating calculations or putting reports together manually. Over three weeks, you'll learn how to prepare, clean, analyse, visualise and interpret data using Excel, transforming raw data into meaningful information and insights that support better decision-making.
Learn the basics about data, datasets, information and insights. Learn how to organise, clean and prepare datasets for reliable analysis. Identify missing values, duplicates, inconsistencies and other data quality problems, and apply appropriate techniques to ensure your data are accurate, consistent and ready for analysis.
Develop practical skills to summarise and analyse data, calculate descriptive statistics, compare groups and identify patterns and trends. Learn conditional formatting and heat maps. Learn how to select appropriate analytical techniques and use Excel to answer important research and business questions.
Go beyond producing numbers and charts to interpreting what your findings mean. Learn to create effective visualisations, including interactive dashboards, communicate analytical results clearly and translate data into meaningful information and insights that support evidence-based decision-making.
Identify and resolve common data quality errors using structured cleaning techniques and functions. Apply logical functions such as IF, IFS, AND and OR to categorise records, flag inconsistencies and prepare reliable datasets for analysis.
| 1 | Record | Status | Check |
| 2 | A1023 | Complete | Ready |
| 3 | B1045 | Missing value | Check |
| 4 | C1101 | Invalid date | Check |
| 5 | D1188 | Duplicate | Check |
Illustrative example · values shown for demonstration.
On completion, participants will have significantly enhanced their Excel and data management skills, gaining the practical knowledge needed to manage, analyse and present research data at an intermediate to advanced level.
You will be able to work more independently and efficiently, producing accurate, professional-quality reports and analyses that meet the standards expected in research, monitoring and evaluation, and academic environments.
Dr Braimoh Bello is a research specialist and biostatistician with a Master of Science in Medicine (Epidemiology and Biostatistics) from the University of the Witwatersrand, South Africa, and a PhD from Utrecht University, Netherlands.
Among others, he holds two certificates in advanced methods in epidemiology and biostatistics from the London School of Hygiene and Tropical Medicine.
“I have always wanted to become an excellent migration policy analyst, and I knew understanding data was the missing piece. This course helped me connect data analysis with policy and governance. I can now independently explore findings, identify patterns and contribute more meaningfully to evidence-based migration policy discussions.”
“Having worked in data management for about 10 years, I discovered that there were things I had been doing without fully understanding why. This course gave me a clearer understanding of inferential statistics. I also learned valuable teaching techniques, particularly the importance of engaging students and respecting their time.”
“Before this course, I knew what data was but didn’t understand data analysis or how relevant it was to my work. I now see how it can help me organise information, interpret findings, track the impact of my interventions, improve my programmes and make better decisions in mental health and adolescent counselling.”
“I particularly appreciate the teaching method and the respect shown to every participant. I know I still have more to learn, but I now have the confidence and foundation to keep practising.”
Registration closes on Tuesday, 24 November 2026 at 11:59 PM WAT. Classes start Wednesday, 25 November 2026.
Data Analysis & Visualisation Using Excel (DAVE) · Starts 25 November 2026. Fields marked * are required.
You will learn how to use Excel to clean, analyse and visualise data for intelligent decisions, from data cleaning and lookups through PivotTables, dashboards and AI-assisted analysis.
The course starts on 25 November 2026, with classes on Wednesdays, Saturdays and Sundays from 7:00 PM to 9:30 PM West Africa Time (WAT). There are eight sessions, providing 20 hours of training: 25, 28 and 29 November, and 2, 5, 6, 9 and 12 December.
The training is delivered online through live, interactive Zoom sessions, so you can join from wherever you are. Once your payment is confirmed, we'll send you the next steps.
The launch fee is ₦50,000, a 50% discount on the regular fee of ₦100,000. This offer applies to the first cohort only.
Yes. Participants receive a certificate of completion.
Don’t worry. All participants get access to an online repository of recorded sessions and learning resources, so you can catch up on missed classes and revisit lessons at your own pace.
Researchers, data analysts, programme officers, administrators, programme managers, postgraduate students, market researchers, government officials, business owners and scientists who already use Excel and want to strengthen their data analysis skills.
Yes. The course includes an introduction to AI-assisted data management and analysis, as well as an introduction to agentic data analysis.
Join CESAR's first DAVE cohort and build practical data analysis skills you can put to work. Training starts 25 November 2026.
Reserve My Seat
