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)