🤖Generate Excel Data with Chat GPT - Create Practice Datasets!

Create YOUR OWN Excel datasets with Chat GPT.

#excel #chatgpt #ai

Have you ever found yourself browsing the internet for hours, looking for GOOD Excel datasets to download and use? Maybe you just want some data to practice your Excel skills?

Even if you do find a dataset on a random site, there are usually restrictions on how you can use the data. The datasets also tend to he quite limited in information and hard to decipher.

Instead, we can harness the power of AI and use Chat GPT to generate small or large, relevant datasets for us. We can specify exactly what columns we need and then let ChatGPT work it's magic!

Chapters
00:00 Introduction
01:32 Open Chat GPT and explore the interface
02:40 Providing context when working with Chat GPT
03:15 Type the prompt to generate an employee dataset with custom columns
04:25 Analyze the results
04:45 Modify the prompt
06:38 Download the dataset as a .csv file
07:37 Use Chat GPT to generate a dataset that can be used in a Pivot Table
09:54 Modify the prompt to replace column data
10:30 Download the dataset
10:45 Create a Pivot Table
11:53 Close

********************************

🔗LINKS to related videos

📈Copilot in Excel

🎨Copilot in PowerPoint

📄Copilot in Word

************************************************

🤝Let's CONNECT on social:

[Kenayi]

I recommend this channel to anyone willing and ready to learn without those unnecessary background sounds or fancy editing. Very easy to understand content. Lots of love DA

[deniz.]

My YouTube algorithm has been advanced after I discovered your channel. Best

[Chris______]

Hi Deb, when I tried using Chat GPT for Excel in the past, I frequently ran into a bit of a strife, namely how the formatting came out. You taught me how to use the prompts much more effectively and this is a huge timesaver! Thanks heaps!

[MarlonBHall]

@4:12 is actually great practice for beginners. Its good to know how to quickly clean and sort raw data in Excel.

[VishalKumar-kvdp]

Absolutely killer this time....! I am so very excited to see the possibilities CHAT GPT provides us vis-a-vis Excel. Thanks a lot Ma'am.

[humoaz]

A wonderful video, slow speech, smooth flow and precise explanation. Bless you for contributing to knowledge.

[abrahammanyang]

Amazing video! we'll keep supporting this incredible channel

[mubi]

Very precise and to the point information no waste of time

[markdoswell]

Thank you for the excellent tutorial. Apart from the CHATGPT aspect, I also learnt that my way of working with Excel is pedestrian in parts and can be improved.
Yes, I am a new subscriber 😊

[rodger]

Very nice tutorial. Just now subscribed.

[joyotiegbe]

You are the best. I've been struggling to get datasets for my practice and projects. I'm so grateful.

[kow-Jnr]

i tried using it for advance work like creating drop down list for a specialty with the number of test under it with the related price

[Minnross]

Question: you clearly had a data list to start with? how did you point Chat GPT to access that data? Great video

[bobbyflores]

if you needed the AI to perform a V lookup on an existing data set, can we provide that spreadsheet of data to the AI to perform the look up? if so, how would you go about doing that?🤔

[Luciano_mp]

I've never used gpt Chat, it's amazing what you can do with it! Thanks Deb!

[komagank]

Thanks so much. This is great for people without large dataset. Very cool to discover what AI can do.

[francesdobbins]

I didn't know ChatGPT 4o had a free version? I use the free ChatGPT 3.5 version.
This is an excellent video. Thank you.

[bangipoelkemenag]

very excellant tutorial. Thank you very much..

[ennykraft]

Great video, thank you very much! I definitely will give this a try. I give Excel seminars and creating meaningful and realistically looking data is a huge PITA.

[CaribouDataScience]

Good stuff. I have found it helpful when working with SQL to tell chatGPT what flavor of SQL I am working with.