Recorded session
Data Analytics for M and E using Microsoft Excel
Join our 2-hour FREE training where you will learn how to analyze data for M and E in Excel. You will discover the place of data analytics in M and E, and learn top data analytics skills for M and E using Microsoft Excel.After completing the course, you will earn a Certificate of Attendance for FREE, to prove your new skills.
What people are saying about the course
![1](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/1.png?w=1080&ssl=1)
![4](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/4.png?w=1080&ssl=1)
![2](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/2.png?resize=734%2C86&ssl=1)
![5](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/5.png?resize=312%2C111&ssl=1)
![3](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/3.png?w=1080&ssl=1)
![Screenshot_18](https://i0.wp.com/datafordev.com/wp-content/uploads/2021/04/Screenshot_18.png?resize=526%2C99&ssl=1)
Course content
Sorting filtering and calculating using tables
- Creating tables
- Sorting data
- Filtering data
- Calculating using Total row
- Calculated columns
Conditional formatting
- Introduction to conditional formatting
- Basic conditional formatting
- Custom conditional formatting
Data Analysis functions
- Introduction to functions in Excel
- SUM, SUMIF and SUMIFS
- AVERAGE, AVERAGEIF and AVERAGEIFS
- COUNTIF and COUNTIFS
- VLOOKUP
Pivot Tables and Pivot Charts
- Introduction to pivot tables
- Inserting pre-made pivot tables
- Converting pivot tables to pivot charts
- Developing custom pivot tables and pivot charts