Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete Excel, ChatGPT, AI Online Course Mega Bundle
LEVEL 1 ๐๐จโ๐ป Excel for Beginners
Source Files
01 Quick Win - Track Spendings And Savings In Excel (9:58)
02 Make Your Expense Tracker More Readable (5:54)
Excel Functions Mastery Course
Source Files
1.1 Introduction to the Course (8:47)
1.2 Introduction of the instructor (3:30)
1.3 Course requirements (4:04)
1.4 How to get Excel (9:33)
2.1 What will we learn in this section (1:33)
2.2 Create An If() Function (3:24)
2.3 Nest And() Andor Or() Functions Within Reference Functions (6:37)
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
2.5 Create A Vlookup() Function (3:32)
2.6 Section Summary (9:37)
3.1 What will we learn in this section (2:23)
3.2 Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
3.3 Calculate minimums, maximums and averages from data sets (3:39)
3.4 Use the Forecast function to forecast numbers along a trend (6:57)
3.5 Generate a net present value using a formula (6:13)
3.6 Section Summary (7:38)
4.1 What will we learn in this section (1:14)
4.2 Work with Excelโs date manipulation functions (10:10)
4.3 Build a holiday date calculator (6:09)
4.4 Section Summary (4:43)
5.1 What will we learn in this section (3:46)
5.2 Split textual data apart (4:00)
5.3 Manipulate textual data (5:47)
5.4 Replace portions of textual data (4:42)
5.5 Put textual data back together with formulae (6:18)
5.6 Work with key informational functions for evaluating and responding correctly to errors in routine Excel calculations (12:00)
5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
5.8 Section Summary (6:26)
6.1 What will we learn in this section (4:08)
6.2 How to filter items in a list (8:24)
6.3 Sorting List without messing up the data (10:09)
6.4 How to freeze rows or columns (9:53)
6.5 Remove duplicates from a list (6:52)
6.6 Section Summary (6:32)
7.1 What will we learn in this section (2:09)
7.2 COUNT, COUNTA and COUNTIF Functions (11:57)
7.3 Create a drop down list (11:38)
7.4 Work with ISNUMBER and SEARCH functions within text functions (11:19)
7.5 Format row based on a cell value (10:54)
7.6 Create an invoice template in Excel (24:17)
7.7 Section Summary (4:46)
8.1 Course Summary and Next Steps (23:32)
LEVEL 2 ๐งโโ๏ธ๐ฉ Advanced Excel Functions - Introduction to PivotTables in Excel
Source Files
1.1 Introduction To The Course New (3:43)
1.2 Why Should You Learn Pivottables New (3:17)
1.3 Introduction Of The Instructor New (3:17)
1.4 Course Requirements (what Software, Experience) New (6:10)
2.1 What We Learn In This Section (1:21)
2.2 What Is A Pivot Table (2:01)
2.3 Pivottables Basics (2:52)
2.4 Pivottable Compliant Data Sources (2:12)
2.5 Build A Basic Pivottable (4:17)
2.6 Section Summary (2:13)
2.7 Challenge (1:23)
3.1 What Will We Learn In This Section (1:01)
3.2 Introduction To Formatting Pivottables (3:30)
3.3 Build An Expense Report (6:03)
3.4 Format The Expense Report Pivottable (4:18)
3.5 Finalize The Expense Report Pivottable (5:41)
3.6 Section Summary (2:12)
3.7 Challenge (1:04)
4.1 What Will We Learn In This Section (8:46)
4.2 What Are Excel Tables (7:23)
4.3 Sales Report Analysis With Pivottables (9:22)
4.4 Modify Source Data (3:58)
4.5 Format The Sales Report (8:38)
4.6 Complete The Sales Report Analysis (3:38)
4.7 Section Summary (3:03)
4.8 Challenge (1:47)
5.1 What Will We Learn In This Section (1:23)
5.2 What Is Slicing Data (3:41)
5.3 Slicing Data Project (5:40)
5.4 Data Slicer Tools (14:09)
5.5 Link Slicers To Multiple Pivottables (8:03)
5.6 Section Summary (2:32)
5.7 Challenge (2:04)
6.1 What Will We Learn In This Section (2:30)
6.2 Connect To Databases (2:06)
6.3 Import Data Sources (3:58)
6.4 Use Pivottables To Refine Data (4:41)
6.5 Consolidate Your Data Table (3:17)
6.6 Format Large Data Sets (4:51)
6.7 Slicer And Timeline In Large Data Sets (4:36)
6.8 Refresh And Drill Down From Databases (4:46)
6.9 Section Summary (4:01)
6.10 Challenge (2:02)
Excel Charts and Visualization
1.1 Introduction To The Course (4:46)
1.2 Why Should You Learn About Charts And Data Visualization (4:31)
1.3 Introduction Of The Instructor (2:08)
1.4 Course Requirements (what Software, Experience) (2:36)
2.1 What Will We Learn In This Section (1:21)
2.2 Main Principles And Chart Visualization Impact (2:39)
2.3 Choosing The Correct Chart (1:56)
2.4 Communicate With The End User (2:18)
2.5 Section Summary (2:59)
2.6 Challenge (2:12)
3.1 What Will We Learn In This Section (1:36)
3.2 Chart Design (6:39)
3.3 Working With Chart Formats (4:35)
3.4 Chart Types (2:08)
3.5 Primary & Secondary Axis (4:20)
3.6 Chart Templates (3:25)
3.7 Section Summary (2:50)
3.8 Challenge (1:23)
Excel Charts and Visualization (Part 2)
4.1 What Will We Learn In This Section (1:20)
4.2 Excel Column Charts (4:13)
4.3 Column Charts Challenge (1:08)
4.4 Excel Bar Charts (3:12)
4.5 Bar Charts Challenge (0:48)
4.6 Excel Line Charts (3:52)
4.7 Line Charts Challenge (0:48)
4.8 Excel Pie Charts (5:01)
4.9 Pie Charts Challenge (0:57)
4.10 Excel Area Charts (2:27)
4.11 Area Charts Challenge (0:50)
4.12 Excel Scatter Charts (4:00)
4.13 Scatter Charts Challenge (0:41)
4.14 Excel Bubble Charts (5:12)
4.15 Bubble Charts Challenge (0:54)
4.16 Excel Stock Charts (3:07)
4.17 Stock Charts Challenge (0:56)
4.18 Excel Surface Charts (4:42)
4.19 Surface Charts Challenge (0:43)
4.20 Excel Radar Charts (2:58)
4.21 Radar Charts Challenge (0:38)
4.22 Excel Treemap Charts (2:31)
4.23 Treemap Charts Challenge (1:03)
4.24 Excel Sunburst Charts (2:36)
4.25 Sunburst Charts Challenge (0:59)
4.26 Excel Histogram & Pareto Charts (4:02)
4.27 Histogram & Pareto Charts Challenge (1:04)
4.28 Excel Waterfall Charts (5:26)
4.29 Waterfall Charts Challenge (0:46)
4.30 Excel Box & whisker Charts (3:24)
4.31 Box & whisker Charts Challenge (1:03)
4.32 Excel Sparklines (3:44)
4.33 Sparklines Challenge (0:53)
4.34 Excel Color Scales (3:42)
4.35 Color Scales Challenge (0:49)
4.36 Excel 3d Map (4:35)
4.37 3D Map Challenge (1:45)
4.38 Section Summary (10:13)
Excel Charts and Visualization (Part 3)
5.1 What Will We Learn In This Section (2:23)
5.2 Data Visualization With Pivot Chart And Slicers (7:05)
5.3 Challenge Data Visualization With Pivot Chart And Slicers (1:34)
5.4 Create Break Even Chart (9:25)
5.5 Challenge Break Even Chart (1:12)
5.6 Rating Star Chart (7:09)
5.7 Challenge Star Rating (1:28)
5.8 Drop Down Menu For Chart (16:31)
5.9 Challenge Drop Down Menu Chart (1:20)
5.10 Risk Score Chart (11:03)
5.11 Challenge Risk Score Chart (1:23)
5.12 Dynamic Chart Update (8:10)
5.13 Challenge Dynamic Chart Update (1:47)
5.14 Section Summar (6:48)
6.1 Course Summary And Next Steps (16:29)
Excel Financial Analysis
1.1 Introduction To The Course (4:16)
1.2 Why Should You Learn Financial Analysis (4:22)
1.3 Introduction Of The Instructor (6:24)
1.4 Course Requirements (what Software, Experience) (5:46)
2.1 What Will We Learn In This Section (2:35)
2.2 Preparing Data Source For P&l (16:08)
2.3 Create P&l Structure (13:27)
2.4 Adding Data To P&l (19:48)
2.5 Calculating Variances (11:51)
2.6 Balance Sheet Structure (10:43)
2.7 Adding Values On Bs From Different Files Format (20:38)
2.8 Cash Flow Structure (10:25)
2.9 Calculating Cash Flow (11:05)
2.10 Challenge (1:36)
3.1 What Will We Learn In This Section (5:48)
3.2 Forecast With Scenarios (23:30)
3.3 How To Calculate Finance Main KPI-s (15:38)
3.4 Fixed Assets Roll Forward (18:29)
3.5 Loan Schedule (13:54)
3.6 Ar Management Basics (20:49)
3.7 Customers Rank (11:56)
3.8 Create Budgets Categories (19:45)
3.9 Challenge (1:25)
4.1 Course Summary And Next Steps (31:21)
Excel Data Visualization
1.1 Introduction To The Course (8:27)
Source Files
1.2 Introduction Of The Instructor (3:11)
1.3 Course Requirements (2:59)
1.4 How To Get Excel (4:14)
2.1 What Will We Learn In This Section (1:20)
2.2 What Are Dashboards (5:39)
2.3 Answers You Need Before You Start A Dashboard (7:45)
2.4 Best Practices For Dashboard Layout (4:42)
2.5 Best Practices For Dashboard Colors (3:54)
2.6 Section Summary (3:40)
3.1 What will we learn in this section (1:16)
3.2 Build a Wireframe in Excel (5:42)
3.3 Prepare Raw Data for Dashboard (5:57)
3.4 Prepare Calculation sheet (13:01)
3.5 Section Summary (6:08)
4.1 What will we learn in this section (2:48)
4.2 Build a Combo Box (10:44)
4.3 Complex Lookup (14:36)
4.4 Build a Scrolling Data Table (11:41)
4.5 Conditionally Format Actual Values vs Budgeted Values (10:52)
4.6 Conditional Headers (9:25)
4.7 Section Summary (3:01)
5.1 What will we learn in this section (1:50)
5.2 Show Top Matches Over and Under Budget (9:21)
5.3 List Box to Select Indicators (5:11)
5.4 Toggle Between Top Over or Under (12:50)
5.5 Section Summary (2:19)
6.1 What will we learn in this section (3:20)
6.2 Prepare Data for Scrolling Chart (14:19)
6.3 Scrollable Line Chart (11:17)
6.4 Remove Crashing Lines (4:13)
6.5 Toggle Visibility of Line Series (9:56)
6.6 Finetune the Line Series (7:08)
6.7 Section Summary (5:35)
7.1 What will we learn in this section (1:56)
7.2 Add Interactivity to Reports with Pivot Slicers (10:44)
7.3 Column Chart Controlled by Slicer (6:47)
7.4 Pivot SLicer Sorting (4:26)
7.5 Select Only 1 Slicer (2:13)
7.6 Dynamic Comments with SLicers (11:36)
7.7 Section Summary (2:58)
8.1 What will we learn in this section (1:01)
8.2 Add Calculations for Variances in Pivot Tables (4:23)
8.3 Conditional Formatting in Pivot Tables (7:04)
8.4 Refresh Pivot Table with Easy VBA (7:49)
8.5 Section Summary (2:33)
9.1 Course Summary and Next Steps (10:27)
Beginners Excel Power Query and M Masterclass - 01 Course Overview
Source Files 01
01 What Are Power Query And M (8:16)
02 Course Overview (6:16)
02 Build your first M queries
Source Files 02
01 Capitalize A Table Column (6:39)
02 Build An Expression With Let (17:10)
03 Join tables with M
01 Build And Reference Tables (8:08)
02 Append And Combine Tables (5:33)
03 Inner Join Tables (5:33)
Join tables with M - Source Files
04 Build M functions to perform tasks
01 Build M Functions To Perform Tasks (8:14)
02 Call Functions (5:10)
03 Use The Each Keyword (2:33)
04 Change A Table With A Function (7:30)
05 Loop An Action With A Recursive Function (8:02)
06 Calculate Price After Discount (6:09)
07 Use Optional Parameters To Combine Text (5:13)
08 Transform A List With A Function (2:09)
09 Calculate Number Of Working Days (12:20)
Build M functions to perform tasks - Source Files
05 Work with lists in M
01 Build A List With Each (5:16)
02 Concatenate Items In A List (5:01)
03 Iterate Over A List (4:18)
04 Iterate Over A List With Recursion (3:26)
Work with lists in M - Source Files
06 Build M variables to store data
01 Calculate Affiliate Revenue (4:37)
02 Variable Types (5:49)
03 Variable Scope - Where Can You Use Variables (8:57)
04 Order Of Evaluation (5:18)
Build M variables to store data - Source Files
07 Aggregate table data with M
01 Count Rows (7:32)
02 Calculate Profits Per Quarter (5:55)
03 Group Similar Rows (5:59)
04 Sort A Table (5:27)
05 Query Data From Another Spreadsheet (7:18)
06 Find Where Sales Met Quota (2:55)
Aggregate table data with M - Source Files
08 Work with tables in M
01 Build Tables (6:55)
02 Work With Tables (5:37)
03 Fill In A Table (3:27)
Work with tables in M - Source Files
09 Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Build conditions with M if expressions - Source Files
10 Work with M data types
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Work with M data types - Source Files
11 Build queries for tables with M
01 Filter A Table By Row (6:59)
02 Format A List Of Values Into A Table (7:57)
Build queries for tables with M - Source Files
12 Build calculations for tables with M
01 Build Address Labels (8:27)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Build calculations for tables with M - Source Files
13 Fetch data from the web with M
01 Query Tables From The Web (7:15)
02 Search For Links On The Web (8:09)
03 Check If A Webpage Exists (6:24)
Fetch data from various sources with M - Source Files
Advanced Excel Power Query and M Masterclass - 00 Course overview
00 Course Overview - Advanced Excel Power Query And M (4:09)
01 What Are Power Query And M (8:15)
Course overview - Source Files
01 Build expressions with let
01 Build Nested Let Expressions (3:53)
02 Build A List With A Sequence (2:43)
03 Build An Unnamed Record (4:14)
Build expressions with let - Source Files
02 Build expressions with each
01 Work With The Each Keyword (5:00)
02 Generate A List (5:41)
03 Find An Entry In A Record (2:16)
04 Select Items From A List (5:06)
05 Serialize A Column (13:43)
06 Find Best Match Of Values (21:49)
Build expressions with each - Source Files
03 Build M functions to perform tasks
01 Build A Function (3:21)
02 Build A Closure (6:27)
03 Build A Function In A Record (4:23)
04 Count Fibonacci Numbers With A Recursive Function (7:04)
05 Remove Html Tags (9:19)
06 Build A For Each Loop (9:38)
Build M functions to perform tasks - Source Files
04 Work with tables in M
01 Select A Column From A Table (3:40)
02 Select A Value At A Row And Column (3:05)
03 Select Row Where A Condition Is Met (3:53)
04 Cross Join Tables (8:40)
05 Join Tables On A Key (5:48)
06 Change Column Types (3:49)
07 Fill A Table With Random Values (7:12)
Work with tables in M - Source Files
05 Pivot a table
00 What Is Pivoting (1:28)
01 Pivot A Table (12:05)
Pivot a table - Source Files
06 Build expressions with evaluate
01 Build An Expression With Evaluate (3:06)
02 Build A Nested Evaluate Expression (3:04)
03 Use Global Library Functions (2:27)
Build expressions with evaluate - Source Files
07 Work with matrices in M
00 How To Multiply Matrices (3:03)
01 Build Matrices In M (4:32)
02 Multiply Matrics (17:45)
Work with matrices in M - Source Files
LEVEL 3 ๐ค๐ฎ Excel VBA & Macros
01.00 Course Overview (2:24)
02.00 How To Save Macros (1:34)
Source Files
Send Messages with MsgBox
03.00 Topics Overview (0:54)
03.01 Build A Simple Message (3:34)
03.02 Build An Advanced Message (5:10)
03.03 Empty A Sheet With The Msgbox Function (6:44)
03.04 Prompt User For Input (7:30)
03 Source Files
04 Workbook and Worksheet Object
04.00 Topics Overview (1:30)
04.01 Object Hierarchymp4 (5:10)
04.02 Change Multiple Worksheets (7:05)
04.03 Add And Count Worksheets (6:01)
04.04 Get Path Of A Workbook (5:14)
04.05 Open And Close Workbooks (8:41)
04.06 Loop Through Worksheets And Workbooks (8:20)
04.07 Build A Sales Calculator (11:54)
04.08 Change Charts (10:30)
04 Source Files
05 Work with the Range Object
05.00 Topics Overview (1:22)
05.01 Program A Range Of A Spreadsheet (6:55)
05.02 Use Cells Instead Of A Range (6:04)
05.03 Use A Range Variable (6:04)
05.04 Select A Range (4:52)
05.05 Access A Row (4:35)
05.06 Copy And Paste A Range (8:45)
05.07 Clear A Range (3:59)
05.08 Count A Range (4:21)
05 Source Files
06 Work with Range Properties
06.00 Topics Overview (1:03)
06.01 Find The Current Region Of A Cell (7:23)
06.02 Dynamic Range Program (7:11)
06.03 Resize A Range (2:30)
06.04 Select Entire Rows And Columns (6:33)
06.05 Offset Property (3:32)
06.06 End Property (5:06)
06 Source Files
07 More Range Projects
07.00 Topics Overview (1:21)
07.01 Union And Intersect Of Ranges (4:24)
07.02 Detect Content (5:38)
07.03 Build A Range Program (5:47)
07.04 Change Text Color (4:30)
07.05 Bold A Range (2:39)
07.06 Change Cell Color (5:04)
07.07 Work With Areas (4:55)
07.08 Find Differences In Ranges (8:17)
07 Source Files
08 Variables
08.00 Topics Overview (1:38)
08.01 Integer Data Type (2:58)
08.02 String Data Type (2:20)
08.03 Double Data Type (2:54)
08.04 Boolean Data Type (4:05)
08.05 Retain Variable Value (2:54)
08 Source Files
09 Work with Conditionals
09.00 Topics Overview (1:26)
09.01 If Then Statement (4:38)
09.02 Else Statement (4:55)
09 Source Files
10 Work with AND, OR and NOT
10.00 Topics Overview (1:21)
10.01 Greeting Program - Logical Operator And (4:00)
10.02 Logical Operator Or (5:37)
10.03 Logical Operator Not (3:15)
10 Source Files
11 Build Conditionals Projects
11.00 Topics Overview (1:58)
11.01 Select Case (5:42)
11.02 Build A Commission Calculator Project (6:11)
11.03 Find Remainder With Mod (3:11)
11.04 Check Number Program (6:38)
11.05 K Smallest Value Program (6:54)
11.06 Group By Font Style (6:45)
11.07 Remove Empty Cells (5:26)
11 Source Files
Introduction to Loops
00 Topics Overview (0:57)
01 Single Loop (5:59)
02 Double Loop (5:14)
03 Triple Loop (6:24)
04 Do While Loop (5:34)
05 Build A Commission Table (5:33)
Source Files
Loop Projects
00 Topics Overview (1:40)
01 Loop Through Defined Range (3:37)
02 Loop Through Entire Column (3:29)
03 Do Until Loop (3:22)
04 Use Step To Increment (4:23)
05 Build A Pattern Project (4:50)
06 How To Sort (5:32)
07 Sort By Related Data (8:15)
08 Delete Duplicate Values (6:10)
Source Files
String Manipulation
00 Topics Overview (1:28)
01 Join Strings (3:13)
02 Extract Substrings From Left Or Right (3:07)
03 Extract Substring At Middle (4:12)
04 Get Length Of A String (2:40)
05 Get Substring Position (3:16)
06 How To Split Strings (4:56)
07 Reverse Characters (4:10)
08 Change String Casing (3:28)
09 Count Words In A Range (8:17)
Source Files
Build Custom Functions
00 Topics Overview (1:19)
01 Make And Use Your Own Function (6:33)
02 Pass Arguments To A Function (7:43)
03 Custom Calculator Function (6:23)
Source Files
Build Arrays
00 Topics Overview (1:18)
01 One Dimensional Array (5:46)
02 Two Dimensional Array (6:26)
03 Change Array Size (4:54)
04 Build An Array (5:09)
05 Populate Row With Array (3:21)
06 Array Length (6:47)
07 Split String Into An Array (4:28)
08 Join Array Into A String (3:49)
Source Files
Work with Dates
00 Topics Overview (1:12)
01 Delay A Procedure (4:12)
02 Schedule A Procedure (4:18)
03 Count Years (5:20)
04 Count Days Between Dates (2:42)
05 Count Weekdays Between Dates (4:51)
06 Sort Dates (6:27)
Source Files
VBA Projects
00 Topics Overview (0:52)
01 Build A Table (4:47)
02 Build A Table Of Contents (11:47)
03 Build A Table Of Contents 2 (4:42)
04 Combine Worksheets (17:42)
05 Combine Worksheets By Column (15:49)
Source Files
Programming Charts
00 Topics Overview (1:20)
01 Program A Chart (6:12)
02 Program An Embedded Chart (4:59)
03 Delete Charts Programatically (2:19)
Source Files
LEVEL 4 ๐ฃ๏ธ๐ค Excel and ChatGPT Integration
01 01 What Is Chatgpt (7:50)
00-01 Introduction Of The Instructor (2:25)
01 02 Intro To Prompt Engineering-Prompt Types (8:28)
01 03 Intro To Prompt Engineering-Effective Prompts (8:41)
01B 01 Project Preview (2:04)
01B 02A Simplify Complex Information (8:38)
01B 02B Simplify Complex Information-Other Strategies (8:41)
02 03 Proofread-Email And Business Proposals (8:39)
02.03 Proofread-More Use Cases (8:24)
02.04 Re-Organize Data-Benefits And First Sample Use Case (6:22)
02.04 Re-Organize Data-Potential Use Cases Case (10:44)
02.05 Work With Spreadsheets-Automating Data Entry (7:46)
02.05 Work With Spreadsheets-Formulas And Other Use Cases (7:31)
03 01 Project Preview (1:23)
03.02 Create Content (4:03)
03.03 Social Media (4:26)
03.04 Write Ad Copy (8:17)
03.05 Write Email Marketing Campaigns (4:55)
03.06 Write An Outreach Message (5:08)
03.07 Copyrighting (4:29)
03.08 Seo (5:09)
03.09 Video Scripts (8:49)
03.10 Generate Text In Your Writing Style (3:25)
04 01 Project Preview (1:51)
04.02 Research-Chatgpt Usecase And Benefits (7:05)
04.02 Research-More Examples And Explanation (7:49)
04.03 Write An Article-Add Role To Chatgpt (7:17)
04.03 Write An Article-Generate High Quality Content (8:02)
04.04 Check Plagiarism (10:56)
04.05 Prepare For Job Opportunities-Cv And Cover Letter (8:28)
04.05 Prepare For Job Opportunities-Interview Questions, Connection And Task Generator (8:36)
05 01 Project Preview (2:33)
05.02 Generate Code-Javascript And Python Code Snippets (9:26)
05.02 Generate Code-Stylesheet, Html, C++ And Conversion (9:20)
05.03 Build Algorithms-Algorithm To Pseudocode (4:03)
05.03 Build Algorithms-Realworld Use Cases (8:11)
05.04 Debug-Python Use Case (6:51)
05.04 Debug-React, Api, Javascript, Html And Css (6:56)
05.05 Write Code Documentation (9:51)
05.06 Use Chatgpt As A Linux Terminal (8:32)
05.07 Use Chatgpt As A Unix Terminal (9:08)
05.08 Use Chatgpt As A Microsoft Dos Terminal (5:28)
05.09 Use Chatgpt To Suggest Uxui Designs (8:10)
05.10 Use Chatgpt To Suggest Cybersecurity Solutions (10:05)
Source Files
Introduction to JavaScript
01 Introduction To The Course (1:09)
Source file
02 Introduction Of The Instructor (0:36)
03 Why Should You Learn Javascript (0:51)
04 Quick Win (0:58)
05 Course Requirements (0:42)
02. Variables and Data Types
01 What Will We Learn In This Section (0:43)
Source Files
02 Variables (10:21)
03 Data Types (5:39)
04 Variable Mutation (6:53)
05 Type Coercion (6:52)
06 Coding Challenge (1:36)
07 Coding Challenge Solution (2:42)
08 Section Summary (0:50)
03. Operators
Source Files
01 What Will We Learn In This Section (0:35)
02 Basic Operators (15:34)
03 Operator Precedence (5:44)
04 Coding Challenge (2:14)
05 Coding Challenge Solution (5:52)
06 Section Summary (0:56)
04. Conditional Statements
01 What Will We Learn In This Section (0:35)
Source Files
02 If Else Statements (11:46)
03 Boolean Logic (7:59)
04 Switch Statements (10:53)
05 Truthy And Falsie Values (6:03)
06 Equality Operators (4:55)
07 Coding Challenge (2:25)
08 Coding Challenge Solution (4:54)
09 Section Summary (1:15)
05. Functions and Arrays
01 What Will We Learn In This Section (0:37)
Source Files
02 Functions (9:47)
03 Function Statements And Expressions (7:39)
04 Arrays (10:08)
05 Coding Challenge (3:52)
06 Section Summary (1:29)
06. Objects
Source Files
01 What Will We Learn In This Section (0:49)
02 Objects And Properties (9:50)
03 Objects And Methods (12:26)
04 Objects Vs Primitives (16:19)
05 Coding Challenge (0:53)
06 Coding Challenge Solution (5:16)
07 Section Summary (0:44)
07. Loops
Source Files
01 What Will We Learn In This Section (0:38)
02 Loops (15:16)
03 Iteration (12:38)
04 Coding Challenge (1:05)
05 Coding Challenge Solution (6:33)
06 Section Summary (0:50)
08. JavaScript Execution
01 What Will We Learn In This Section (0:57)
Source Files
02 Javasript Parsers And Engines (5:17)
03 Execution Contexts And Execution Stack (2:27)
04 Creation And Execution Phases (6:33)
05 Hoisting (2:14)
06 Scoping (4:53)
07 Scope Chain (3:21)
08 This Keyword (4:15)
09 Coding Challenge (0:47)
10 Coding Challenge Solution (3:22)
09. Build A JavaScript Project
01 What Will We Learn In This Section (0:38)
Source Files
02 Project Setup (9:55)
03 Events And Event Handling (17:10)
04 Make Updates (10:40)
05 State Variables (1:43)
06 Coding Challenge (0:41)
07 Coding Challenge Solution (2:37)
08 Section Summary (0:49)
10. Course Summary
Source Files
Course Summary (3:19)
ChatGPT 4 Prompt Engineering for Finance and Stock Market Investing
02 01 Project Preview (2:03)
01.01 Course Requirement (3:20)
02 02A Analyze Financial Statements Of Stock (9:00)
02 02B Financial Ratio And Trend Analysis (4:25)
02 03 Balance Sheet, Income Statement And Cash Flow Statement (9:00)
02 04 Loopholes And Weaknesses In Stock Financials (8:39)
02 05 Analyze Historical Stock Performance (11:16)
02 06 Predict Stock Performance (5:08)
02 07 Market Share (5:31)
02 08 Industry Analysis (7:48)
02 09 Management Team Analysis (8:25)
02 10 Analyze Stock Risks (6:56)
02 11 Valuation (8:11)
02 12 Explain Business Model Of A Company (6:24)
02 13 Perform A Swot Analysis (8:16)
02 14 Summarize A CompanyโS Earnings Report Calls (6:55)
02 15 Evaluate A CompanyโS Esg Credentials (4:39)
03 01 Project Preview (0:48)
03 02A Invest Short Term (6:22)
03 02B Implementing Your Short-Term Investment Strategy (8:06)
03 03A Invest Long Term (5:58)
03 03B Analyzing The Results (7:27)
03 04A Using Chatgpt To Assess Your Risk Tolerance (7:32)
03 04B Customized Investment Recommendations Based On Individual Financial Goals And Risk Tolerance (5:26)
03 04C Implementing Your Customized Investment Plan (8:47)
04 01 Project Preview (1:25)
04.02A Recent Past Stock Market State (7:44)
04.02B Analyzing Past Trends And Economic Events (9:24)
04.03A Present Stock Market State (6:29)
04.04A Future Stock Market State (8:12)
04.04B Insights On Macroeconomic Factors (7:09)
05 01 Project Preview (2:22)
05.02 Analyze Credit Scores (7:56)
05.03 Assess Loan Applicant Risk (7:35)
06 01 Project Preview (1:12)
06.02A Pick Stocks With Company Evaluation (6:00)
06.03A Build A Trading Strategy (8:54)
06.03B Test Trading Hypthothesis (8:29)
07 01 Project Preview (1:03)
07.02 Chatgpt And Sentiment Analysis (8:52)
07.03 Analyzing Sentiments On Social Media Posts- (8:45)
08 01 Project Preview (1:03)
08.02A Fraud Detection With Chatgpt (7:37)
08.02B Detecting Exploitation Prone Weaknesses (8:01)
08.03A Red Flags And Anomaly Detection (6:07)
08.03B Anomaly Detection Techniques (8:01)
Source Files
ChatGPT 4 for Marketing Professionals
Source file
00 01 Introduction Of The Instructor (1:53)
01.01 Setting Up Your Chatgpt Account - A Step-By-Step Guide (6:04)
01.02 Tips For Getting The Best Responses From Chatgpt (9:55)
02 01 Building A Marketing Campaign Content Calendar With Chatgpt (10:34)
03 01 The Importance Of Identifying Your Target Audience (3:08)
03.02 Using Chatgpt For Target Audience Research And Assessment (11:54)
04 01 Project Preview (1:21)
04.02 Exploring Social Media Marketing And Automation (5:59)
04.03 Generating Social Media Posts (10:38)
04.04 Social Media Automation Tool - Socialbee - -Bonus- (6:40)
04.05 Automating Social Media Post Scheduling - -Bonus- (8:26)
04.06 Automating Social Media Reposting - -Bonus- (8:28)
04.07 Configuring Your Social Media Automation Timetable โ -Bonus- (4:00)
05 01 Project Preview (1:11)
05.02 Generate Optimized Keywords And Blog Headlines (7:39)
05.03 Building An Seo-Enhanced Blog Post Quickly (10:07)
06 01 Introduction To Email Marketing And Its Significance (3:37)
06.02 Building Effective Email Sequences (7:27)
07 01 Crafting Sales Page Copy (8:05)
08 01 Project Preview (1:07)
08.02 Producing Facebook Ads (10:00)
08.03 Generating Google Ads (9:44)
08.04 Generate Ads For Instagram And Twitter (7:36)
09 01 Project Preview (1:09)
09.02 Generating Unlimited Video Concepts (10:33)
09.03 Crafting A Full Youtube Video Script (10:00)
09.04 Youtube Seo Strategies (8:54)
10 01 Project Preview (1:26)
10.02 Guides To Building Effective Marketing Funnels (4:01)
10.03 Defining Your Buyer Persona (9:38)
10.04 Generating A Lead Magnet (8:57)
10.05 Building Landing Page And Social Media Copy (9:02)
10.06 Composing A Comprehensive Email Sequence For Your Funnel (4:49)
11 01 Review Analysis And Optimization Of Products And Services (7:24)
12 01 Project Preview (1:57)
12.02 Homepage, About Us, And Contact Us Page Copy (10:14)
12.03 Generate Meta Title And Descriptions (4:58)
12.04 Website Development With Chatgpt Crash Course (25:32)
13 01 Project Preview (1:10)
13.02 Creating Product And Business Names (7:52)
13.03 Developing Professional Taglines And Slogans For Your Brand (7:32)
13.04 Writing Product Descriptions For Your Online Store (4:46)
13.05 Building FaqโS For Services Or Products (4:54)
14 01 Conclusion (2:08)
Bonus - Tips And Tricks (7:43)
Advanced Business and Excel in ChatGPT
01.01 Course Requirement (2:31)
02.01 Project Preview (1:36)
02.02A Set Up Excel Spreadsheet With GPT Add-In (8:37)
02.02B Excel With ChatGPT (4:51)
02.03 Write Excel Formulas With ChatGPT (9:39)
02.04 Use ChatGPT Formulas In Excel (16:18)
03.01 Project Preview (1:27)
03.02A Set Up Dashboard (7:51)
03.02B Set Up Data (7:11)
03.03A Use ChatGPT And Excel To Build An Investment Dashboard (11:37)
03.03B Generate More Formulas For Excel (11:34)
03.03C Placing Data On Dashboard (10:30)
04.01 Project Preview (2:10)
04.02A Project Setup - Product Worksheet (11:59)
04.02B Setup Sales And Summary Sheet (9:22)
04.03A Build Advanced Chatgpt Excel Project (13:00)
04.03B Automating Product Name And Price Data (13:11)
04.03C Completing Sales Sheet Automation With Chatgpt (9:32)
04.03D Building Sales Overview Dashboard (8:37)
04.03E Refining The Pos System (11:14)
05 01 Project Preview (2:18)
05.02 Meeting Agendas And Minutes (10:25)
05.03 Write A Business Proposal (11:18)
05.04 Build A Business Report (11:12)
05.05 Build A Business Plan (10:35)
05.06 Build A Business Performance Appraisal (10:39)
05.07 Build A Business Presentation (12:40)
05.08 Summarize Business Documents (11:44)
05.09 Write Job Descriptions (8:33)
05.10 Build White Papers (9:38)
05.11 Build Employee Handbooks (8:44)
05.12 Build Business Manuals (9:24)
06.02 Set Up Project (1:16)
06.03A Advanced Chatgpt 4 Business Project (10:10)
06.03B Chatgpt And Social Bee Side By Side (10:16)
06.03C Finishing Touches (12:26)
Source File
ChatGPT for C-Level Management
01 01 Course Requirements (1:48)
01.02 What Is ChatGPT And Its Role With C-Level Management (1:35)
01.03 Overview Of Limitations And Capabilities (2:30)
02 01 Project Preview (1:43)
02.02 Drafting And Editing Business Content (13:36)
02.03 Branstorming Content Ideas (12:08)
02.04 Text Translation (13:39)
03.01 Project Preview (1:20)
03.02 Code Writing And Debugging (14:25)
03.03 Data Analysis And Summarization From Lower-Level Management (12:17)
04.01 Project Preview (1:49)
04.02 Generating Work Schedules (17:13)
04.03 Preparing For Interviews (17:34)
04.04 Task Delegation With Chatgpt (17:13)
05.01 Project Preview (1:14)
05.02 Writing Clear And Specific Prompts (6:47)
05.03A Privacy Considerations (11:25)
05.03B Things To Look At When Working With Chatgpt (9:50)
05.04 How To Provide Feedback For Continuous Learning (8:54)
Conclusion (2:58)
Tips And Tricks (10:11)
Source files
ChatGPT for Sales
01 01 Course Requirements (1:38)
01.02 Understanding Chatgpt (2:34)
01.03 The Role Of AI In Sales And Lead Generation (1:53)
01.04. Overview Of How Chatgpt Can Improve Outreach Strategy (1:34)
02 01 Project Preview (1:11)
02.02 How To Make Specific Asks (16:07)
02.03 Defining Terms For Chatgpt (3:15)
02.04 Understanding And Setting The Right Tone For Your Messages (13:05)
02.05 The Limitations Of AI In Sales And Lead Generation (12:45)
02.06 How To Utilize Chatgpt Effectively While Being Aware Of Its Limitations (16:09)
02.07 The Importance Of Checking And Editing AI Output (6:15)
03 01 Project Preview (1:18)
03.02 Defining Your Audience For Effective Outreach (19:40)
03.03 Using ChatGPT To Discover Audience Pain Points And How Your Product Solves Them (11:47)
03.04 Identifying Common Objections And Questions With Chatgpt (18:56)
03.05 Generating Cold Call Scripts, Elevator Pitches, And Battle Cards For Discovery Calls (15:16)
04 01 Project Preview (1:31)
04.02 Using Chatgpt To Generate Content Ideas For Nurturing Leads Through The Sales Funnel (19:10)
04.03 Sales Flow, Linked And Chatgpt (17:26)
05 01 Project Preview (0:59)
05.02 Understanding The Importance Of Linkedin For B2b Sales3 (3:04)
05.03A How To Use Chatgpt To Enhance Your Linkedin Sales Strategy (6:56)
05.03B ChatGPT And Linkedin Usecases (13:17)
05.03C Handling Lead Response With Chatgpt (6:48)
05.04 Best Practices For Using Chatgpt With Linkedin Message Templates For Higher Conversions- (8:36)
06 01 Project Preview (1:33)
06.02A Using Roleplay To Anticipate Pain Points And Objections (5:13)
06.02B Conversational Role Play (15:14)
06.03A Advance Techniques For Utilizing ChatGPT In Sales (9:55)
06.03B Advance Tips For Brainstorming And Analyzing Pain Points (10:25)
06.03C Secret Prompts For Better Response (18:16)
07 01 Privacy Considerations (19:27)
07.02 Feedbacks For Continuous Learning (5:21)
Source files
ChatGPT for Leadership
01 01 Preview Of The Course And Learning Objectives (1:57)
01.02 Course Requirements (2:10)
01.03 Role Of AI In Leadership (1:24)
01.04 How Chatgpt Can Aid Business Leaders (1:46)
02 01 Project Preview (0:56)
02.02A Examples Of Effective Chatgpt Prompts For Leadership (10:09)
02.02B Plugin System And More Effective Prompts (12:04)
02.03 Analyzing The Repsonse From Chatgpt (12:46)
02.04 Discussion And Analysis Of Chatgpt-s Generated Content (3:27)
03 01 Project Preview (1:36)
03 02 Understanding The Concept Of A Thought Partner (9:35)
03 03 How To Use Chatgpt As Thought Partner (15:11)
03 04 Providing Quick And Accurate Answers To Employee Queries (12:20)
03 05 Assisting In The Onboarding Process (17:20)
03 06 Improving Communication And Collaboration With The Help Of Chatgpt (14:51)
03 07A Providing Personalized Support To Team Members (9:49)
03.07B Tailored And Personalized Team Support (14:58)
03.08 Using Chatgpt For Training And Development (9:05)
03.09A Integrating Chatgpt Into Your Workflow (11:46)
03.09B ChatGPT As CEO (8:21)
04 01 Project Preview (2:15)
04.02 Enhancing Customer And Employee Engagement (16:28)
04.03 Tailoring Messages For Diffferent Audiences (8:50)
04.04 Using Chatgpt For Tricky Text Composition And Concept Explanation (9:13)
05 01 Project Preview (1:26)
05.02 Language Translation With Chatgpt For Global Business (17:32)
05.03 Using Chatgpt To Understand And Navigate Cultural Differences (7:07)
05.04 Successful Stories With Chatgpt (3:39)
06 01 Project Preview (1:26)
06.02A The Role Of AI In Data Analysis And Decision Making (13:17)
06.02B Sample Use Cases For Decision Making (13:19)
06.03 Utilizing Chatgpt For Strategic Planning And Forecasting (16:26)
Conclusion And Tips (20:04)
Source files
The Complete ChatGPT Automation Masterclass for Coaches and Trainers
01.01 Course Requirements
02.01 Getting Started (6:16)
03.01 Project Overview (2:02)
03.02A Utilizing Chatgpt In Training (9:52)
03.02B Automating Materials For Training Processes (9:42)
03.02C Use Case On Other Fields (10:02)
03.02D Chatgpt Web Browsing Feature (8:30)
03.02E Plugin System Overview (11:32)
04.01 Conclusion (1:24)
Source Files
Sales Analytics and Modeling in Excel with ChatGPT
1.1 Course Requirement (1:34)
02 01 Project Preview (0:57)
02.02. Sales Key Perfomance Indicators (KPIs) (10:16)
02.03.Measuring Salesperson Performance Using KPIs (5:48)
02.04.Marketing And Financial KPIs (6:49)
02.05.Customer-Related KPIs (10:20)
03 01 Project Preview (0:38)
03 02 Case Study Involving KPIs (3:09)
03.03. Joining Data Tables In Excel (7:28)
03.04.Cleaning Data Using Filters In Excel (5:19)
03.05.Determining Lead Conversion Time (5:19)
04 01 Project Preview (1:19)
04.02. Aggregating data by regions, categories, and time dimension (6:24)
04.03.Evaluating Salesperson Performance (13:59)
05 01 Project Preview (1:18)
05.02.Creating Charts To Visualize Sales Data (8:08)
05.03.Charting Region-Wise Percentage Contribution (6:22)
05.04.Charting Category-Wise Average Order Value (5:47)
05.05.Analyzing Lead Generation Trends (7:54)
05.06.Analyzing Salesperson Performance (6:26)
05.07.Building A Sales Dashboard (6:22)
05.08. Additional Charts For Sales Modeling (8:33)
06 01 Project Preview (1:33)
06.02.Building The Whale Model (6:47)
06.03.Lead Segmentation Using Decision Trees (6:53)
06.04.Excel Preparation For Analysis (6:52)
06.05.Case Study On Lead Segmentation (5:05)
06.06.Building A Model In Excel (9:38)
06.07.Interpreting Results From Tree Nodes (5:25)
06.08.Interpreting Results Based On Classification Criteria (5:23)
06.09.Drawing Inferences From Model Results (5:30)
06.10.Making Predictions Using The Trained Model (3:19)
06.11.Advanced Customization Options For Models (4:37)
07 01 Project Preview (1:05)
07.02.Market Basket Analysis For Cross-Selling Opportunities (11:01)
07.03.Predicting Values Using The Trained Model (6:27)
08 01 Project Preview (3:11)
08.02.Modeling Trends And Seasonality (10:03)
08.03.Additive And Multiplicative Time Series Models (9:30)
08.04.Linear Regression Model For Sales Forecasting (7:43)
08.05.Preprocessing Data For Regression (12:14)
08.06.Building A Linear Regression Model (8:27)
08.07.Predicting Values Using The Trained Model (8:26)
08.08.Using Xlstat For Forecasting (7:56)
09 01 Project Preview (1:52)
09.02.Building a Logistic regression model for churn prediction (12:17)
09.03.Predicting Churn Probability Using The Trained Model (11:05)
09.04.Evaluating Model Accuracy Using A Confusion Matrix (12:28)
Source Files
Introduction to Python
00. Introduction (4:42)
01.01 What Is Google Colab (4:24)
01.02 What If I Get Errors (2:40)
01.03 How Do I Terminate A Session (2:40)
02. Variables (19:17)
03. Type Conversion Examples (10:04)
04. Operators (7:04)
05. Operators Examples (21:52)
06. Collections (8:23)
07. Lists (11:38)
08. Multidimensional List Examples (8:05)
09. Tuples Examples (8:34)
10. Dictionaries Examples (14:24)
11. Ranges Examples (8:30)
12. Conditionals (6:41)
13. If Statement Examples (10:16)
14. If Statement Variants Examples (11:18)
15. Loops (7:00)
16. While Loops Examples (11:30)
17. For Loops Examples (11:18)
18. Functions (7:47)
19. Functions Examples (9:16)
20. Parameters And Return Values Examples (13:46)
21. Classes And Objects (11:13)
22. Classes Example (13:11)
23. Objects Examples (9:54)
24. Inheritance Examples (17:26)
25. Static Members Example (11:03)
26. Summary And Outro (4:06)
ChatGPT Prompts for Python Coders
Requirements
1 Introduction & Role of prompts in ChatGPT conversations (8:14)
2. Benefits of clear prompts (4:23)
3. Examples of good and bad prompts (11:18)
4. The 4-step approach to write the best prompts part 1 (6:57)
5. The 4-step approach to write the best prompts part 2 (5:37)
6. Example Python Prompts (14:40)
7. Unit Testing any Python App (20:28)
Source Code
Automate Power BI DAX and M with ChatGPT
01 Generate Employee Dataset With Chatgpt (4:50)
02 Copy Data Into Power BI And Generate A Query (10:34)
03 Calculate Employee Tenure With Power Query (10:39)
04 Filter Out Terminated Employees With Power Query (11:31)
Source
Generate queries to analyze employee performance
01 Filter By Performance Rating With Power Query (7:12)
02 Categorize Performance With Power Query (5:49)
03 Compare Employee Performance With Location And Education (14:57)
04 Find Top Performing Employees With Power Query (10:26)
05 Calculate Performance For Age Groups (5:35)
Source
Generate DAX queries with ChatGPT for Power BI
01 Generate simple DAX queries with ChatGPT for Power BI (8:02)
02 Count rows by category with DAX (11:27)
Source
Build DAX queries to generate tables with ChatGPT
01 Build Dax Queries To Generate Tables With ChatGPT (4:49)
02 Group Employees With Dax Queries (3:30)
Source
Build visualizations in Power BI with ChatGPT
01 Build Visualizations In Power BI With ChatGPT (6:58)
Source files
Anomaly Detection in Credit Card Transactions with Python
00 Project Preview - Python Data Visualization In Power BI With Chatgpt (3:54)
01 Generate Credit Card Data With Chatgpt (7:07)
02 Detect Anomalies With Z-Score In Python (18:39)
Source
Visualize data with Python in Power BI
01 Visualize Transaction Amount For Each Merchant (6:55)
02 Visualize Trend Of Transaction Amounts Over Time (18:25)
03 Show Pie Distribution Of Transaction Amounts By Category (8:48)
04 Show Histogram Distribution Of Transaction Amounts (2:11)
Source
Visualize data across categories with ChatGPT
01 Compare Amounts Across Categories With Box Plot (4:23)
02 Show Amount For Each Period By Category (7:14)
03 Visualize Transaction Amounts For Each Merchant (14:00)
04 Build A Word Cloud For Product Names (5:07)
Source
Generate machine learning models with ChatGPT
00 Project Preview - Python Machine Learning With Chatgpt (2:03)
01 What Kinds Of Machine Learning Can I Do On This Data (2:16)
02 Build A Linear Regression Model For Credit Card Dataset (8:35)
02B Visualize Linear Regression Training With Gif (10:43)
03 Logistic Regression With Confusion Matrix And Scatter Plot (14:26)
Source
Build tree machine learning models with ChatGPT
01 Build Decision Tree Model For Credit Card Dataset (8:03)
02 Build A Random Forest Model With Bar Plot (4:17)
Source
Build advanced models with ChatGPT and Python
01 Build SVM Scatter Plot With ChatGPT (21:28)
02 Build Gradient Boosting With A Bar Chart (14:22)
Source
Data Science with Python and NumPy - Introduction to Tensorflow
00. Course Intro (6:10)
01. Intro To Tensorflow (5:33)
02. Installing Tensorflow (3:52)
03. Intro To Linear Regression (9:26)
04. Linear Regression Model - Creating Dataset (5:49)
05. Linear Regression Model - Building The Model (7:22)
06. Linear Regression Model - Creating A Loss Function (5:57)
07. Linear Regression Model - Training The Model (12:43)
08. Linear Regression Model - Testing The Model (5:22)
09. Summary And Outro (2:55)
Intro to Tensorflow - Source Files
Machine Learning theory
00. Course Intro (6:05)
01. Quick Intro To Machine Learning (9:01)
02. Deep Dive Into Machine Learning (6:01)
03. Problems Solved With Machine Learning Part 1 (13:26)
04. Problems Solved With Machine Learning Part 2 (16:25)
05. Types Of Machine Learning (10:15)
06. How Machine Learning Works (11:40)
07. Common Machine Learning Structures (13:51)
08. Steps To Build A Machine Learning Program (16:34)
09. Summary And Outro (2:49)
Intro to Machine Learning Slides
Numpy
00. Course Intro (5:11)
01. Intro To Numpy (6:21)
02. Installing Numpy (3:59)
03. Creating Numpy Arrays (16:55)
04. Creating Numpy Matrices (11:57)
05. Getting And Setting Numpy Elements (16:59)
06. Arithmetic Operations On Numpy Arrays (11:56)
07. Numpy Functions Part 1 (19:13)
08. Numpy Functions Part 2 (12:36)
09. Summary And Outro (3:01)
Source Files
Review Sentiment Analysis
00. Course Intro (6:19)
01. How Machines Interpret Text (15:23)
02. Building the Model Part 1 - Examining Dataset (12:27)
03. Building the Model Part 2 - Formatting Dataset (15:14)
04. Building the Model Part 3 - Building the Model (10:30)
05. Building the Model Part 4 - Training the Model (5:42)
06. Building the Model Part 5 - Testing the Model.mp4 (9:26)
07. Course Summary and Outro (3:29)
Source Files
Learn to Graph Data with Python and Matplotlib
00. Course Intro (5:30)
01. Intro To Pyplot (5:11)
02. Installing Matplotlib (5:52)
03. Basic Line Plot (7:53)
04. Customizing Graphs (10:47)
05. Plotting Multiple Datasets (8:10)
06. Bar Chart (6:26)
07. Pie Chart (9:13)
08. Histogram (10:14)
09. 3D Plotting (6:28)
10. Course Outro (4:09)
Pyplot Code
Complete Beginners Data Analysis with Pandas and Python
00. Panda Course Introduction (5:43)
01. Intro To Pandas (7:55)
02. Installing Pandas (5:28)
03. Creating Pandas Series (20:34)
04. Date Ranges (11:29)
05. Getting Elements From Series (19:21)
06. Getting Properties Of Series (13:04)
07. Modifying Series (19:02)
08. Operations On Series (11:48)
09. Creating Pandas Dataframes (22:57)
10. Getting Elements From Dataframes (25:12)
11. Getting Properties From Dataframes (17:44)
12. Dataframe Modification (36:24)
13. Dataframe Operations (20:09)
14 Dataframe Comparisons And Iteration (15:35)
15. Reading Csvs (12:00)
16.Summary And Outro (4:14)
Source Files
Automate Excel Data Manipulation with Python and ChatGPT - 01 Handle missing data with Python and ChatGPT
01 Algorithms To Handle Missing Data (5:13)
02 Generate Excel Data With Missing Data In Python And ChatGPT (3:22)
03 Fill In Missing Excel Data With Python Imputation And ChatGPT (3:51)
04 Delete Missing Excel Data With Python And ChatGPT (5:03)
05 Fill In Missing Data With Knn Imputation (5:24)
Source
02 Categorical data manipulation with Python and ChatGPT
01 What Is Data Encoding (5:36)
02 Perform Excel Data Encoding With Python And ChatGPT (7:18)
03 Choose Data Encoding Technique (3:01)
Source
03 Statistics for data science with Python and ChatGPT
01 What Is Statistics For Data Science (3:31)
02 Levels Of Data Measurement (3:58)
03 Generate Different Types Of Data With ChatGPT (10:02)
Source
04 How to measure data
01 Measures Of Central Tendency In Data (5:00)
02 Measures Of Variability In Data (4:09)
03 What Is Skewness In Data Science (3:38)
04 Generate Skewed Datasets With ChatGPT (7:44)
05 What Are Covariance And Correlation Data Measurements (2:37)
06 Measure Covariance And Correlation Of Dataset With Chatgpt (6:50)
Source
05 Probability distribution functions in data science
01 What Are Probability Distribution Functions In Data Science (4:39)
02 Calculate Probability Distribution Functions Of A Dataset With ChatGPT (5:22)
Source
06 Normal Probability Distribution with Python and ChatGPT
01 What Is Normal Probability Distribution (4:14)
02 Calculate PDF Of Normal Distribution Dataset (5:35)
03 What Is The Central Limit Theorem (2:45)
Source
07 Binomial Probability Distribution with Python and ChatGPT
01 What Is Binomial Probability Distribution (2:52)
02 Calculate Pdf Of Binomial Distribution Dataset (10:50)
Source
08 Poisson Probability Distribution with Python and ChatGPT
01 What Is Poisson Probability Distribution (2:42)
02 Visualize Poisson Distribution With ChatGPT And Python (2:31)
Source Files
09 Uniform Probability Distribution with Python and ChatGPT
01 What Is Uniform Probability Distribution (2:36)
02 Visualize Uniform Distribution With ChatGPT And Python (3:55)
Source Files
10 Bernoulli Probability Distribution with Python and ChatGPT
01 What Is Bernoulli Probability Distribution (2:37)
02 Visualize Bernoulli Distribution With Chatgpt And Python (6:43)
Source Files
Master the API
00b-01 Openai API Models To Work With (2:53)
00b-02 How OpenAI API Works (2:09)
00b-03 Adjust OpenAI API Model Parameters (7:58)
01-01 Use OpenAI API To Answer Questions Like Chatgtp (10:19)
01-02 Correct Grammar With OpenAI API (3:30)
01-03 Summarize And Simplify Text With OpenAI API (4:03)
01-04 Translate Text With OpenAI API (3:04)
02-01 Generate Code With OpenAI API (7:11)
02-02 Explain Code With Openai Api (5:24)
02-03 Calculate Time Complexity With Openai Api (3:40)
02-04 Translate Programming Languages With OpenAI API (4:24)
02-05 Fix Bugs In Code With Openai Api (3:19)
03-01 Generate Sql Queries With Openai Py (5:15)
03-02 Build Structured Table Data From Long Form Text (4:29)
03-03 Classify Items Into Categories With Openai Api (4:50)
03-04 Generate Spreadsheets And Lists With Chatgpt Openai Api (5:46)
04-01 Convert Notes To Summary With Openai Api (5:40)
04-02 Add Emotional Sentiment To Text With Openai Models (9:40)
04-03 Generate Questions On A Topic With Gpt Turbo (9:26)
04-04 Generate Text Conversation With Chatgpt Api (5:19)
05-01 Classify Text Emotion Sentiment With Chatgpt Models (5:09)
05-02 Extract Keywords From Text With Chatgpt Api (4:31)
05-03 Convert Product Description To Ad With Chatgpt Python (3:57)
05-04 Generate Product Names With Chatgpt In Python (4:04)
05-05 Extract Information From Text With Chatgpt Api (2:57)
06-01 Build Html Parser With Python (4:31)
06-02 Scrape Hyperlinks From Url Webpage With Python (4:09)
06-03 Filter Out Urls Not Part Of Domain (7:03)
06-04 Save Web Content To Files With Python (10:07)
07-01 Convert Text To Csv With Python (6:36)
07-02 Remove Whitespace And Lines From Text With Python (4:58)
07-03 Tokenize Text With Python For Machine Learning Models (2:50)
07-04 Split Long Lines With Python (4:11)
07-05 Split Pandas Dataframe Into Sections With Python (7:19)
07-06 Embed Text For Machine Learning With Openai Api (8:05)
08-01 Embed Question With Python (5:48)
08-02 Answer Questions About Your Data With Customized Openai Model (10:36)
09-01 Load And Read Pdf In Python (3:40)
09-02 Build Vector Index From Pdf Text In Python (4:32)
09-03 Answer Questions About Pdf With Chatgpt Model In Python (5:10)
10-01 Generate Review Data With Chatgpt Api (8:14)
10-02 Format Python Text To Multidimensional Pandas Dataframe (11:50)
10-03 Change Column Data Type In Pandas Dataframe (2:40)
10-04 Embed Text Data With Openai Api (6:25)
Source files
ChatGPT 4 for Web Developers - Build an E-commerce Site with JavaScript
01. Short Demo - Introduction To The Course (2:25)
02. Project Setup (16:38)
03. Css With Chatgpt Part 1 (27:38)
04. Css With Chatgpt - Part Two (20:52)
05. Styling The Product-Info Page (24:47)
06. Links, Burger Menu And Filters (16:16)
07. Implementing The Shopping Cart - Part One (16:54)
08. Implementing The Shopping Cart Part Two (10:30)
09. Total Price And Shipping Calculations (24:13)
10. Checkout Page (18:43)
11. Styling The Site Pt1 (15:51)
12. Styling The Site Pt2 (17:25)
13. Legacy Pages (23:06)
14. Login Register Dashboard (25:55)
15. Local Storage For User Info (20:34)
Source Files
LEVEL 5 ๐ค๐ก Pass the Excel & AI Coding Interview - Excel to Python Data Science Automation
00 Course Overview - Excel To Python (7:06)
00 Project Overview - Excel Automation With Python Data Modeling (0:55)
01 Read Excel File With Python (6:43)
02 Reshape Data For Data Modeling (5:29)
03 Build A Linear Regression Model With Python (5:01)
04 Visualize Machine Learning Predictor With Python (6:22)
Source Files
Use Excel File in Python
01 Use Excel File In Python (9:56)
02 Manipulate Excel File With Python (4:30)
03 Build Dictionaries With Python (3:51)
Source Files
Manipulate Excel Sheets with Python
01 Import Data File Into A Pandas Dataframe (6:22)
02 Excel Sheet Manipulation With Python (6:01)
03 Get Excel Sheet Information With Python (4:15)
Source Files
Build Excel Filters in Python
01 Build View Excel Functions In Python (5:58)
02 Build Filter Excel Functions In Python (3:31)
03 Build Filter Functions On Blockchain Dataset (11:04)
Source Files
Aggregate Excel Data with Python
01 Aggregate Excel Data With Python (11:21)
02 Build Excel Pivot Tables In Python (5:19)
Source Files
Automate Excel Files with Python OpenPyXL
01.00 Course Overview (2:20)
01.01 Run Openpyxl On The Web (1:45)
02.01 Make A Workbook (11:01)
02.02 Save A Workbook (3:51)
02.03 Read A Workbook (8:02)
02.04 Work With Rows And Columns (8:07)
02.05 Use A Formula (8:41)
02.06 Use Dates (7:18)
02.07 Merge And Unmerge Cells (7:11)
02.08 Fold A Range (6:17)
02.09 Make A New Sheet (3:17)
02.10 Copy Data To A Sheet (4:35)
02.11 Remove A Sheet (3:45)
03.01 Build A Table (15:50)
03.02 Style A Table (8:56)
03.01 Import Dataset (4:20)
03.02 Style A Cell (6:47)
03.03 Make A Named Style (6:57)
03.04 Copy A Style (4:59)
04.01 Make A Chart (11:04)
04.02 Build Line Charts (15:30)
04.03 Build A Pie Chart (14:09)
04.04 Build A Scatter Chart (11:22)
04.05 Build An Area Chart (8:22)
05.01 Project Setup (4:30)
05.02 Expand Columns To Fit Content (6:35)
05.03 Add Dates (7:34)
05.04 Add Days Of The Week (7:11)
06.01 Read Spreadsheet Data (7:11)
06.02 Store Spreadsheet Data (3:39)
06.03 Write To A Text File (5:22)
07.01 Set Up Update Information (3:44)
07.02 Update The Spreadsheet (5:41)
08.01 Build A Stock Chart (9:14)
08.02 Build A Doughnut Chart (9:22)
08.03 Build A Bubble Chart (8:53)
09.01 Import Web Driver (8:06)
09.02 Scrape A Web Page (6:07)
09.03 Parse Page Data (9:17)
09.04 Put Data Into Excel Sheet (6:22)
09.05 Clean Data (4:38)
Source Files
Web Automation with Selenium Python
00.00 What You-ll Learn (5:43)
00.01 Install Selenium (9:12)
00.02 Download Visual Studio Code (4:10)
01.01 Find Elements By Name (14:50)
01.02 Find Elements By Id (7:34)
01.03 Find Elements By Xpath (12:29)
01.04 Find Input Field By Xpath (13:44)
01.05 Find Elements By Css Selector (9:14)
01.06 Find Elements By Link Text (7:47)
01.07 Find Elements By Partial Link Text (8:05)
01.08 Find Elements By Classname (6:22)
01.09 Find Elements By Tagname (7:29)
02.01 Automate A Google Search (19:41)
02.02 Automate Navigating A Dropdown Menu (16:22)
02.03 Automate Changing Tabs (15:41)
02.04 Automate Alert Popups (13:26)
03.01 Explicit Waits (21:04)
03.02 Implicit Waits (8:45)
04.01 Automate Window Size (12:04)
04.02 Get Title And URL (4:12)
04.03 Automate Closing Vs Quitting Windows (4:06)
05.01 Mouse Hover (14:01)
05.02 Automate Mouse Click (7:40)
05.03 Right Click (6:26)
05.04 Automate Double Click (8:36)
05.05 Click, Hold And Release (7:17)
06.01 Web Scrape Images (13:29)
06.02 Automate Downloading Images (27:34)
Source Files
The Ultimate Amazon Honeycode Guide
01 Course Overview (4:00)
02 How To Sign Up (1:21)
03 Beta (0:46)
Build Your First App
01 Project Overview (5:49)
02 Set Up Data Tables (10:26)
03 Build Your First App (12:12)
04 Customize App And Add Navigation (7:54)
05 Add Automated Notifications (9:38)
Build an App Backwards with Data
01 Project Overview (2:27)
02 Format Data (22:15)
03 Build The App (23:48)
04 Style And Customize The App (20:32)
05 Automation And Edge Cases (10:38)
Content Tracker
01 Content Tracker Overview (4:49)
02 Content Tracker Database (13:29)
Build Apps with Objects
01 Data Cell (15:34)
02 Content Box (5:25)
03 Button (9:53)
04 Blank Block (4:04)
05 Blank List (13:24)
06 Column List (7:47)
07 Stacked List (8:22)
08 Form (7:35)
09 Input Field (6:57)
10 Picklist (8:13)
11 Number (6:13)
12 Percentage (5:06)
13 Currency (3:15)
14 Contact (4:37)
15 Date (4:25)
16 Segment (3:53)
17 Screen (4:39)
Simple Survey
01 Simple Survey Overview (4:45)
02 Simple Survey Database (5:50)
Inventory Management
01 Inventory Management Overview (7:06)
02 Inventory Management Database (12:57)
To Do List
01 To Do List Overview (4:34)
02 To Do List Database (11:12)
Introduction to Blockchain (Prerequisite)
00 Blockchain Introduction (8:32)
01 What Are Blockchains And Distributed Ledgers (3:48)
02 What Are Bitcoin And Ethereum (5:28)
03 Introduction To Crypto Trading (2:44)
Python SQL Ethereum Data Science with Google BigQuery
00 Course Overview - Ethereum Sql (7:07)
01 What Are Google Cloud Platform And Bigquery (6:01)
02 Build A Project On Google Cloud Platform (4:26)
Source Files
Simple BigQuery Python SQL queries
01 Find Entries In Big Query Public Dataset (10:16)
02 Filter Entries By State Column (9:11)
Source files
Simple BigQuery Ethereum queries
01 Query Tables In Crypto Ethereum Big Query Public Dataset (4:45)
02 Select Ethereum Traces By Date (9:05)
03 Get Total Ether Supply Each Day (3:40)
04 Select Transactions By Address And Timestamp (10:13)
Source files
Calculate transaction ratios
01 Get Zero Transaction Ratio For Blockchain (10:56)
02 Get Zero Transaction Ratio For Smart Contracts (8:41)
Source files
Introduction to Machine Learning
What Is Machine Learning (5:26)
What Is Inductive Learning (4:11)
How Does A Machine Learning Agent Learn (7:38)
Types Of Machine Learning Models (12:17)
01 What Is Supervised Learning (11:04)
02 What Is Unsupervised Learning (8:17)
03 Performance Of A Machine Learning Algorithm (4:14)
04 Handle Noise In Data (5:22)
05 Powerful Tools With Machine Learning Libraries- (12:11)
Beginner Data Science and Machine Learning Bootcamp
01 Project Preview (3:29)
02 Create A Dataset (5:17)
03 Vectorize Text (16:27)
04 Build A Word Cloud (7:08)
05 Reduce Data Dimensionality With Principal Component Analysis (6:08)
06 Perform Unsupervised Classification With K-Means Clusters (17:33)
Source Files
Machine Learning Fundamentals
00 Course Overview (13:46)
01 Probability And Information Theory Overview (5:15)
02 Combinatorics For Probability (8:44)
03 Law Of Large Numbers (10:38)
04 Calculate Center Of Distribution (7:40)
05 Uniform Distribution (5:25)
06 Gaussian Distribution (3:45)
07 Log-Normal Distribution (3:28)
08 Exponential Distribution (3:04)
09 Laplace Distribution (1:54)
10 Binomial Distribution (9:05)
11 Multinomial Distribution (3:59)
12 Poisson Distribution (4:21)
13 Calculate Error Of Machine Learning Model (8:44)
Source Files
Data Engineering and Machine Learning Masterclass
00b-00 Course Overview (3:26)
03-01 Load And Clean A Public Dataset (8:55)
03-01B What Is One-Hot Encoding (10:02)
03-02 Build X And Y Data With One Hot Encoding (4:57)
03-03 Logistic Regression With One Hot Encoding (2:20)
04-04 Scale And Encode Data With Scikit-Learn (3:47)
04-04 What Is Scaling Data (6:36)
04-05 Build, Train And Test A Machine Learning Model (4:37)
05-01 Compare Decision Tree And Linear Regression Models (6:26)
05-01 What Is The Kbins Discretizer (4:54)
05-02 Bin Data With Kbins Discretizer (3:42)
05-03 Compare Binned Regression Models (3:39)
05-04 Build A Linear Regression Model On Stacked Data (3:20)
05-05A What Is K Means Clustering (11:58)
06-01 Build Univariate Nonlinear Transformatio (1:55)
06-01 What Is Gaussian Probability Distribution- (2:31)
06-01B What Is Poisson Distribution (1:08)
06-02 Build X Y Data With Poisson Distribution In Numpy (3:34)
06-02 What Is Logarithmic Data Transformation (2:34)
06-03 Build A Ridge Regression Model (3:41)
Source Files
Image recognition with MNIST
00. Course Intro (6:57)
01. Intro to Image Recognition (6:40)
02. Intro to MNIST (4:42)
03. Building a CNN Part 1 - Obtaining Data (15:40)
04. Building a CNN Part 2 - Building the Model (10:14)
05. Building a CNN Part 3 - Adding Loss and Optimizer Functions (4:57)
06. Building a CNN Part 4 - Train and Test Functions (10:58)
07. Building a CNN Part 5 - Train and Test the Model (9:17)
08. MNIST Image Recognition with Keras Sequential Model (13:24)
09. Summary and Outro (2:55)
Source Files
Build Machine Learning Models
01-01 Course Overview (3:30)
01-02 Build Models On The Web (5:06)
02-01 What Are Search Algorithms (7:21)
02-02 Depth First Search (9:00)
02-02b Build A Depth First Search Algorithm (8:26)
02-03 What Is Breadth First Search (bfs) (5:08)
02-03b Build A Breadth First Search Algorithm (6:56)
02-04 Depth Limited Search (3:58)
02-05 Iterative Deepening Depth First Search (5:32)
02-06 What Is Uniform Cost Search (6:04)
02-06b Build A Uniform Cost Search Algorithm (8:07)
02-07 Bidirectional Search (4:44)
03-01 What Are Informed Search Algorithms (4:07)
03-02 What Is Greedy Best-first Search (8:16)
03-02b Build A Greedy Best First Search Algorithm (10:43)
03-03 What Is A Search (5:10)
04-01 How Does A Machine Learning Agent Learn (7:37)
04-02 What Is Inductive Learning (4:10)
04-03 Make Decisions With Decision Trees (10:50)
04-04 Performance Of A Machine Learning Algorithm (4:13)
04-05 Handle Noise In Data (5:20)
04-06 Statistical Learning (3:56)
05-01 What Is Logistic Regression (4:26)
05-03a How To Prepare Data (8:52)
05-03 Prepare Data For Logistic Regression (12:19)
05-04a How To Build A Logistic Regression Model (3:28)
05-04 Build A Logistic Regression Model (5:29)
05-04b What Is Optimization (12:10)
05-05a How To Optimize A Logistic Regression Model (12:45)
05-05 Optimize The Logistic Regression Model (12:44)
05-06 Train The Model (10:09)
05-07 Test The Model (2:33)
05-08 Visualize Results (5:38)
06.01 What Is Gradient Boosting (1:54)
06.02 Prepare Data For Gradient Boosted Classification (7:19)
06.03 Build Binary Classes (6:12)
06.04a How To Shape Data For Classification (2:58)
06.04b Shape Data For Classification (7:06)
06.05a How To Build A Boosted Trees Classifier (4:03)
06.05b Build A Boosted Trees Classifier (4:37)
07.01 Build Input Functions (3:55)
07.02 Build A Boosted Trees Regressor (3:02)
07.03 Train And Evaluate The Model (4:07)
08.01 What You'll Learn (8:47)
08.02 What Is Supervised Learning (14:41)
08.03 Build Models On The Web (5:06)
Source Files
Data Science with Stocks, Excel and Machine Learning
00.00 Course Overview (5:43)
01.00 What You-ll Learn (2:01)
01.01 Pull In Stock Data (8:21)
01.02 Pull In More Stock Information (5:08)
01.03 Calculate Equity And Returns (11:56)
01.04 Calculate Selling Strategy (9:25)
01.05 Calculate Total Returns (4:28)
02.01 Pull Historical Stock Data (2:31)
02.02 Predict Stocks With Moving Average (9:34)
02.03 Visualize Accuracy (3:48)
02.04 What Is Exponential Smoothing (4:15)
02.05 Predict Stocks With Exponential Smoothing (7:37)
02B.00 What You-ll Learn (1:46)
02B.01 Pull Historical Stock Data (5:49)
02B.02 What Is Linear Regression (4:45)
02B.03 Linear Regression On Stock Data In Excel (8:04)
02B.04 Check Accuracy Of Linear Regression (12:53)
03.00 What You-ll Learn (2:01)
03.01 Build Models On The Web (5:05)
03.02 What Libraries Will We Use (5:56)
03B.01 Scrape Data Via API (16:42)
03B.02 Define Variables (11:37)
03B.03 Split Dataset For Training And Testing (7:33)
03B.04 Build A Linear Regression Model (9:16)
03B.05 Predict Stock Prices (10:14)
03B.06 Calculate Model Accuracy (14:17)
03B.07 Predict To Buy Or To Sell (7:23)
04.00 Recurrent Neural Networks (6:23)
04.01 Import Stock Data (9:19)
04.02 What Is Shaping Data (5:18)
04.03 Shape Training And Testing Data (12:06)
04.04 What Is Scaling Data (6:35)
04.05 Scale Data For Training (11:24)
04.06 What Is Keras (3:24)
04.07 Build A Keras Model (14:04)
04.08 Scale And Shape Data For Testing (5:33)
04.09 Test The Model (5:15)
Source Files
Ace the Python Coding Interview
01 Introduction Python (6:17)
02 Fizzbuzz Python (5:57)
Source Code
Time Complexity
00 Types Of Time Complexity Python (21:51)
01 Types Of Better Time Complexity Python (14:51)
Source Code
02 String and Array Interview Questions
01 Reverse Words In A String Python (2:44)
02 Rotate Array Python (8:56)
03 Kth Smallest Element In An Array Python (11:53)
Source Code
03 Matrix Interview Questions
01 Spiral Matrix Python (13:26)
02 Number Of Islands Python (18:54)
Source Code
04 Linked List Interview Questions
01 Inorder Traversal Python (11:08)
02 Preorder Traversal Python (8:48)
03 Postorder Traversal Python (7:05)
04 Binary Tree Maximum Path Sum Python (8:43)
Source Code
05 Binary Tree Interview Questions
01 Inorder Traversal Python (11:08)
02 Preorder Traversal Python (8:48)
03 Postorder Traversal Python (7:05)
04 Binary Tree Maximum Path Sum Python (8:43)
Source Code
06 Graph Interview Questions
01 Find Strongly Connected Components Python (10:29)
Source Code
07 Sorting Interview Questions
01 Bubble Sort Algorithm Python (9:11)
02 Selection Sort Algorithm Python (5:56)
03 Insertion Sort Algorithm Python (4:29)
04 Quicksort Algorithm Python (4:29)
05 Merge Sort Algorithm Python (7:25)
06 Time Complexity Of Different Sorting Algorithms (2:55)
Source Code
08 Dynamic Programming Interview Questions
01 Coin Change Python (7:21)
02 Edit Distance Python (11:33)
03 Distinct Subsequences Python (6:59)
04 Maximum Sum Subarray Python (4:56)
Source Code
09 Bit Manipulation Interview Questions
01 Bitwise And Shift Operators (7:02)
02 Single Number Python (4:32)
03 Number Of 1 Bits Python (4:31)
04 Sum Of Two Integers Python (5:14)
05 Bitwise And Of A Range Python (5:36)
Source Code
10 Permutations and Combinations
01 Permutations Python (10:08)
02 Distinct Permutations Of A String Python (7:49)
03 Letter Combinations Of A Phone Number Python (11:54)
Source Code
11 Math Interview Questions
01 Reverse Integer Python (9:53)
02 Palindrome Number Python (9:49)
03 Excel Sheet Column Number Python (6:04)
Source Code
Machine Learning Interview Questions
00. Course Intro (5:09)
01-00. Intro (1:54)
01-01. What is Machine Learning (17:47)
01-02. Types Of Machine Learning (10:48)
01-03. Building A Machine Learning Model (17:02)
02-00. Intro (2:44)
02-01. How To Choose An Algorithm (16:42)
02-02. Common Machine Learning Algorithms Part 1 (15:58)
02-03. Common Machine Learning Algorithms Part 2 (22:52)
02-04. Common Machine Learning Algorithms Part 3 (13:03)
02-05. Comparison Interview Questions (16:20)
03-00. Intro (2:08)
03-01. Data Related Errors (16:55)
03-02. Model Related Errors (11:34)
03-03. Results Testing Techniques (11:18)
04-00. Intro (2:14)
04-01. Missing_Corrupted Data (5:08)
04-02. Selecting Important Variables (3:18)
04-03. Fixing Multicollinearity- (3:56)
04-04. Kernel Tick (3:21)
04-05. Slow Machine_Limited Memory (4:59)
04-06. Classification and Random Sampling (3:38)
04-07. Low Training Error with High Validation Error (4:40)
04-08. Cross Validation on Time Series Data (3:38)
04-09. Amazon Recommendation System (5:26)
05. Course Summary and Outro (3:12)
Source Files
5.1 What will we learn in this section
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience