Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete Recession Proof Excel, Machine Learning, Python
00 Mammoth Interactive Courses Introduction
00 About Mammoth Interactive (1:11)
01 How to Learn Online Effectively (13:44)
Source Files
LEVEL 0 - Course Introduction
Introduction To The Complete Recession Proof Excel, Machine Learning, Python (3:34)
LEVEL 1 - Introduction to Excel - Excel to Python Data Science Automation Masterclass - Overview
00 Course Overview - Excel To Python (7:06)
Source Files - 00 Course overview - Excel to Python
Excel to Python Data Science Automation Masterclass - 01 Excel automation with Python data modeling
00 Project Overview - Excel Automation With Python Data Modeling (0:55)
01 Read Excel File With Python (6:42)
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
Excel to Python Data Science Automation Masterclass - 02 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 - Use Excel File in Python
Excel to Python Data Science Automation Masterclass - 03 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
Excel to Python Data Science Automation Masterclass - 04 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
Excel to Python Data Science Automation Masterclass - 05 Aggregate Excel Data with Python
01 Aggregate Excel Data With Python (11:21)
02 Build Excel Pivot Tables In Python (5:19)
Source Files
Excel Expense Tracker in 15 Minutes
01 Quick Win - Track Spendings And Savings In Excel (9:58)
02 Make Your Expense Tracker More Readable (5:53)
Source Files
LEVEL 2 - Excel Data Analysis - Excel Functions Mastery Course - Intro
1.1 Introduction to the Course (8:47)
1.2 Introduction of the instructor (3:30)
1.3 Course requirements (4:03)
1.4 How to get Excel (9:33)
01 Source Files
Excel Functions Mastery Course - 02. Excel Logic and Lookup Functions Projects
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)
02 Source Files
Excel Functions Mastery Course - 03. Excel Math and Finance Functions Projects
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)
03 Source Files
Excel Functions Mastery Course - 04. Excel Date and Time Functions Projects
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)
04 Source Files
Excel Functions Mastery Course - 05. Excel Text and Information Functions Projects
5.1 What will we learn in this section (1:59)
5.2 Split textual data apart (4:00)
5.3 Manipulate textual data (5:46)
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)
05 Source Files
Excel Functions Mastery Course - 06. Excel Lists
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:51)
6.6 Section Summary (6:32)
06 Source Files
Excel Functions Mastery Course - 07. Other Excel useful functions
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:18)
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)
07 Source Files
Introduction to PivotTables in Excel - Overview
1.1 Introduction To The Course (3:43)
1.2 Why Should You Learn Pivottables (3:17)
1.3 Introduction Of The Instructor (3:17)
1.4 Course Requirements (what Software, Experience) (6:10)
01 Source Files
Introduction to PivotTables in Excel - PivotTables Fundamental Projects
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:12)
2.7 Challenge (1:23)
02 Source Files
Introduction to PivotTables in Excel - Format PivotTables
3.1 What Will We Learn In This Section (1:01)
3.2 Introduction To Formatting Pivottables (3:29)
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:40)
3.6 Section Summary (2:12)
3.7 Challenge (1:04)
03 Source Files
Introduction to PivotTables in Excel - Excel Tables
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:21)
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:46)
04 Source Files
Introduction to PivotTables in Excel - Slice and Dice Your Data
5.1 What Will We Learn In This Section-1 (1:23)
5.2 What Is Slicing Data-2 (3:41)
5.3 Slicing Data Project-3 (5:40)
5.4 Data Slicer Tools-4 (14:09)
5.5 Link Slicers To Multiple Pivottables-5 (8:03)
5.6 Section Summary-6 (2:32)
5.7 Challenge-7 (2:04)
05 Source Files
Introduction to PivotTables in Excel - Connect to Databases
6.1 What Will We Learn In This Section-1 (2:30)
6.2 Connect To Databases-3 (2:06)
6.3 Import Data Sources-4 (3:58)
6.4 Use Pivottables To Refine Data-5 (4:41)
6.5 Consolidate Your Data Table-6 (3:17)
6.6 Format Large Data Sets-7 (4:51)
6.7 Slicer And Timeline In Large Data Sets-8 (4:36)
6.8 Refresh And Drill Down From Databases-9 (4:46)
6.9 Section Summary-10 (4:01)
6.10 Challenge-2 (2:01)
06 Source Files
Excel Charts and Visualization - 01. Intro to course
1.1 Introduction To The Course-1 (4:46)
1.2 Why Should You Learn About Charts And Data Visualization-2 (4:31)
1.3 Introduction Of The Instructor-3 (2:08)
1.4 Course Requirements (what Software, Experience)-4 (2:36)
Excel Charts and Visualization - 02. Charts and Basics
2.1 What Will We Learn In This Section-1 (1:21)
2.2 Main Principles And Chart Visualization Impact-2 (2:38)
2.3 Choosing The Correct Chart-3 (1:56)
2.4 Communicate With The End User-4 (2:18)
2.5 Section Summary-5 (2:59)
2.6 Challenge-6 (2:12)
Excel Charts and Visualization - 03 Excel Chart Tools
3.1 What Will We Learn In This Section-1 (1:35)
3.2 Chart Design-2 (6:38)
3.3 Working With Chart Formats-3 (4:35)
3.4 Chart Types-4 (2:08)
3.5 Primary & Secondary Axis-5 (4:20)
3.6 Chart Templates-6 (3:25)
3.7 Section Summary-7 (2:50)
3.8 Challenge-8 (1:23)
Excel Charts and Visualization - 04 Working with Basic Excel Charts & Graphs
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 1 (3:12)
4.5 Bar Charts Challenge (0:48)
4.6 Excel Line Charts-36 (3:52)
4.7 Line Charts Challenge-37 (0:48)
4.8 Excel Pie Charts-38 (5:01)
4.9 Pie Charts Challenge-39 (0:57)
4.10 Excel Area Charts-3 (2:27)
4.11 Area Charts Challenge-4 (0:50)
4.12 Excel Scatter Charts-5 (4:00)
4.13 Scatter Charts Challenge-6 (0:41)
4.14 Excel Bubble Charts-7 (5:12)
4.15 Bubble Charts Challenge-8 (0:54)
4.16 Excel Stock Charts-9 (3:07)
4.17 Stock Charts Challenge-10 (0:56)
4.18 Excel Surface Charts-11 (4:42)
4.19 Surface Charts Challenge-12 (0:43)
4.20 Excel Radar Charts-14 (2:58)
4.21 Radar Charts Challenge-15 (0:38)
4.22 Excel Treemap Charts-16 (2:31)
4.23 Treemap Charts Challenge-17 (1:03)
4.24 Excel Sunburst Charts-18 (2:36)
4.25 Sunburst Charts Challenge-19 (0:59)
4.26 Excel Histogram & Pareto Charts-20 (4:02)
4.27 Histogram & Pareto Charts Challenge-21 (1:04)
4.28 Excel Waterfall Charts-22 (5:26)
4.29 Waterfall Charts Challenge-23 (0:46)
4.30 Excel Box&whisker Charts-24 (3:24)
4.31 Box&whisker Charts Challenge-25 (1:03)
4.32 Excel Sparklines-26 (3:44)
4.33 Sparklines Challenge-27 (0:53)
4.34 Excel Color Scales-28 (3:42)
4.35 Color Scales Challenge-29 (0:49)
4.36 Excel 3D Map (4:35)
4.37 3D Map Challenge (1:45)
4.38 Section Summary (10:13)
04 Source Files
Excel Charts and Visualization - 05. Excel Advanced Data Visualization
5.1 What Will We Learn In This Section-1 (2:23)
5.2 Data Visualization With Pivot Chart And Slicers-7 (7:04)
5.3 Challenge Data Visualization With Pivot Chart And Slicers-8 (1:34)
5.4 Create Break Even Chart-9 (9:24)
5.5 Challenge Break Even Chart-10 (1:11)
5.6 Rating Star Chart-11 (7:09)
5.7 Challenge Star Rating-12 (1:28)
5.8 Drop Down Menu For Chart-13 (16:30)
5.9 Challenge Drop Down Menu Chart-14 (1:20)
5.10 Risk Score Chart-2 (11:03)
5.11 Challenge Risk Score Chart-3 (1:22)
5.12 Dynamic Chart Update (8:10)
5.13 Challenge Dynamic Chart Update (1:47)
5.14 Section Summary (6:48)
6.1 Course Summary And Next Steps (16:29)
Excel Financial Analysis - 01. Introduction to the Course
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)
Excel Financial Analysis - 02. Excel Statement Models
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:04)
2.10 Challenge (1:35)
Excel Financial Analysis - 03. Excel Finance Methods
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 Accounts receivable 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)
Data Visualization - 01. Introduction to the Course
1.1 Introduction To The Course-1 (8:27)
1.2 Introduction Of The Instructor-2 (3:11)
1.3 Course Requirements-3 (2:59)
1.4 How To Get Excel-4 (4:13)
Source files
Data Visualization - 02. Dashboards Introduction
2.1 What Will We Learn In This Section-1 (1:20)
2.2 What Are Dashboards-2 (5:39)
2.3 Answers You Need Before You Start A Dashboard-3 (7:45)
2.4 Best Practices For Dashboard Layout-4 (4:42)
2.5 Best Practices For Dashboard Colors-5 (3:54)
2.6 Section Summary-6 (3:40)
Source Code
Data Visualization - 03. Build a Dashboard Project
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)
Source Code
Data Visualization - 04. Scrolling Data Table
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:40)
4.5 Conditionally Format Actual Values vs Budgeted Values (10:52)
4.6 Conditional Headers (9:25)
4.7 Section Summary (3:01)
Source Code
Data Visualization - 05. Show Top Indicators
5.1 What will we learn in this section (1:50)
5.2 Show Top Matches Over and Under Budget (9:20)
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)
Source Code
Data Visualization - 06. Scrollable Line Chart
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:12)
6.5 Toggle Visibility of Line Series (9:56)
6.6 Finetune the Line Series (7:08)
6.7 Section Summary (5:34)
Source Code
Data Visualization - 07. Interactivity
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)
Source Code
Data Visualization - 08. Finetune the Dashboard
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)
Source Code
9.1 Course Summary and Next Steps (10:27)
LEVEL 3 - Power BI and Power Query - Beginners Excel Power Query and M Masterclass - 01 Course Overview
01 What Are Power Query And M (8:16)
02 Course Overview (6:16)
Source Files
Beginners Excel Power Query and M Masterclass - 02 Build your first M queries
01 Capitalize A Table Column (6:39)
02 Build An Expression With Let (17:09)
Source Files
Beginners Excel Power Query and M Masterclass - 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
Beginners Excel Power Query and M Masterclass - 04 Build M functions to perform tasks
01 Build M Functions To Perform Tasks (8:13)
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 1 (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
Beginners Excel Power Query and M Masterclass - 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:17)
04 Iterate Over A List With Recursion (3:26)
Source Files
Beginners Excel Power Query and M Masterclass - 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)
Source Files
Beginners Excel Power Query and M Masterclass - 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)
Source Files
Beginners Excel Power Query and M Masterclass - 08 Work with tables in M
01 Build Tables (6:55)
02 Work With Tables (5:37)
03 Fill In A Table (3:27)
Source Files
Beginners Excel Power Query and M Masterclass - 09 Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Source Files
Beginners Excel Power Query and M Masterclass - 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)
Source Files
Beginners Excel Power Query and M Masterclass - 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
Beginners Excel Power Query and M Masterclass - 12 Build calculations for tables with M
01 Build Address Labels (8:26)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Source Files
Beginners Excel Power Query and M Masterclass - 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)
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
Advanced Excel Power Query and M Masterclass - 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
Advanced Excel Power Query and M Masterclass - 02 Build expressions with each
01 Work With The Each Keyword (5:00)
02 Generate A List (5:40)
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
Advanced Excel Power Query and M Masterclass - 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:37)
Build M functions to perform tasks - Source Files
Advanced Excel Power Query and M Masterclass - 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:48)
07 Fill A Table With Random Values (7:12)
Work with tables in M - Source Files
Advanced Excel Power Query and M Masterclass - 05 Pivot a table
00 What Is Pivoting (1:28)
01 Pivot A Table (12:05)
Pivot a table - Source Files
Advanced Excel Power Query and M Masterclass - 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
Advanced Excel Power Query and M Masterclass - 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
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 01. Introduction To The Course
1.1 Introduction To Power BI (7:08)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 02. Get Started in Power BI
2.1 Installing Power BI (5:10)
2.2 Getting Started With PowerbI (16:17)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 03. Get Started in the Power Query Editor
3.1 Power Query Editor (8:53)
3.2 Getting Started With Power Query Editor (24:18)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 04. Work with Data in Power Query
4.1 Working With Data In Power Query (16:29)
4.2 Working With Data In Power Query (19:08)
4.3 Working With Data In Power Query Editor (13:32)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 05. Build Tables
5.1 Fact And Dimension Table (14:48)
5.2 Building Tables (7:41)
5.3 Date Dim Extract And Transform (8:42)
5.4 Extract Functionalities (6:05)
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 06. Analyze Data With Dax In Power BI
6.1 Data Analysis Expression Dax In Power BI (7:04)
6.2 Working With Data Analysis Expression DAX (12:16)
6.3 Measures Filters (10:00)
6.4 Measures All (6:06)
6.5 Iterators (6:30)
6.6 Iterators2 (7:36)
6.7 Iterators3 (8:27)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 07. Work with DAX Functions and Operators
7.1 Time Intelligence DAX (9:04)
7.2 Time Intelligence Functions (8:33)
7.3 Demo And Examples (9:25)
7.4 Date Table (4:31)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 08. Artificial Intelligence With Power BI
8.1 AI With PowerBI-1 (21:43)
8.2 AI With PowerBI-2 (19:27)
8.3 AI With PowerBI-3 (22:12)
Source Files
LEVEL 4 - Excel Automation Programming - Beginners Excel VBA - 01-02 Course Introduction
01.00 Course Overview (2:24)
01.01 How To Save Macros (1:34)
01-02 Source Files
Beginners Excel VBA - 03 Send Messages with MsgBox
03.00 Topics Overview (0:53)
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:29)
03 Source Files
Beginners Excel VBA - 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:19)
04.07 Build A Sales Calculator (11:53)
04.08 Change Charts (10:30)
04 Source Files
Beginners Excel VBA - 05 Work with the Range Object
05 Source Files
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)
Beginners Excel VBA - 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
Beginners Excel VBA - 07 More Range Projects
07.00 Topics Overview (1:21)
07.01 Union And Intersect Of Ranges (4:24)
07.02 Detect Content (5:37)
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
Beginners Excel VBA - 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
Beginners Excel VBA - 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
Beginners Excel VBA - 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:36)
10.03 Logical Operator NOT (3:15)
10 Source Files
Beginners Excel VBA - 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
Intermediate Excel VBA - Overview & Introduction to Loops
12.00.00 Course Overview (2:50)
12.00 Topics Overview (0:57)
12.01 Single Loop (5:59)
12.02 Double Loop (5:14)
12.03 Triple Loop (6:24)
12.04 Do While Loop (5:34)
12.05 Build A Commission Table (5:33)
12 Source Files
Intermediate Excel VBA - 13 Loop Projects
13.00 Topics Overview (1:40)
13.01 Loop Through Defined Range (3:37)
13.02 Loop Through Entire Column (3:29)
13.03 Do Until Loop (3:22)
13.04 Use Step To Increment (4:22)
13.05 Build A Pattern Project (4:49)
13.06 How To Sort (5:32)
13.07 Sort By Related Data (8:15)
13.08 Delete Duplicate Values (6:10)
Source Files
Intermediate Excel VBA - 14 String Manipulation
14.00 Topics Overview (1:28)
14.01 Join Strings (3:13)
14.02 Extract Substrings From Left Or Right (3:07)
14.03 Extract Substring At Middle (4:12)
14.04 Get Length Of A String (2:40)
14.05 Get Substring Position (3:16)
14.06 How To Split Strings (4:56)
14.07 Reverse Characters (4:10)
14.08 Change String Casing (3:28)
14.09 Count Words In A Range (8:17)
Source Files
Intermediate Excel VBA - 15 Build Custom Functions
15.00 Topics Overview (1:19)
15.01 Make And Use Your Own Function (6:33)
15.02 Pass Arguments To A Function (7:43)
15.03 Custom Calculator Function (6:22)
Source Files
Intermediate Excel VBA - 16 Build Arrays
16 Source Files
16.00 Topics Overview (1:18)
16.01 One Dimensional Array (5:46)
16.02 Two Dimensional Array (6:26)
16.03 Change Array Size (4:54)
16.04 Build An Array (5:09)
16.05 Populate Row With Array (3:21)
16.06 Array Length (6:47)
16.07 Split String Into An Array (4:28)
16.08 Join Array Into A String (3:49)
Intermediate Excel VBA - 17 Work with Dates
17.00 Topics Overview (1:12)
17.01 Delay A Procedure (4:12)
17.02 Schedule A Procedure (4:18)
17.03 Count Years (5:20)
17.04 Count Days Between Dates (2:41)
17.05 Count Weekdays Between Dates (4:51)
17.06 Sort Dates (6:27)
17 Source Files
Intermediate Excel VBA - 18 Application Object
18 Source Files
18.00 Topics Overview (1:36)
18.01 How To Access Excel Functions (4:28)
18.02 Disable Screen Updating (3:19)
18.03 Disable Alerts (3:38)
18.04 Show Progress Of Macro (6:35)
18.05 Read Data From A File (6:35)
18.06 Write Data To A File (5:10)
Intermediate Excel VBA - 19 VBA Projects
19.00 Topics Overview (0:52)
19.01 Build A Table (4:47)
19.02 Build A Table Of Contents (11:47)
19.03 Build A Table Of Contents 2 (4:42)
19.04 Combine Worksheets (17:42)
19.05 Combine Worksheets By Column (15:48)
19 Source Files
Intermediate Excel VBA - 20 Programming Charts
20.00 Topics Overview (1:20)
20.01 Program A Chart (6:12)
20.02 Program An Embedded Chart (4:59)
20.03 Delete Charts Programatically (2:19)
20 Source Files
Python Language Fundamentals
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)
Source Files
Automate Excel Files with Python OpenPyXL - 01 Introduction to the Course
01.00 Course Overview (2:20)
01.01 Run Openpyxl on the Web (1:45)
Source Files
Automate Excel Files with Python OpenPyXL - 02 Use OpenPyXL and Sheets
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)
02 Source Files
Automate Excel Files with Python OpenPyXL - 03.01 Worksheet Tables
03.01 Build a Table (15:50)
03.02 Style a Table (8:55)
Source Files
Automate Excel Files with Python OpenPyXL - 03.02 Format Cells
03.01 Import Dataset (4:19)
03.02 Style a Cell (6:47)
03.03 Make a Named Style (6:57)
03.04 Copy a Style (4:59)
Source Files
Automate Excel Files with Python OpenPyXL - 04 Build 2D Charts
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:21)
04 Source Files
Automate Excel Files with Python OpenPyXL - 05 Project_ Employee Timelog
05.01 Project Setup (4:29)
05.02 Expand Columns to Fit Content (6:35)
05.03 Add Dates (7:34)
05.04 Add Days of the Week (7:11)
05 Source Files
Automate Excel Files with Python OpenPyXL - 06 Write to a Text File
06.01 Read Spreadsheet Data (7:11)
06.02 Store Spreadsheet Data (3:39)
06.03 Write to a Text File (5:22)
06 Source Files
Automate Excel Files with Python OpenPyXL - 07 Update a Spreadsheet
07.01 Set Up Update Information (3:44)
07.02 Update the Spreadsheet (5:41)
07 Source Files
Automate Excel Files with Python OpenPyXL - 08 More Chart Types
08.01 Build a Stock Chart (9:13)
08.02 Build a Doughnut Chart (9:22)
08.03 Build a Bubble Chart (8:53)
08 Source Files
Automate Excel Files with Python OpenPyXL - 09 Web Scraping
09.01 Import Web Driver (8:06)
09.02 Scrape a Web Page (6:06)
09.03 Parse Page Data (9:17)
09.04 Put Data into Excel Sheet (6:22)
09.05 Clean Data (4:38)
09 Source Files
Web Automation with Selenium Python - 00 Getting Started with Selenium
00.00 What You'll Learn (5:42)
00.01 Install Selenium (9:11)
00.02 Download Visual Studio Code (4:10)
00 Source Files
Web Automation with Selenium Python - 01 Automate Finding Elements
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)
01 Source Files
Web Automation with Selenium Python - 02 Beginner's Automation with Selenium
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)
02 Source Files
Web Automation with Selenium Python - 03 Avoid Errors with Waits
03.01 Explicit Waits (21:03)
03.02 Implicit Waits (8:45)
03 Source Files
Web Automation with Selenium Python - 04 Automate Browsers Commands
04.01 Automate Window Size (12:04)
04.02 Get Title And URL (4:12)
04.03 Automate Closing Vs Quitting Windows (4:06)
04 Source Files
Web Automation with Selenium Python - 05 Automate Mouse Actions
05.01 Mouse Hover (14:01)
05.02 Automate Mouse Click (7:39)
05.03 Right Click (6:26)
05.04 Automate Double Click (8:36)
05.05 Click, Hold And Release (7:17)
05 Source Files
Web Automation with Selenium Python - 06 Automate Images
06.01 Web Scrape Images (13:29)
06.02 Automate Downloading Images (27:34)
06 Source Files
The Ultimate Amazon Honeycode Guide - 01 Introduction to Course
01 Course Overview (4:00)
02 How To Sign Up (1:21)
03 Beta (0:46)
The Ultimate Amazon Honeycode Guide - 02 Build Your First App
01 Project Overview (5:48)
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)
The Ultimate Amazon Honeycode Guide - 03 Build an App Backwards with Data
01 Project Overview (2:27)
02 Format Data (22:14)
03 Build The App (23:48)
04 Style And Customize The App (20:31)
05 Automation And Edge Cases (10:38)
The Ultimate Amazon Honeycode Guide - 04 Content Tracker
01 Content Tracker Overview (4:49)
02 Content Tracker Database (13:29)
The Ultimate Amazon Honeycode Guide - 05 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:21)
08 Form (7:35)
09 Input Field (6:57)
10 Picklist (8:12)
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)
The Ultimate Amazon Honeycode Guide - 06 Simple Survey
01 Simple Survey Overview (4:45)
02 Simple Survey Database (5:50)
The Ultimate Amazon Honeycode Guide - 07 Inventory Management
01 Inventory Management Overview (7:06)
02 Inventory Management Database (12:57)
The Ultimate Amazon Honeycode Guide - 08 To Do List
01 To Do List Overview (4:34)
02 To Do List Database (11:12)
LEVEL 5 - Blockchain Cryptocurrency and Machine Learning - Truffle Fullstack dApp Development with React, Solidity and JavaScript
00 Course Overview - Truffle Fullstack Dapp Development (6:02)
Source Files
Truffle Fullstack dApp Development with React, Solidity and JavaScript - 01a 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)
Truffle Fullstack dApp Development with React, Solidity and JavaScript - 01b (Prerequisite) Introduction to Solidity
01 Introduction To Ethereum Remix IDE (8:12)
01b (Prerequisite) Introduction to Solidity - 02 Build Your First Solidity Smart Contract
01 Build Your First Contract-1 (8:48)
02 Change A State Variable Value-2 (5:55)
Source Files
01b (Prerequisite) Introduction to Solidity - 03 Build Solidity Variables
01 Build A Local Variable-1 (4:28)
02 Build State Variables Of Different Data Types-2 (10:54)
03 Build A Custom Data Type With A Struct-3 (4:47)
Source Files
01b (Prerequisite) Introduction to Solidity - 04 Build Solidity Arrays
01 Build Arrays-1 (11:07)
02 Build Array Functions-2 (6:17)
Source Files
01b (Prerequisite) Introduction to Solidity - 05 Build Solidity Mappings
01 Build A Mapping-1 (6:20)
02 Build A Database-Like Mapping-2 (7:42)
03 Assign Ownership To Individual Ethereum Addresses-3 (4:59)
Source Files
01b (Prerequisite) Introduction to Solidity - 06 Build Solidity Conditionals and Loops
01 Build A Conditional-1 (6:57)
02 Build A Loop-2 (9:25)
Source Files
01b (Prerequisite) Introduction to Solidity - 07 Send Ether
01 Send Ether-1 (8:31)
Source Files
01b (Prerequisite) Introduction to Solidity - 08 Build Smart Contracts
00 Build A Profit Splitter Contract-1 (11:48)
01 Build A Contract With Limited Addresses-2 (11:40)
02 Build A Contract And Library-3 (15:01)
03 Build A Contract With A Limited Time Transaction-4 (10:20)
04 Build Contracts With Inheritance-5 (13:22)
05 Build Contracts With Visibility Modifiers-6 (10:50)
06 Build A Contract With Mutability Modifiers-7 (10:20)
07 Build An Abstract Contract-8 (13:09)
08 Build A Bank Contract-9 (9:25)
09 Access Struct Value-10 (4:13)
Source Files
01c (Prerequisite) Command Line Fundamentals - 01 Course Overview
01 Why All Developers Need To Know The Command Line (8:50)
03 What Are Linux And Unix Terminals (8:04)
01c (Prerequisite) Command Line Fundamentals - 02 What you'll need
01 What You'll Need (1:20)
02 Install Linux Command Line On Windows (3:18)
01c (Prerequisite) Command Line Fundamentals - 03 Use Commands in a Linux Unix Terminal
01 Build Your First Command In The Command Line (3:48)
02 Navigate Directories In The Command Line (6:33)
03 Build And Edit A New File In The Command Line (7:27)
04 Move Files In The Command Line (9:00)
01d (Prerequisite) Install Node and NPM
00 What Is Node Js-1 (8:22)
01 Install Node And Npm On Mac Or Windows-2 (3:14)
02 How To Install Node And Npm On Windows (8:41)
Source files
Truffle Fullstack dApp Development - 02 Build blockchain backend for social media smart contracts
00 What Is Truffle Ethereum (1:29)
01 Start A Social Media Dapp (6:13)
02 Build Social Media Smart contract (9:19)
Lecture 01 Source Files
Lecture 02 Source Files
Truffle Fullstack dApp Development - 04 Deploy social media smart contract to blockchain
00 What Is Ganache (1:41)
Source Files
Truffle Fullstack dApp Development - 05a (Prerequisite) Introduction to HTML
01. Course Requirements (2:55)
02. What Is Jsbin (3:15)
03. Setting Up The Html Document (2:41)
04. Header Tags And Paragraphs Tags (4:06)
05. Styles (3:32)
06. Bold Underline And Italic Tags (3:10)
07. Adding In A Link (1:38)
08. Adding In A Image (3:00)
09. Adding A Link To An Image (1:54)
10. Lists (4:03)
11. Tables (3:29)
12. Different Kinds Of Input (4:59)
13. Adding In A Submit Button (3:01)
Truffle Fullstack dApp Development - 05b (Prerequisite) Introduction to JavaScript
01. Variables (5:36)
02. JavaScript (10:24)
03. Numbers (4:52)
04. Booleans (5:22)
05. If Statements (4:27)
06. Arrays (8:31)
07. For Loops (9:16)
08. While Loops (4:33)
09. Objects (8:02)
10. Functions (6:09)
11. Foreach (3:54)
12. Map Functions (5:22)
13. Using Objects As Dictionary (2:45)
14. Switch Statements (6:38)
15. Destructuring-1 (5:30)
16. Spread Operator-1 (6:56)
17. String Templates-1 (6:37)
18. Error Handling-1 (5:45)
19. Let And Const Keywords-1 (3:39)
20. Do-while-1 (1:45)
21. Sets-1 (5:42)
22. Maps-1 (4:39)
23. Stacks-1 (6:06)
24. Queues-1 (11:49)
25. For Loop (5:11)
26. Recursive Functions-1 (7:13)
27. Loop Labeling-1 (5:18)
28. 2d Arrays-1 (21:59)
29. Settimeout-1 (7:02)
30. Sentimental-1 (11:21)
31. Functions With Optional Parameters-1 (15:10)
32. Basic Regular Expression-1 (5:53)
33. Handle Keypress Events-1 (22:45)
34. Priority Queue-1 (15:54)
35. Add and delete Object Property-1 (2:44)
37. Concat-1 (3:12)
38. Flat And Flatmap-1 (2:06)
Truffle Fullstack dApp Development - 06 (Prerequisite) Introduction to React
00 Why You Should Learn React (5:30)
01 React Introduction (12:32)
02 Set up a Container (8:13)
03 Generate a List (6:46)
04 Add Items to the List (6:34)
05 Clear Input Field (10:26)
06 Remove a Task (10:39)
Source Files
Truffle Fullstack dApp Development - 06b Web3 and MetaMask Introduction
01 What Is Web3js (2:06)
02 Install Metamask (2:14)
Truffle Fullstack dApp Development - 07 Connect to smart contract in app with Web3
01 Load Web3 And Smart Contract In Javascript Frontend (11:46)
02 Launch React Dapp With Ganache And Metamask (5:45)
Lecture 01 Source Files
Lecture 02 Source Files
Truffle Fullstack dApp Development - 08 Build Add Social Media Post component
01 Build Add Social Media Post Component (5:18)
02 Use Addpost React Component In App (10:01)
Source files
Truffle Fullstack dApp Development - 09 Build posts and likes components
01 Build Social Media Posts Component (10:30)
02 Enable Likes In Social Media Dapp (9:47)
Source files
Blockchain and Cryptocurrency Machine Learning - 00a Course Overview
00 Course Overview - Blockchain Machine Learning (9:14)
Source Files
Blockchain and Cryptocurrency Machine Learning - 00b What is Blockchain
00 How Blockchain Was Invented (7:26)
01 Blockchain Introduction (8:32)
02 What Is Bitcoin Mining (5:11)
Source Files
Blockchain and Cryptocurrency Machine Learning - 01 What is Machine Learning
01 What Is Machine Learning (5:26)
02 What Is Supervised Learning (10:39)
Blockchain and Cryptocurrency Machine Learning - 03 Regression Machine Learning with Blockchain API
00A Project Preview (2:12)
00B What Is Linear Regression (5:03)
01 Collect Data From Blockchain Api (12:57)
02 Join CSV Files With Blockchain Data (9:01)
03 Process Data (4:06)
04 Visualize Data (11:19)
05 Create X And Y (6:15)
06 Build A Linear Regression Model (4:59)
07 Build A Polynomial Regression Model (5:53)
Source Files
Blockchain and Cryptocurrency Machine Learning - 04 Clustering Machine Learning on Cryptocurrencies
00A Project Preview (3:02)
00B What Is Unsupervised Learning (8:17)
01 Collect Crypto Data With Cryptocompare API (9:35)
02 Clean Data (8:10)
03 Process Text Features (7:26)
04A What Is Principal Component Analysis (7:27)
04B Reduce Data Dimensionality With Principal Component Analysis (4:41)
05A What Is K Means Clustering (11:58)
05B Cluster Cryptocurrencies With K-Means Clustering (7:41)
06 Machine Learning With Optimal Number Of Clusters (4:48)
07 Visualize Clusters (5:25)
Source Files
Blockchain and Cryptocurrency Machine Learning - 05a Build a K Nearest Neighbors Model
01 What Is K Nearest Neighbours (8:07)
02 Scrape Crypto Data With Yahoo Finance API (7:58)
03 Process Data (15:33)
04 Build A K-Nearest Neighbors Classifier (10:08)
05 Calculate Error For Different K Values (6:38)
Source Files
Blockchain and Cryptocurrency Machine Learning - 05b Build a Radius Neighbors Regression Model
00 What Is Radius Neighbors Machine Learning (5:03)
01 Load Stock Data With Yahoo Finance API (6:59)
02 Build X And Y Training And Testing Data (5:11)
03 Build A Radius Neighbors Regression Model (7:30)
Source Files
Blockchain and Cryptocurrency Machine Learning - 06a Build a CatBoost Model
00 What Is Catboost Machine Learning (2:26)
00B What Is Gradient Boosting (8:38)
01 Load Data (4:51)
02 Process Data (10:53)
03 Build A Catboost Classifier Model (7:31)
Source Files
Blockchain and Cryptocurrency Machine Learning - 06b Build an XGBoost Regression Model
00 What Is XGboost Machine Learning (1:31)
01 Load Stock Data With Yahoo Finance API (4:35)
02 Build An XGboost Regression Model (7:27)
Source Files
Blockchain and Cryptocurrency Machine Learning - 07a Neural Network Fundamentals
01 What Is Deep Learning (7:42)
02 What Is A Neural Network (8:47)
Blockchain and Cryptocurrency Machine Learning - 07b Build a Neural Network Classifier
01 Load Stock Data With Yahoo Finance API (7:20)
02 Build X And Y Training And Testing Data (6:13)
03 Build A Neural Network Classifier (6:29)
04 Calculate Neural Network Accuracy From Confusion Matrix (9:30)
Source Files
Blockchain and Cryptocurrency Machine Learning - 07c Build a Recurrent Neural Network with TensorFlow
00A Project Preview (2:12)
00B What Is A Recurrent Neural Network (6:38)
01 Load Stock Data With Yahoo Finance API (7:20)
02 Visualize Data (8:27)
03 Build A Training Dataset (8:04)
04 Build Features And Labels (10:37)
05 Build A Tensorflow Lstm Neural Network (12:04)
06 Load Test Data With An API (7:32)
07 Build Features And Labels For Testing The Neural Network (10:42)
08 Visualize Model's Predictions (8:42)
Source Files
Blockchain and Cryptocurrency Machine Learning - 08 Build a Bagging Classifier Model
00A Bagging And Decision Trees Introduction (5:25)
00B How Bagging Works (7:11)
01 Load Stock Data With Yahoo Finance API (8:34)
02 Build X And Y Training And Testing Data (6:00)
03 Train And Test A Bagging Classifier (7:34)
Source Files
Blockchain and Cryptocurrency Machine Learning - 09 Build a Light Gradient Boosted Regression Ensemble
00A Gradient Boosting Introduction (8:40)
00B What Is A Light Gradient Boosted Regression Ensemble (5:08)
01 Load Stock Data With Yahoo Finance API (5:08)
02 Build A Light GBM (7:59)
03 Find Best Number Of Trees (8:46)
04 Find Best Tree Depth (5:23)
Source Files
Blockchain and Cryptocurrency Machine Learning - 10 Build a Nested Cross Validation Model
00 What Is Nested Cross Validation (14:29)
01 Load Stock Data With Yahoo Finance Api (3:01)
02 Build More Features (6:32)
03 Define X And Y (5:55)
04 Implement Cross Validated Grid Search (6:02)
Source Files
Blockchain and Cryptocurrency Machine Learning - 11 Differential Privacy Project
00 What Is Differential Privacy (7:18)
01 Differential Privacy Project Introduction (13:16)
02 Build An Initial Database (3:05)
03 Build A Parallel Database (4:04)
04 Build Multiple Parallel Databases (3:09)
05 Determine If Query Leaks Private Data (5:12)
06 Calculate Sensitivity Of Mean Query (6:29)
07 Build Local Differential Privacy (9:09)
Source Files
Blockchain and Cryptocurrency Machine Learning - 12 Deep Learning Differential Privacy Project
00 Deep Learning Differential Privacy Introduction (13:22)
01 Build Database (3:45)
02 Build A Differential Privacy Query (4:10)
03 Perform Pate Analysis (6:10)
Source Files
Blockchain and Cryptocurrency Machine Learning - 13 Build a Federated Learning Model
00 What Is Federated Learning (6:28)
01 Generate A Dataset (10:03)
02 Build A Regular Model (7:43)
03 Visualize Model Results (7:01)
04 Build A Client-Side Model (2:51)
05 Build An Aggregator Model (2:07)
06 Generate Clients Dataset (9:26)
07 Execute The Federated Learning Model (9:58)
08 Evaluate The Model (3:36)
Source Files
LEVEL 6 - Data Science and Machine Learning - Python SQL Ethereum Data Science with Google BigQuery - Overview
Machine Learning Fundamentals (13:46)
Ethereum SQL (7:07)
Source Files
Python SQL Ethereum Data Science with Google BigQuery - 01 Google Cloud Platform and BigQuery
01 What Are Google Cloud Platform And Bigquery (6:01)
02 Build A Project On Google Cloud Platform (4:26)
Python SQL Ethereum Data Science with Google BigQuery - 02 SQL Introduction (Prerequisite)
01 Why You Must Know How To Work With Data-1 (5:22)
Source Files
02 SQL Introduction (Prerequisite) - 02 Entity Relationship Modeling (ERM)
01 How To Read An Er Model-1 (5:32)
Source Files
02 SQL Introduction (Prerequisite) - 03 Introduction to databases and relational databases
01 What Is A Database-1 (8:26)
02 What Is A Relational Database-2 (4:33)
Source Files
02 SQL Introduction (Prerequisite) - 04 How to build an organized database
01 How To Design Columns And Data Types-1 (3:13)
02 Use Normal Forms To Check Your Design-2 (7:16)
Source files
02 SQL Introduction (Prerequisite) - 05 Build a SQLite database with Python
01 Build A Sqlite Database With Python-1 (8:02)
02 Add An Entry To The Table With Sql-2 (6:44)
03 Add More Records To The Table-3 (6:30)
04 Build A Second Table For Cross-Referencing-4 (10:57)
05 Select Rows That Meet Conditions-5 (7:15)
Source files
Python SQL Ethereum Data Science with Google BigQuery - 05 Simple BigQuery Python SQL queries
01 Find Entries In Big Query Public Dataset (10:16)
02 Filter Entries By State Column (9:11)
Python SQL Ethereum Data Science with Google BigQuery - 06 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)
Python SQL Ethereum Data Science with Google BigQuery - 07 Calculate transaction ratios
01 Get Zero Transaction Ratio For Blockchain (10:56)
02 Get Zero Transaction Ratio For Smart Contracts (8:41)
Machine Learning Fundamentals - Overview
00 Course Overview - Machine Learning Fundamentals (13:46)
Source Files
Machine Learning Fundamentals - 01 (Prerequisite) Introduction to Machine Learning
00 Types Of Machine Learning Models (12:17)
01 How Does A Machine Learning Agent Learn (7:38)
02 What Is Inductive Learning (4:11)
Machine Learning Fundamentals - 02 (Prerequisite) Introduction to Python
00. Introduction (4:42)
01 What is Google Colab (4:24)
02 What If I Get Errors (2:39)
03 How Do I Terminate a Session (2:40)
Machine Learning Fundamentals - 03 Probability and Statistics for Machine Learning
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)
Source Files
Machine Learning Fundamentals - 04 Distributions in Machine Learning
01 Uniform Distribution (5:25)
02 Gaussian Distribution (3:45)
03 Log-Normal Distribution (3:27)
04 Exponential Distribution (3:04)
05 Laplace Distribution (1:54)
06 Binomial Distribution (9:05)
07 Multinomial Distribution (3:59)
08 Poisson Distribution (4:21)
Source Files
Machine Learning Fundamentals - 05 Machine Learning Optimization
01 Calculate Error Of Machine Learning Model (8:44)
Source Files
Data Engineering and Machine Learning Masterclass - Overview
00 Course Overview (3:26)
Source Files - Course Overview
Data Engineering and Machine Learning Masterclass - More About Machine Learning
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)
Data Engineering and Machine Learning Masterclass - 03 Load, clean and encode data
01 Load And Clean A Public Dataset (8:55)
01B What Is One-Hot Encoding (10:02)
02 Build X And Y Data With One Hot Encoding (4:57)
03 Logistic Regression With One Hot Encoding (2:20)
Data Engineering and Machine Learning Masterclass - 04 Data engineering for machine learning
04 Scale And Encode Data With Scikit-Learn (3:47)
04.04 What Is Scaling Data (6:36)
05 Build, Train And Test A Machine Learning Model (4:37)
Data Engineering and Machine Learning Masterclass - 05 Build regression and discretizer models
01 Compare Decision Tree And Linear Regression Models (6:26)
01C What Is The Kbins Discretizer (4:54)
02 Bin Data With Kbins Discretizer (3:42)
03 Compare Binned Regression Models (3:39)
04 Build A Linear Regression Model On Stacked Data (3:20)
05A What Is K Means Clustering (11:58)
Data Engineering and Machine Learning Masterclass - 06 Data transformation and feature selection for ridge regression
01 Build Univariate Nonlinear Transformatio (1:55)
01 What Is Gaussian Probability Distribution- (2:31)
01B What Is Poisson Distribution (1:08)
02 Build X and Y Data With Poisson Distribution In Numpy (3:34)
02C What Is Logarithmic Data Transformation (2:34)
03 Build A Ridge Regression Model (3:41)
Data Science with Stocks, Excel and Machine Learning - 00 Welcome to the Course
00.00 Course Overview-1 (5:43)
00 Source Files
Data Science with Stocks, Excel and Machine Learning - 01 Project Track Stocks in Excel
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)
01 Source Files
Data Science with Stocks, Excel and Machine Learning - 02A Other Techniques of Stock Prediction in Excel
02.01 Pull Historical Stock Data-1 (2:31)
02.02 Predict Stocks With Moving Average-2 (9:34)
02.03 Visualize Accuracy-3 (3:48)
02.04 What Is Exponential Smoothing-4 (4:15)
02.05 Predict Stocks With Exponential Smoothing-5 (7:37)
02 Source Files
Data Science with Stocks, Excel and Machine Learning - 02B Linear Regression on Stock Data in Excel
02.00 What You'll Learn-1 (1:46)
02.01 Pull Historical Stock Data-2 (5:49)
02.02 What Is Linear Regression-3 (4:45)
02.03 Linear Regression On Stock Data In Excel-4 (8:04)
02.04 Check Accuracy Of Linear Regression (12:53)
02b Source Files
Data Science with Stocks, Excel and Machine Learning - 03A Machine Learning Project Introduction
03.00 What You'll Learn-1 (2:01)
03.01 Build Models On The Web-2 (5:05)
03.02 What Libraries Will We Use-3 (5:56)
Source Files
Data Science with Stocks, Excel and Machine Learning - 03B Your First Machine Learning Stock Prediction Project
03.01 Scrape Data Via Api-1 (16:42)
03.02 Define Variables-2 (11:36)
03.03 Split Dataset For Training And Testing-3 (7:33)
03.04 Build A Linear Regression Model-4 (9:16)
03.05 Predict Stock Prices-5 (10:14)
03.06 Calculate Model Accuracy-6 (14:17)
03.07 Predict To Buy Or To Sell-7 (7:23)
03 Source Files
Data Science with Stocks, Excel and Machine Learning - 04 Deep Learning Project for Stock Market Prediction
04.00 Recurrent Neural Networks-1 (6:23)
04.01 Import Stock Data-2 (9:19)
04.02 What Is Shaping Data-3 (5:18)
04.03 Shape Training And Testing Data-4 (12:06)
04.04 What Is Scaling Data-5 (6:35)
04.05 Scale Data For Training-6 (11:24)
04.06 What Is Keras-7 (3:24)
04.07 Build A Keras Model-8 (14:03)
04.08 Scale And Shape Data For Testing-9 (5:33)
04.09 Test The Model-10 (5:15)
04 Source Files
Quiz - Test your knowledge
Quiz - Test your knowledge
6.8 Refresh And Drill Down From Databases-9
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