📁 FREE Course Files & Projects 👉 🏆 Supporter Access: Problems, Certificate, & More 👉 ⚠️ Use "Download Zip" to get all GitHub files (downloading individually corrupts files) Still having issues downloading the Course Files & Projects? Try Google Drive instead 👉 My FREE Course to be a Data Analyst 👉 𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲 ▔▔▔▔▔▔▔ 👋 Intro 0:00:00 - Welcome 0:03:53 - What is Excel? 0:07:19 - About Course 0️⃣ Excel Setup 0:11:19 - Excel Install 1️⃣ Spreadsheets Intro 0:22:42 - Worksheets 0:39:15 - Workbooks 0:52:06 - Ribbon 2️⃣ Formulas & Functions 1:06:39 - Formulas Intro 1:18:08 - Function Intro 1:29:14 - Logical Functions 1:39:54 - Math Functions 1:49:46 - Statistical Functions 2:01:14 - Array Formulas 2:21:28 - Lookup Function 2:39:25 - Text Functions 2:53:19 - Date and Time Functions 3️⃣ Charts 3:01:33 - Charts Intro 3:22:05 - Charts Advanced 3:35:37 - Charts Statistics 3:47:59 - Sparklines 4️⃣ Spreadsheet Advanced 3:51:57 - Tables 4:09:28 - Formatting 4:26:00 - Collaboration 📊 Project #1 - Salary Dashboard 4:40:30 - Project #1: Build Dashboard 5:26:43 - Project #1: Share Projects 5️⃣ PivotTables 5:33:46 - PivotTable Intro 5:54:53 - PivotTable Advanced 6:09:33 - PivotCharts 6️⃣ Advanced Data Analysis 6:19:43 - Analysis Add-ins 6:39:00 - Data Tables 6:48:06 - Analysis ToolPak 7️⃣ Power Query 7:03:04 - Power Query Intro 7:23:26 - Power Query Editor 7:53:13 - Advanced Transformations 8:14:58 - Append vs Merge 8:39:13 - M Language 8️⃣ Power Pivot / DAX 9:03:11 - Power Pivot Intro 9:29:01 - Power Pivot Window 9:48:18 - DAX Intro 10:09:34 - DAX Advanced 📈 Project #2 - Salary Analysis 10:27:40 - Project #2: Share w/ Git & GitHub 10:45:13 - Project #2: Document w/ 𝗟𝗶𝗻𝗸𝘀 𝗠𝗲𝗻𝘁𝗶𝗼𝗻𝗲𝗱 (𝗯𝘆 𝗖𝗵𝗮𝗽𝘁𝗲𝗿) ▔▔▔▔▔▔▔▔▔▔▔▔▔▔ 👋 Intro Kelly’s LinkedIn: Kelly’s Website: 0️⃣ Excel Setup Run Windows on a Mac (Virtual Machine) - Microsoft 365 (Recommended) - Office Home & Student 2024 - 📊 Project #1 - Salary Dashboard One Drive Folder - Project #1: Excel Online Version - 7️⃣ Power Query What is Power Query? - Wikipedia Table S&P 500 - &P_500_companies 8️⃣ Power Pivot / DAX Merges (SQL Joins) - DAX Guide - 📈 Project #2 - Salary Analysis Git Download - GitHub Sign-up - GitHub Desktop - Markdown Cheatsheet - 📚 Recommended Books & Courses SQL for Data Analytics - The Excel 365 Bible - M is for (Data) Monkey (renamed: Master Your Data) - 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮 ▔▔▔▔▔▔ 📫Newsletter: 👨🏼‍💼 Linkedin: 🅧 X/Twitter: 🌄 Instagram: ⏰ TikTok: @lukebarousse As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience