Live workshop

Data Analysis and Interpretation using STATA

Learn how to analyze data and create data visualizations using Microsoft Excel

Dates 10, 11, 17, 18 September 2022 | Time: 8:00am Lilongwe Time (GMT+2).

About this course

Microsoft Excel is a general-purpose spreadsheet software that allows you to organize, manage and analyze data. It is one of the most popular and most powerful data analysis and visualization software.

In this course, you will be introduced to Microsoft Excel’s data analysis and visualization features such as formulas and functions, tables, conditional formatting, pivot tables and charts.

What you’ll learn

By the end of the course, you will be able to:

    • Bring data from different sources such as KoboToolbox
    • Manage data using tables and data validations
    • Analyze data using formulas
    • Summarize data using pivot charts
    • Visualize data using charts, sparklines and conditional formatting
    • Perform statistical data analyses in Excel
    • Perform basic forecasting

Course content

Working with data in Excel
  1. Data validation
  2. Data cleaning in Excel
  3. Autofill and flash fill
  4. Bringing data from KoboToolbox
  5. Basics of Excel calculations and functions
Working with tables in Excel
  1. Creating tables
  2. Modifying tables
  3. Sorting data in tables
  4. Filtering data in tables
Conditional formatting
  1. Introduction to conditional formatting
  2. Using built-in conditional formatting
  3. Custom conditional formatting
  4. Conditional formatting using formulas
Charts in Excel
  1. Bar and column charts
  2. Line charts
  3. Pie charts
  4. Scatter plots
  5. Combo charts
  6. Sparklines
Exploring data using descriptive statistics
  1. Frequencies
  2. Interpreting and reporting frequencies
  3. Summary statistics
  4. Summary statistics II
  5. Interpreting and reporting summary statistics
Exploring relationships between variables
  1. Introduction to variable relationships
  2. Mean comparisons – Relationship between categorical and continuous variables
  3. Interpreting and reporting mean comparisons
  4. Crosstabulation – relationships between 2 categorical variables
  5. Interpreting and reporting crosstabulations
  6. Correlation – relationship between 2 continuous variables
  7. Interpreting and reporting correlations
Charts
  1. Introduction to charts in STATA
  2. Univariate bar chart
  3. Pie chart
  4. Histogram
  5. Line chart
  6. Multivariate bar chart
  7. Scatter plot
  8. Combo charts
  9. Customizing charts
Pivot tables and pivot charts
  1. Introduction to pivot tables
  2. Using automatic pivot tables
  3. Creating a pivot table from scratch
  4. Creating calculated fields in the pivot table
  5. Sorting and filtering pivot tables
  6. Customizing pivot table
  7. Creating charts from pivot tables
Forecasting basics
  1. Using the FORECAST function
  2. Using Scenario and Goal Seek
Statistical analyses in Excel
  1. Basic statistical functions
  2. Using the Data Analysis Toolpak

Instructor

Alexander Mtembenuzeni

Data Analyst, Instructor
DATAFORDEV Founder

Alexander has over 8 years experience training social impact organizations in data analytics. He also has consulted for small and big organizations alike – developing data collection tools, building M and E systems and analyzing data. He is a 4.6/5-rated instructor on Udemy.com where he has several courses with a combined over 6,000 students. He also loves blogging and creating tutorial videos for the Data for Development YouTube channel.

Frequently asked questions 

Does this course offer a certificate?

Yes. When you attend at least 80% of the sessions and submit all the assignments, you will get a certificate

How do I enrol in this course

You need to purchase the yearly membership subscription here. Once you become a full member, you will get an email with a Zoom meeting link for the course. If you haven’t gotten any email after purchasing the membership, contact us on [email protected]

Live workshop

~

Full membership

Purchasing the full membership gives you access to this and the rest of our courses

Level

Beginner to intermediate