┋Resources to take your data analytics skills to the next level┋

Ultimate Data Roadmap: The MOST comprehensive data roadmap ➡ https://mochen.info/product/ultimate...

Ultimate Data Portfolio: Publish your entire data portfolio to the web with ZERO coding ➡ https://mochen.info/product/ultimate...

Ultimate Resume Template: Literally the resumes that I use for my OWN JOB APPLICATIONS ➡ https://mochen.info/product/ultimate...

1:1 Mentorship: Significantly accelerate your professional GROWTH ➡ https://mochen.info/11mentorship/

Career Compass: My completely FREE weekly data newsletter with actionable tips and insights ➡ https://mochen.beehiiv.com/subscribe/

CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?co...'>https://coursecareers.com/a/mochen?co...

Portfolio Projects Playlist: Endtoend, FREE guided portfolio projects covering Excel, SQL, Tableau and Python ➡    • Portfolio Projects  

Data Portfolio Guide: Over 80 actionable tips on how you can build your dream data portfolio. For completely FREE ➡ https://mochen.beehiiv.com/c/datapor...


┋Community & Socials┋

  / discord   ⬅ Join our Discord Data Community

  / mo_chen1   ⬅ My IG is personal only follow if you're interested in nondata stuff as well

  / mochen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen_1   ⬅ Figuring out what I want to do in this space...


┋Professional Certificates┋

CourseCareers ➡ https://coursecareers.com/a/mochen

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/googlecerti...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/googlecerti...

Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...

IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience

Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...


┋Timestamps┋

00:00 Project Walkthrough
05:00 XLOOKUP
11:29 INDEX MATCH
17:46 Multiplication formula for Sales
18:12 Multiple IF functions
21:15 Date Formatting
22:50 Number Formatting
24:17 Check For Duplicates
24:45 Convert Range to Table
25:58 Pivot Tables and Pivot Charts + Formatting
32:05 Insert Timeline + Formatting
36:17 Insert Slicers + Formatting
36:48 Updating the Pivot Table Data Source
49:22 Building the Dashboard
53:54 Pro Tip
55:16 Outro


┋Github repo for files┋

https://github.com/mochen862/excelpr...

Thanks so much for taking a little time out of your day to watch this!