Excel for Data Analytics - Full Course for Beginners

🧮 Course Problems & Certificate 👉 https://lukeb.co/excel
📁 Course Files* & Projects 👉 https://lukeb.co/excel_files

*⚠️ Use "Download Zip" to get the files (vice downloading individually, which corrupts the workbook)

Issues downloading the Course Files & Project above?
Download directly from the link below - Please DON'T request Editor access!!
https://lukeb.co/excel_files_alternate

My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse

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: https://www.linkedin.com/in/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/microsoft-365
Office Home & Student 2024 - https://www.microsoft.com/en-us/microsoft-365/p/office-home-2024/cfq7ttc0pqvj

📊 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/power-query/power-query-what-is-power-query
Wikipedia Table S&P 500 - https://en.wikipedia.org/wiki/List_of_S&P_500_companies

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 - https://youtu.be/7mz73uXD9DA
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: https://www.linkedin.com/in/luke-b/
🅧 X/Twitter: https://twitter.com/LukeBarousse
🌄 Instagram: https://www.instagram.com/lukebarousse/
⏰ TikTok: https://www.tiktok.com/@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