Excel for Data Analytics - Full Course for Beginners
🧮 Course Problems & Certificate 👉 https://lukeb.co/excel
📁 Course Files & Projects 👉 https://lukeb.co/excel_files
Course Outline
============
👋 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
Links Mentioned (by Chapter)
========================
👋 Intro
Kelly’s LinkedIn: / kellyjianadams
Kelly’s Website: https://www.kellyjadams.com
0️⃣ Excel Setup
Run Windows on a Mac (Virtual Machine) - https://lukeb.co/parallels
Microsoft 365 (Recommended) - https://www.microsoft.com/en-us/micro...
Office Home & Student 2024 - https://www.microsoft.com/en-us/micro...
📊 Project #1 - Salary Dashboard
One Drive Folder - https://onedrive.live.com
Project #1: Excel Online Version - https://lukeb.co/excel_dashboard
7️⃣ Power Query
What is Power Query? - https://learn.microsoft.com/en-us/pow...
Wikipedia Table S&P 500 - https://en.wikipedia.org/wiki/List_of...
8️⃣ Power Pivot / DAX
Merges (SQL Joins) - https://lukeb.co/sql_joins
DAX Guide - https://learn.microsoft.com/en-us/dax/
📈 Project #2 - Salary Analysis
Git Download - https://git-scm.com/downloads
GitHub Sign-up - https://github.com/signup
GitHub Desktop - https://desktop.github.com/download/
Markdown Cheatsheet - https://markdownguide.org/cheat-sheet/
📚 Recommended Books & Courses
SQL for Data Analytics (My Course) - • SQL for Data Analytics - Learn SQL in...
The Excel 365 Bible - https://geni.us/excel_bible
M is for (Data) Monkey (renamed: Master Your Data) - https://geni.us/power_query
Social Media
======================
📫Newsletter: https://www.lukebarousse.com/
👨🏼💼 Linkedin: / luke-b
🅧 X/Twitter: / lukebarousse
🌄 Instagram: / lukebarousse
⏰ 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
