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

COURSE NOTES: https://bit.ly/ShashankExcelCourse Excel File for Course: https://drive.google.com/drive/folder... 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 🐍. :    • Python for Data Analysts and Data Scientists   ⌭ SQL ⌭ :    • SQL for Data Analysts and Data Scientists ...   📊 Tableau📊 :    • Tableau Beginner Course - From Nothing to ...   📈 Statistics 📈 :    • Practical Statistics for Data Scientists -...   🤖 Machine Learning 🤖 :    • Machine Learning for Beginners - Data Scie...   Patreon:   / 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:   / kalamari95   LinkedIn:   / 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