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