Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel and PowerBI Automation Mastery with ChatGPT, Python, and Machine Learning: Practical Training and Practice Exam
ChatGPT for Sales Best Practices
01A Course Requirements (1:38)
01B Understanding ChatGPT (2:34)
01C The Role Of AI In Sales And Lead Generation (1:53)
01D Overview Of How ChatGPT Can Improve Outreach Strategy (1:34)
02A Project Preview (1:11)
02B How To Make Specific Asks (16:07)
02C Defining Terms For ChatGPT (3:15)
02D Understanding And Setting The Right Tone For Your Messages (13:05)
02E The Limitations Of AI In Sales And Lead Generation (12:45)
02F How To Utilize Chatgpt Effectively While Being Aware Of Its Limitations (16:09)
02G The Importance Of Checking And Editing AI Output (6:15)
Source files
ChatGPT for Outreach Strategy
03 Source files
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)
ChatGPT for Lead Generation
04 Source files
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)
Improve LinkedIn Sales with ChatGPT
05 Source files
05 01 Project Preview (0:59)
05.02 Understanding The Importance Of Linkedin For B2B Sales (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)
ChatGPT for Sales Role Play
06 Source files
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)
Automate Excel with ChatGPT
01 Course Requirement (2:31)
02 Project Preview (1:36)
02A Set Up Excel Spreadsheet With GPT Add-In (8:37)
02B Excel With ChatGPT (4:51)
02C Write Excel Formulas With ChatGPT (9:39)
02D Use ChatGPT Formulas In Excel (16:18)
Module Reference
Source Files
Measure Sales Performance with KPIs in Excel and ChatGPT
01.01 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 (7:18)
Source files
Sales Data Analysis and Visualization in Excel with ChatGPT
04.01. Project Preview (1:19)
04.02. Aggregating Data By Regions, Categories, And Time Dimension (6:25)
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)
Source files
Sales Modeling in Excel with ChatGPT
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 (6:27)
07.03.Predicting Values Using The Trained Model (11:01)
Source file
Sales Forecasting with Machine Learning
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 file
Automate Excel Data Manipulation with Python and ChatGPT
01 Algorithms To Handle Missing Data (5:13)
02 Generate Excel Data With Missing Data In Python And ChatGPT (3:22)
03 Fill In Missing Excel Data With Python Imputation And ChatGPT (3:51)
04 Delete Missing Excel Data With Python And ChatGPT (5:03)
05 Fill In Missing Data With Knn Imputation (5:24)
Source
02 Categorical data manipulation with Python and ChatGPT
01 What Is Data Encoding (5:36)
02 Perform Excel Data Encoding With Python And ChatGPT (7:18)
03 Choose Data Encoding Technique (3:01)
Source
03 Statistics for data science with Python and ChatGPT
01 What Is Statistics For Data Science (3:31)
02 Levels Of Data Measurement (3:58)
03 Generate Different Types Of Data With ChatGPT (10:02)
Source
04 How to measure data
01 Measures Of Central Tendency In Data (5:00)
02 Measures Of Variability In Data (4:09)
03 What Is Skewness In Data Science (3:38)
04 Generate Skewed Datasets With ChatGPT (7:44)
05 What Are Covariance And Correlation Data Measurements (2:37)
06 Measure Covariance And Correlation Of Dataset With ChatGPT (6:50)
Source
05 Probability distribution functions in data science
01 What Are Probability Distribution Functions In Data Science (4:39)
02 Calculate Probability Distribution Functions Of A Dataset With ChatGPT (5:22)
Source
06 Normal Probability Distribution with Python and ChatGPT
01 What Is Normal Probability Distribution (4:14)
02 Calculate PDF Of Normal Distribution Dataset (5:35)
03 What Is The Central Limit Theorem (2:45)
Source
07 Binomial Probability Distribution with Python and ChatGPT
01 What Is Binomial Probability Distribution (2:52)
02 Calculate PDF Of Binomial Distribution Dataset (10:50)
Source
08 Poisson Probability Distribution with Python and ChatGPT
01 What Is Poisson Probability Distribution (2:42)
02 Visualize Poisson Distribution With ChatGPT And Python (2:31)
Source Files
09 Uniform Probability Distribution with Python and ChatGPT
01 What Is Uniform Probability Distribution (2:36)
02 Visualize Uniform Distribution With ChatGPT And Python (3:55)
Source Files
10 Bernoulli Probability Distribution with Python and ChatGPT
01 What Is Bernoulli Probability Distribution (2:37)
02 Visualize Bernoulli Distribution With ChatGPT And Python (6:43)
Source Files
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
02 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
03 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
04 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
05 Build visualizations in Power BI with ChatGPT
01 Build Visualizations In Power BI With ChatGPT (6:58)
Source files
06 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
07 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
08 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
09 Generate machine learning models with ChatGPT
01 What Kinds Of Machine Learning Can I Do On This Data (2:16)
00 Project Preview - Python Machine Learning With ChatGPT (2:03)
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)
Python Machine Learning Preview (36:01)
Source
10 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
11 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
Test Your Knowledge - Complete these Exams
Where to find the practice exam
08.08.Using XLSTAT For Forecasting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock