EXCEL PORTFOLIO PROJECT | Build this Interactive Dashboard
Take Your Data Analysis Skills To The Next Level
🛣️ Ultimate Data Roadmap ➡
💼 Ultimate Data Portfolio ➡
📝 Ultimate Resume Template ➡
🎓 1:1 Mentorship ➡
📰 Career Compass Newsletter ➡
💻 Portfolio Projects ➡
Follow me
Professional Certificates
📊 CourseCareers Data Analytics Course ➡
📈 Google Data Analytics Professional Certificate ➡
💻 Google Advanced Data Analytics Professional Certificate ➡
💹 Tableau Business Intelligence Professional Certificate ➡
🖥️ Microsoft Power BI Data Analyst Professional Certificate ➡
📖 IBM Data Science Professional Certificate ➡
📝 Google Project Management Professional Certificate ➡
Related video
📊 Fastest Way to Become a Data Analyst ➡︎
Github repo for files ➡
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
🙏 Thanks so much for taking a little time out of your day to watch this!
1 view
614
122
1 month ago 00:02:47 2
Jimmy Page 1964 SJ-200 & 1964 SJ-200 Collector’s Edition Ltd.
1 month ago 01:03:09 1
Icons: Noel Gallagher of Oasis
1 month ago 00:05:27 1
Knockin’ on Heaven’s Door | Afro Fiesta w/Twanguero & I-Taweh | Playing For Change
2 months ago 00:05:29 1
Metallica: No Leaf Clover Live from S&M2
2 months ago 00:02:32 1
Тяжелоатлетическая зарядка
2 months ago 00:45:01 1
Пиратский логотип в Adobe Illustrator | Видеоуроки
2 months ago 00:01:27 1
Что ждет человечество в будущем | Теория Всего “Система и Хаос“
2 months ago 00:26:37 1
Biggest 3BHK on Dwarka Expressway flats a Bad Investment 2024?
3 months ago 00:05:06 1
Slash feat. Tash Neal | “Oh Well“ (Live At The Gibson Garage)
3 months ago 00:11:31 1
Торговая стратегия „Бомж“ / Трейдинг - Часть 5
3 months ago 00:00:18 1
beautiful melody italo disco - Bass Fun #melody #80smusic #melodysongs
3 months ago 00:08:47 6
Короткометражка “Прогулка по Рязани“ | автор Ларин А.А.
3 months ago 00:08:42 1
Slash feat. Tash Neal | ’Papa Was A Rolling Stone’ (Live At The Gibson Garage)
4 months ago 00:01:43 3
Презентация моей Теории Всего “Система и Хаос“
4 months ago 00:07:30 3
Eric Lune - Water Lilly (Nosh & SJ Remix) [Strange Town Recordings]
4 months ago 19:23:46 1
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
4 months ago 01:19:48 1
Вся база SQL для начинающих за 1 час
5 months ago 00:58:01 1
Balance Selections 289: SisterSweet
5 months ago 01:30:46 6
The Collection: Paul Stanley Of KISS
5 months ago 00:03:57 1
Come As You Are (Nirvana) | Playing For Change | Song Around The World
5 months ago 00:04:08 1
Iko Iko feat. Dr. John, members of Grateful Dead + more | Playing For Change | Song Around The World