Essential Excel Portfolio Project for Job Seekers

THE BEST DATA PORTFOLIO FOR JOB SEEKERS
💼 Ultimate Data Portfolio: https://mochen.info/lp-ultimate-data-portfolio/

Data Analysis Lab - Build Your Data Portfolio in 30 DAYS: https://www.skool.com/data-analysis-lab
How I Built 50+ Data Projects in 90 DAYS: https://mochen.info/50-projects-90-days/
Join my newsletter: https://www.mochen.info

Sponsorships: enquiries@mochen.info

Hi! I'm Mo, and I help career switchers transitioning into Data Analytics. I'm a Data & Analytics Manager, and I've been working in the Financial and Banking Data space for 7 years now.

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