🎯Land Your Dream Job500+ Mock Interviews
Transform Your Tasks with AIGet 3x more done

Excel for Data Analytics - Full Course for Beginners

By - Luke Barousse

📚 Course Information

Channel

Luke Barousse

Published On

10/14/2024

📝 Description

🧮 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: 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 (My Course) - 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

🎯 What You'll Learn

Complete understanding of the topic

Hands-on practical knowledge

Real-world examples and use cases

Industry best practices

⭐ Course Features

🤖

AI Support

24/7 doubt solving

📝

Practice Quiz

Test your knowledge

🏆

Certificate

Course completion

📋 Prerequisites

  • Basic understanding of programming concepts

  • Eagerness to learn and practice

AI MentorLive Chat
Always here to help you learn
Premium

Get Full Course Access

Take your learning to the next level with premium features

Unlimited access to all chapters
Interactive quizzes & assessments
Downloadable certificate

Course Content

- Welcome
1
3 min

- Welcome

5 Questions Ready
- What is Excel?
2
3 min

- What is Excel?

5 Questions Locked
- About Course
3
4 min

- About Course

5 Questions Locked
- Excel Install
4
11 min

- Excel Install

5 Questions Locked
- Worksheets
5
16 min

- Worksheets

5 Questions Locked
- Workbooks
6
12 min

- Workbooks

5 Questions Locked
- Ribbon
7
14 min

- Ribbon

5 Questions Locked
- Formulas Intro
8
11 min

- Formulas Intro

5 Questions Locked
- Function Intro
9
11 min

- Function Intro

5 Questions Locked
- Logical Functions
10
10 min

- Logical Functions

5 Questions Locked
- Math Functions
11
9 min

- Math Functions

5 Questions Locked
- Statistical Functions
12
11 min

- Statistical Functions

5 Questions Locked
- Array Formulas
13
20 min

- Array Formulas

5 Questions Locked
- Lookup Function
14
17 min

- Lookup Function

5 Questions Locked
- Text Functions
15
13 min

- Text Functions

5 Questions Locked
- Date and Time Functions
16
8 min

- Date and Time Functions

5 Questions Locked
- Charts Intro
17
20 min

- Charts Intro

5 Questions Locked
- Charts Advanced
18
13 min

- Charts Advanced

5 Questions Locked
- Charts Statistics
19
12 min

- Charts Statistics

5 Questions Locked
- Sparklines
20
3 min

- Sparklines

5 Questions Locked
- Tables
21
17 min

- Tables

5 Questions Locked
- Formatting
22
16 min

- Formatting

5 Questions Locked
- Collaboration
23
14 min

- Collaboration

5 Questions Locked
- Project #1: Build Dashboard
24
46 min

- Project #1: Build Dashboard

5 Questions Locked
- Project #1: Share Projects
25
7 min

- Project #1: Share Projects

5 Questions Locked
- PivotTable Intro
26
21 min

- PivotTable Intro

5 Questions Locked
- PivotTable Advanced
27
14 min

- PivotTable Advanced

5 Questions Locked
- PivotCharts
28
10 min

- PivotCharts

5 Questions Locked
- Analysis Add-ins
29
19 min

- Analysis Add-ins

5 Questions Locked
- Data Tables
30
9 min

- Data Tables

5 Questions Locked
- Analysis ToolPak
31
14 min

- Analysis ToolPak

5 Questions Locked
- Power Query Intro
32
20 min

- Power Query Intro

5 Questions Locked
- Power Query Editor
33
29 min

- Power Query Editor

5 Questions Locked
- Advanced Transformations
34
21 min

- Advanced Transformations

5 Questions Locked
- Append vs Merge
35
24 min

- Append vs Merge

5 Questions Locked
- M Language
36
23 min

- M Language

5 Questions Locked
- Power Pivot Intro
37
25 min

- Power Pivot Intro

5 Questions Locked
- Power Pivot Window
38
19 min

- Power Pivot Window

5 Questions Locked
- DAX Intro
39
21 min

- DAX Intro

5 Questions Locked
- DAX Advanced
40
18 min

- DAX Advanced

5 Questions Locked
- Project #2: Share w/ Git & GitHub
41
17 min

- Project #2: Share w/ Git & GitHub

5 Questions Locked
- Project #2: Document w/ README.md
42
14 min

- Project #2: Document w/ README.md

5 Questions Locked