The ONLY EXCEL PORTFOLIO PROJECT YOU NEED

THE BEST DATA PORTFOLIO FOR JOB SEEKERS 💼 Ultimate Data Portfolio: https://mochen.info/lp-ultimate-data-portfolio/ DATA PORTFOLIO & RESUME: https://mochen.info/ SPONSORSHIPS: https://mo-chen.notion.site/partnerships OR email me at [email protected] ABOUT ME I'm Mo and I work as a data analytics manager / content creator. I make videos about how you can stay competitive / ahead of the competition in the data industry. COURSES & CERTIFICATES Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen INDUSTRY RECOGNIZED CERTIFICATIONS Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCertDataCamp PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAnalyst Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert TOP DATA ANALYST COURSES Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL TOP DATA SCIENTIST COURSES Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateDataScientistPython Associate Data Scientist in R: https://datacamp.pxf.io/AssociateDataScientistR TOP DATA ENGINEER COURSES Data Engineer in Python: https://datacamp.pxf.io/DataEngineerInPython TOP BUSINESS INTELLIGENCE COURSES PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundamentals Tableau Fundamentals: https://datacamp.pxf.io/TableauFundamentals TOP PROGRAMMING LANGUAGE COURSES Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundamentalsDataScience Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundamentalsProgramming SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals TOP AI COURSES AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDevelopers AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDataScientists Developing AI Applications Course: https://datacamp.pxf.io/AIApplications 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 PROJECT FILES https://github.com/mochen862/excel-project-coffee-sales