These beginner-friendly videos are designed to help you master Excel for Data Science and Data Analysis. They are arranged in a sequence that promotes quick learning and a smooth transition to the next set of tools.
WEEK 2 - 3
Master beginner to intermediate Excel skills, covering data entry, formatting, pivot tables, charts, formulas, functions (IF, VLOOKUP), and advanced techniques in this 10-hour video.
Timestamp: Spend an hour a day
https://www.youtube.com/watch?v=ormRboQsB-I&t=34699s
WEEK 4
This YouTube playlist is designed to assist you in mastering Power Query within Excel.
https://www.youtube.com/playlist?list=PLm8I8moAHiH1_n4Y1wE0seb-htscpN9o6
WEEK 5 [ EXCEL PROJECT ]
This video guides you through your first projects, covering data cleaning and creating dashboards in Excel.