Heads up! Looks like you're using adblock. Please consider supporting us by whitelisting coursedio.online How?
arrow_back
Go back

Excel and ChatGPT: Data Analysis Power Tips

Oct 31, 2023 • Chris Dutton

Start Course arrow_forward

About this course

This beginner-friendly course helps you leverage Excel and ChatGPT together to work more efficiently and make smarter, data-driven decisions.



play_circle_filled

The Future is now: Intro to AI for data analytics

3m 21s
play_circle_filled

Setting expectations

1m 46s
play_circle_filled

Why AI is a game-changer for data analysis

3m 58s
play_circle_filled

AI use cases for data analytics

1m 32s
play_circle_filled

The AI landscape

3m 21s
play_circle_filled

Generative AI and large language models

4m 35s
play_circle_filled

The road to ChatGPT

5m 10s
play_circle_filled

Generative AI tools

1m 58s
play_circle_filled

Warning: Pitfalls of ChatGPT

2m 56s
play_circle_filled

Accessing ChatGPT and Google Bard

1m 21s
play_circle_filled

Intro to prompt engineering

1m 53s
play_circle_filled

Prompt tip: Be clear and specific

1m 9s
play_circle_filled

Prompt tip: Provide context

1m 7s
play_circle_filled

Prompt tip: Establish roles

54s
play_circle_filled

Prompt tip: Set the tone

1m 24s
play_circle_filled

Intro to ChatGPT for Excel

1m 43s
play_circle_filled

Explain fundamental Excel concepts

8m 54s
play_circle_filled

Generate Excel formulas from descriptions

7m 45s
play_circle_filled

Generate DAX and M Code

5m 12s
play_circle_filled

Automate tasks with VBA macros

4m 52s
play_circle_filled

Generate formulas from sample data

6m 6s
play_circle_filled

Ask for Excel data visualization advice

4m 53s
play_circle_filled

Produce step-by-step Excel tutorials

10m 36s
play_circle_filled

Collaborate on data prep and EDA

6m 40s
play_circle_filled

Generate sample datasets

5m 14s
play_circle_filled

Key takeaways and next steps

3m 39s