DAY 1 | Intro to Excel | 30 Day Excel Challenge | #dataanalysis #datascience #dataanalytics
Practice Excel for 30 Days with Stephen. In Day 1, we cover the basics of Excel - why Excel matters for data analysis, the difference between raw data and an Excel table, building a spreadsheet with formulas and filtering, navigating rows and columns, cells, workbooks and worksheets, the ribbon, the name box and formula bar. Timestamps: 0:00 - Intro: Why Excel matters 1:30 - Demo: Raw data vs Excel table 3:00 - Building a spreadsheet (formulas, filtering) 4:30 - The Excel interface: rows and columns 6:00 - Cells, workbooks and worksheets 7:30 - The ribbon (Home, Insert, Formulas, Data tabs) 9:00 - Name box and formula bar 12:00 - Wrap up Code + datasets: https://github.com/sdw-online/30-Day-Excel-Challenge Playlist: https://www.youtube.com/playlist?list=PL92LwdfbhlXG4E-u5i7ZnLq2HeQYLVnbM Join the waitlist: Free community - https://data100x.carrd.co/ Private community - https://data100.carrd.co/ Become a data analyst: Analyst Builder - https://www.analystbuilder.com/?via=stephen-david-williams Socials: LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/ GitHub - https://github.com/sdw-online TikTok - https://www.tiktok.com/@sdw.online Instagram - https://instagram.com/sdw.online Twitter/X - https://twitter.com/sdw_online #excel #dataanalysis #dataanalytics #excelchallenge #exceltutorial
Download
0 formatsNo download links available.