Data Analysis Full Course| All Functions You Need To Know for Data Analysis| MS Excel Full Course

Monitoring evaluation and learning
In this video, you will learn about the most important functions or formulas that you need for calculation and analysis in MS Excel like SUM, COUNT, COUNTA, AVERAGE, MAX & MIN, Product, Division, Percentage, SUMIF, COUNTIF, AVERAGEIF, VLOOKUP, XLOOKUP, SUMPRODUCT, INDEX, MATCH, Filter, Sort, IF STATEMENTS AND and OR, CONCATENATE and &. Time links are given below.

Below are the Playlists if you want to learn MS Excel, PowerPoint, MS Access, MS Word, online data collection tools (like Google Forms, MS Forms, KOBO), How to conduct needs assessment studies, Data management, Windows features and other tips:

MS Excel: https://www.youtube.com/watch?v=fpLkDe5w5aA&list=PLKD2IlZ7Ez5JDecyVwlbH7nj9jJA7w2U0

MS Excel lookups sessions: https://youtube.com/playlist?l....ist=PLKD2IlZ7Ez5Ijwe

MS Excel in Urdu/Hindi: https://youtube.com/playlist?l....ist=PLKD2IlZ7Ez5IGuV

MS PowerPoint:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

MS Access:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

MS Word:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

Online data collection tools Google Form, KOBO, MS Forms:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

Learning Tips:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

Project Management:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

Windows Features:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

Other Software:
https://www.youtube.com/playli....st?list=PLKD2IlZ7Ez5

About the Channel: In this channel, you will find step-by-step and detailed explained tutorials, on different topics. Subscribe, watch and share your feedback
URL: https://www.youtube.com/user/ilusplm

You can learn about Basic of Excel, Basics of Data / Data entry and Databases in Excel (Validations), Basics of Data Analysis via Excel (Basics Formulas), Advance level of Data Analysis via Excel (Advanced Formulas, discover more about your data, spot trends & patterns in data), Analysis with Pivot Table (Slicers and Timelines), Conditional Formatting.

Similarly, MS Access, Project Management (Complete Cycle)- Conducting Research and Studies, Interpretation of data and Reporting, M&E, Result Based Management /Monitoring (RBM), Online data collection tools like KOBO, SurveyCTO and SPSS.
#Learning #monitoring #evaluation