MS Excel, How to do Data Cleaning, Find Outliers, Anomalies in Data with X/Y Scatter Charts

In this video, we discuss "How to do Data Cleaning Find Outliers, Anomalies in Data with Formulas, X/Y Scatter Charts and Techniques"
To learn about other MS Excel Top Tricks and Formulas, subscribe and go to the playlist "MS Excel Top Tricks and Formulas" The Link is: • MS Excel Top Tricks an...
Or go the playlist for complete tutorials on MS Excel: • MS Excel Basic to Adva...
#datacleaning, #datamanagement, #dataoutliers, #exploredata, #anomalies, #dataexploration, #msexcel, #exceltricks, #topexceltricks, #excelformulas, #learnexcel, #exceltutorials, #msexceltutorials, #learningtutorials
About the Channel: We have started this channel for step-by-step and detailed explained tutorials, on different topics: Please subscribe, watch and share your feedback
Channel URL: / ilusplm
Detail Tutorials already shared on the channel (link given above) and upcoming are as below:
Series 1: Learn Online data collection tools like Google Form and Spreadsheet Tutorials videos on how to develop google form and google spread sheet for online data collection. The playlist URL is: • Learn Online Data Coll...
Series 2: Learn MS Excel (From Basic to Advance level)- Learn MS Excel from Basic to Advance level developing simple tables, databases, data analysis, and all other topics from basic to advance level, like below:
1. Basic of Excel
2. Basics of Data / Data entry and Databases in Excel (Validations)
3. Basics of Data Analysis via Excel (Basics Formulas)
4. Advance level of Data Analysis via Excel (Advanced Formulas, discover more about your data, spot trends & patterns in data)
5. Analysis with Pivot Table (Slicers and Timelines)
6. Conditional Formatting
7. And more
URL: • MS Excel
Series 3: Project Management (Complete Cycle)- In this 3rd series of our Learning Channel, you will learn the complete cycle of project and data management, from basics to advanced level i.e. tools development, databases, implementation, monitoring and evaluation of projects. All the Processes of project management (from inception to proposal submission, implementation, monitoring and end-line evaluation).
URL: • Project Management Cou...
Series 4: MS Power Point
URL: • MS PowerPoint
Upcoming Tutorials
1. Conducting Research and Studies
2. Interpretation of data and Reporting
3. M&E
4. Result Based Management /Monitoring (RBM)
5. MS Word,
6. Online data collection tools like KOBO, SurveyCTO and more
7. MS Access and SPSS
Note: If any topic is missing, please share in comment and we will develop tutorial on that. You can share your question is “How to do this and that”.