Standard Professional Development – Professional Certificates
Standalone course
Data Analysis with Excel
Analyse data and build dashboards in Excel.
Course overview
Data Analysis with Excel teaches you to turn data into insight using the spreadsheet skills that employers, donors and managers need. You will learn data entry and cleaning, formulas and functions, pivot tables, charts and dashboards, all applied to real development and business data.
Excel is the workhorse of data analysis in Liberia. A person who can build a pivot table, clean a dataset and create a dashboard is immediately more valuable to any organisation. This course builds those skills from the ground up.
Learning outcomes
By the end of this course you will be able to:
- 1Clean and structure data for analysis in Excel
- 2Use formulas and functions (VLOOKUP, IF, COUNTIF, SUMIFS) for analysis
- 3Build pivot tables and pivot charts for summarising data
- 4Create charts and a simple dashboard for reporting
- 5Interpret data and draw conclusions for decision-makers
- 6Apply basic data protection principles when handling data
Tools, templates & materials provided
Exercise dataset, formula reference card, pivot table guide, dashboard template and a data cleaning checklist.
At a glance
Total learning hours
30 hours (18h lessons · 9h practice · 3h assessment)
Delivery format
Three-week online course with hands-on exercises, or a four-day workshop with computer lab.
Assessment method
Practical: clean a dataset, build a pivot table analysis and create a dashboard, plus a quiz.
Pass mark
70%
Credential awarded
Certificate of Completion
Stacks toward
Professional Certificate. A core course of the Public Administration Certificate and essential for M&E and programme work.
Who should attend
M&E officers, programme staff, administrators, analysts and anyone who works with data in spreadsheets.
Entry requirements
Basic computer skills and familiarity with Excel. No statistics background required.
Facilitator
Data analyst with development sector and training experience in Liberia (sample profile).
Curriculum
Tap any module to see the full detail: objectives, topics, practical case study and assessment.
Who it is for
M&E officers, programme staff, administrators, analysts and anyone who works with data in spreadsheets.
For organizations
Enroll a team, assign this offering by county or department, and track completion in the organization dashboard.
Request a Quote