ChatGPT + Excel | Use Power Query Like Never Before with CHAT GPT | EP 05

Опубликовано: 20 Сентябрь 2023
на канале: Pavan Lalwani

8,261

188

ChatGPT + Excel | Use Power Query Like Never Before with CHAT GPT | EP 05

Welcome back to another episode on Chat GPT. In today's video, we are exploring the world of ChatGPT 🤖. Struggling with Power Query's M Code or wish you could scrape web data without coding? Interested in real-time stock market insights or shopping assistance on Amazon? This video is your solution! Learn how ChatGPT can save you time ⏰, act as an interactive teacher, and offer problem-solving advice. Ideal for data analysts, stock market enthusiasts, online shoppers, and anyone interested in AI and automation.

🕒 Chapters:

0:00 - Introduction
1:00 - How to Fetch Data from Websites like Amazon, Flipkart
3:20 - Cleaning Up Your Raw Data
5:45 - How to Use ChatGPT for Code Commenting
7:10 - Adding 10 Days to a Date and Calculating Age
9:00 - Counting People by Gender in Your Data Set

🔹 Topics Covered:

»How to Fetching Data from Websites
»How to Data Cleaning Techniques
»Code Commenting with ChatGPT
»Calculating Age & Adding Days to Dates
»Counting Occurrences by Gender

#powerquery #datacleaning #webscraping #mcode #datascraping #office365 #chatgpt #pavanlalwani #powerbi