#codanics #dataanalytics #DataWrangling #ExcelTips #TitanicDataset #ExcelTutorial #DataScience #DataCleaning #ExcelSkills #DataTransformation #PivotTables #ExcelForBeginners #CSV #SpreadsheetAnalysis

Links to the dataset:
https://www.kaggle.com/datasets/yasserh/titanic-dataset

https://github.com/mwaskom/seaborn-data/blob/master/titanic.csv

---------------------------------------------------------------------------------------------------------------------------------------
Video Description:
In this video, we explore Data Wrangling using MS Excel with the Titanic Dataset. Learn how to clean, transform, and prepare data for analysis using powerful Excel techniques like handling missing data, removing duplicates, splitting columns, and using pivot tables. Whether you're a beginner or experienced with Excel, this step-by-step guide will help you master data wrangling for your next project. Perfect for students, data enthusiasts, and professionals looking to enhance their Excel skills!

Topics Covered:

Importing and identifying missing data
Filling missing values with averages
Removing duplicates and irrelevant rows
Transforming categorical data into numerical values
Splitting columns using text-to-columns
Creating summary statistics with pivot tables
Follow along with the Titanic dataset and learn practical Excel techniques to make data more manageable and ready for deeper analysis!
---------------------------------------------------------------------------------------------------------------------------------------


---------------------------------------------------------------------------------------------------------------------------------------
RoadMap to Data Analytics
Complete RoadMap to Become a Data Analyst in 2024.
Learn and Practice these skills and courses from our youtube Channel Codanics or our website www.codanics.com

The complete Data Analytics Course can be accessed here:
https://codanics.com/courses/data-analyst-summer-bootcamp/

You can also learn from our youtube channel www.youtube.com/@Codanics following this sequence.

1. MS Excel:
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50G7D7_4ZDNAlS9JczrG57L6
2. https://www.youtube.com/playlist?list=PL9XvIvvVL50Hl4kVygAWYEpBXUteQlAiN
2. ABC of Statistics for Data Analytics and Data Understanding:
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50FftePmir6RYd9r378DCQda
2. https://www.youtube.com/playlist?list=PL9XvIvvVL50H2YCvuZklqjBiqsJt_0KWI
3. Free Ebook written in Roman Urdu:
1. https://codanics.com/books/abc-of-statistics-for-data-science/
3. Mathematics for Data Analytics and Data Understanding:
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50EFb5DokvHbunW6AsLtdMXh
2. https://www.youtube.com/playlist?list=PL9XvIvvVL50G3-_NMFreX72zbICK9-NW-
4. Power BI for Data Visualization
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50GTwV7dqdBKxsFs7WYzlOYZ
5. Tableau for Data Visualization
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50F5_vuj1805AMxpAms9HT6-
6. SQL (Structured Query Language)
1. https://www.youtube.com/playlist?list=PL9XvIvvVL50FszjOhcZw9WXIJQY6ZwV5g
7. Python for Data Analytics and Data Science
1. The whole python ka chilla for data science (Free main) is at this link: https://shorturl.at/vxGZ8
8. R programming:
1. Complete course on R is here: https://codanics.com/courses/r-with-aammar/
9. Bonus Complete Course on AI and Data Science:
1. Six months AI and Data Science Mentorship program is uploaded here: https://codanics.com/courses/six-months-of-ai-and-data-science-mentorship-program/
10. Markdown Language to Make Data Reports:
1. https://youtu.be/qJqAXjz-Rh4

Please share and like this video, also write your comment here and subscribe our channel.
---------------------------------------------------------------------------------------------------------------------------------------
Our Free Books: https://codanics.com/books/abc-of-statistics-for-data-science/
Our website: https://www.codanics.com
Our Courses: https://www.codanics.com/courses
Our YouTube Channel: www.youtube.com/@Codanics
Our whatsapp channel: https://whatsapp.com/channel/0029Va7nRDq3QxRzGqaQvS3r
Our Facebook Group: https://www.facebook.com/groups/codanics
Our Discord group for community Discussion: https://discord.gg/kDb8fHZe
For more Details contact us at [email protected]