The ONLY EXCEL PORTFOLIO PROJECT YOU NEED

Опубликовано: 06 Июль 2023
на канале: Mo Chen

204,062

6.6k

https://mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle

  / mo-chen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen   ⬅ Support me on Patreon

   • Data Analysis Portfolio Projects   ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python

┋Professional Certificates┋

DataCamp Certifications ➡ https://datacamp.pxf.io/c/4216860/205...

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

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/excel-pr...

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