Excel for Data Analytics - Full Course for Beginners | Free Online Course — CourseBond

coursebond Insights Teach on CourseBond Log in Sign up

Course content

Section 1: Introduction

0 / 9 89 min
- Welcome Preview 3:53
- What is Excel? 3:26
- About Course 4:00
- Excel Install 11:23
- Worksheets 16:33
- Workbooks 12:51
- Ribbon 14:33
- Formulas Intro 11:29
- Function Intro 11:06
Section 2: Part 2: Logical Functions

0 / 9 126 min
- Logical Functions 10:40
- Math Functions 9:52
- Statistical Functions 11:28
- Array Formulas 20:14
- Lookup Function 17:57
- Text Functions 13:54
- Date and Time Functions 8:14
- Charts Intro 20:32
- Charts Advanced 13:32
Section 3: Part 3: Charts Statistics

0 / 9 153 min
- Charts Statistics 12:22
- Sparklines 3:58
- Tables 17:31
- Formatting 16:32
- Collaboration 14:30
- Project #1: Build Dashboard 46:13
- Project #1: Share Projects 7:03
- PivotTable Intro 21:07
- PivotTable Advanced 14:40
Section 4: Part 4: PivotCharts

0 / 9 173 min
- PivotCharts 10:10
- Analysis Add 19:17
- Data Tables 9:06
- Analysis ToolPak 14:58
- Power Query Intro 20:22
- Power Query Editor 29:47
- Advanced Transformations 21:45
- Append vs Merge 24:15
- M Language 23:58
Section 5: Advanced Topics

0 / 6 116 min
- Power Pivot Intro 25:50
- Power Pivot Window 19:17
- DAX Intro 21:16
- DAX Advanced 18:06
- Project #2: Share w/ Git & GitHub 17:33
- Project #2: Document w/ README.md 14:30

Enroll to watch this lesson

Get full lifetime access to all course material.