Excel for Data Analytics - Full Course for Beginners

📁 FREE Course Files & Projects 👉 https://lukeb.co/excel_files 🏆 Supporter Access: Problems, Certificate, & More 👉 https://lukeb.co/excel ⚠️ Use "Download Zip" to get all GitHub files (downloading individually corrupts files) Still having issues downloading the Course Files & Projects? Try Google Drive instead 👉 https://lukeb.co/excel_files_alternate My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse 𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲 ▔▔▔▔▔▔▔ 👋 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/ README.md 𝗟𝗶𝗻𝗸𝘀 𝗠𝗲𝗻𝘁𝗶𝗼𝗻𝗲𝗱 (𝗯𝘆 𝗖𝗵𝗮𝗽𝘁𝗲𝗿) ▔▔▔▔▔▔▔▔▔▔▔▔▔▔ 👋 Intro Kelly’s LinkedIn: https://www.linkedin.com/in/kellyjianadams/ Kelly’s W