Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel and ChatGPT: Data Analysis Power Tips

via LinkedIn Learning

Write review

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Scrimba

Get 20% off all career paths from fullstack to AI

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

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

Syllabus

Introduction

The Future is now: Intro to AI for data analytics
Setting expectations

1. How AI is Revolutionizing Data Analysis

Why AI is a game-changer for data analysis
AI use cases for data analytics

2. A Crash Course in AI, LLMs, and ChatGPT

The AI landscape
Generative AI and large language models
The road to ChatGPT
Generative AI tools
Warning: Pitfalls of ChatGPT
Accessing ChatGPT and Google Bard

3. Prompt Engineering Tips

Intro to prompt engineering
Prompt tip: Be clear and specific
Prompt tip: Provide context
Prompt tip: Establish roles
Prompt tip: Set the tone

4. ChatGPT for Excel

Intro to ChatGPT for Excel
Explain fundamental Excel concepts
Generate Excel formulas from descriptions
Generate DAX and M Code
Automate tasks with VBA macros
Generate formulas from sample data
Ask for Excel data visualization advice
Produce step-by-step Excel tutorials
Collaborate on data prep and EDA
Generate sample datasets

Conclusion

Key takeaways and next steps

Taught by

Chris Dutton

Reviews

4.7 rating at LinkedIn Learning based on 1741 ratings

Start your review of Excel and ChatGPT: Data Analysis Power Tips