DAY 3 | Formulas and functions | 30 Day Excel Challenge | #dataanalysis #datascience #dataanalytics

Practice Excel for 30 Days with Stephen. In Day 3, we cover formulas and functions - the difference between formulas and functions, writing your first formula on a bakery dataset, SUM, AVERAGE, MAX and MIN, cell references, relative references, absolute references and the F4 key, and a two-part exercise covering discount calculation and tax rate. Timestamps: 0:00 - Intro: Formulas vs functions 1:00 - Demo: Writing your first formula (bakery dataset) 2:00 - The SUM function 3:00 - AVERAGE, MAX and MIN functions 5:00 - Intro to cell references 6:00 - Relative references 7:00 - Absolute references and the F4 key 9:00 - Exercise: relative reference (discount calculation) 10:00 - Exercise: absolute reference (tax rate) 13:00 - 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 #formulas #functions