Beginner's Excel Tutorial - Data Science/Analysis and Beyond

Video Description

COURSE NOTES: https://bit.ly/ShashankExcelCourse Excel File for Course: https://drive.google.com/drive/folders/1xCbXW6kqpqUncjDz6vHKQN3rckbSntb8?usp=sharing This course goes over the basic skills in Excel that you'll need if you want to become a Data Analyst or Data Scientist. Excel is a very useful skill in the toolbelt of an analyst but not the end all be all. My FREE Courses: 🐍 Python 🐍. : https://youtu.be/sZDgJKI8DAM ⌭ SQL ⌭ : https://youtu.be/gwp3dJUsy5g 📊 Tableau📊 : https://youtu.be/Gl2lg-TtRJo 📈 Statistics 📈 : https://youtu.be/wwsizzg6UjU 🤖 Machine Learning 🤖 : https://youtu.be/KLjTAcH7Ikk Patreon: https://www.patreon.com/shashankkalanithi MX Master 3 https://amzn.to/3sTroBW LG 35in Curved Monitor: https://amzn.to/39pPzR3 USB-C Hub: https://amzn.to/31Ip8Sl MacBook Pro Retina 16 Inch: https://amzn.to/2PSwZde Twitter: https://twitter.com/kalamari95 LinkedIn: https://www.linkedin.com/in/shashankkalanithi/ 00:00:00 - Introduction 00:01:33 - DataCamp Sponsorship 00:03:16 - Excel Layout 00:05:56 - Excel for Mac vs PC 00:07:13 - My Opinion on VBA 00:08:50 - Google Sheets 00:09:46 - Excel File Formats 00:11:20 - Data Types 00:21:05 - Aggregate Functions (SUM, MEDIAN, MIN, MAX) 00:27:29 - Lookups (VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH) 00:41:02 - IF Functions 00:47:07 - String Functions (CONCAT, TRIM) 00:50:23 - Formatting 00:57:22 - Importing CSVs Correctly 00:59:40 - Remove Duplicates 01:00:58 - Text to Columns 01:02:02 - Filters 01:02:32 - Tables 01:03:30 - Pivot Tables 01:05:39 - Goal Seek 01:09:10 - Excel Solver 01:10:14 - Macros 01:11:09 - Final Thoughts on Excel This video was sponsored by DataCamp