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

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

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: linkedin.com/in/kellyjianadams/
Kelly’s Website: kellyjadams.com

0️⃣ Excel Setup
Run Windows on a Mac (Virtual Machine) - lukeb.co/parallels
Microsoft 365 (Recommended) - microsoft.com/en-us/microsoft-365
Office Home & Student 2024 - microsoft.com/en-us/microsoft-365/p/office-home-2024/cfq7ttc0pqvj

📊 Project #1 - Salary Dashboard
One Drive Folder - onedrive.live.com
Project #1: Excel Online Version - lukeb.co/excel_dashboard

7️⃣ Power Query
What is Power Query? - learn.microsoft.com/en-us/power-query/power-query-what-is-power-query
Wikipedia Table S&P 500 - en.wikipedia.org/wiki/List_of_S&P_500_companies

8️⃣ Power Pivot / DAX
Merges (SQL Joins) - lukeb.co/sql_joins
DAX Guide - learn.microsoft.com/en-us/dax/

📈 Project #2 - Salary Analysis
Git Download - git-scm.com/downloads
GitHub Sign-up - github.com/signup
GitHub Desktop - desktop.github.com/download/
Markdown Cheatsheet - markdownguide.org/cheat-sheet/

📚 Recommended Books & Courses
SQL for Data Analytics - youtu.be/7mz73uXD9DA
The Excel 365 Bible - geni.us/excel_bible
M is for (Data) Monkey (renamed: Master Your Data) - geni.us/power_query

Social Media
======================
📫Newsletter: lukebarousse.com/
👨🏼‍💼 Linkedin: linkedin.com/in/luke-b/
🅧 X/Twitter: twitter.com/LukeBarousse
🌄 Instagram: instagram.com/lukebarousse/
⏰ TikTok: 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

• Excel for Data Analytics - Full Course for Beginners ( Download)
• Excel Data Analysis Full Course Tutorial (7+ Hours) ( Download)
• Excel Data Analytics Full Course | Essential Skills For Data Analysis In Excel | Simplilearn ( Download)
• Beginner to Pro FREE Excel Data Analysis Course ( Download)
• Excel for Beginners - The Complete Course ( Download)
• Free Excel courses for beginner data analyst ( Download)
• Introduction to Data Analysis with Excel: 2-Hour Training Tutorial ( Download)
• Top Excel courses for Data Analysts 🧑‍🎓📊 ( Download)
• Master Excel 2024: Advanced Filter, Sort, and Switch Functions for Data Analysis ( Download)
• Master Data Analysis on Excel in Just 10 Minutes ( Download)
• Excel Data Analysis Full Course | Excel Data Analysis Tutorial for Beginners | Simplilearn ( Download)
• Microsoft Excel Tutorial for Beginners - Full Course ( Download)
• 🔥Data Analytics Using Excel Full Course 2023 | Data Analytics Course For Beginners | Simplilearn ( Download)
• How I'd become a data analyst (if i had to start over) in 2024 ( Download)
• I started my data analyst career taking these beginner courses ( Download)