DAY 2 | Formatting data | 30 Day Excel Challenge | #dataanalysis #datascience #dataanalytics

Practice Excel for 30 Days with Stephen. In Day 2, we cover formatting data in Excel - why formatting matters, good formatting principles, fixing inconsistent text with PROPER, currency and percentage formatting, auto-fit, bold headers and borders, and conditional formatting to highlight weak and strong ROI. Timestamps: 0:00 - Intro: Why formatting matters 2:30 - Good formatting principles 3:00 - Demo: Before formatting (inconsistent client data) 4:00 - Fixing text with PROPER function 6:00 - Currency formatting (spend and return columns) 7:30 - Percentage formatting (ROI column) 8:30 - Auto-fit, bold headers and borders 9:30 - Conditional formatting (highlight weak/strong ROI) 12:30 - Key takeaway 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 #formatting