Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

Video course · 4 chapters · 8 min · certificate

How to Integrate ChatGPT into Microsoft Excel

Sven from Coding Is Fun shows how to add ChatGPT to Excel with VBA: setting up a personal macro workbook, importing a JSON converter and ChatGPT module, adding your API key, and running prompts from the Quick Access Toolbar, a sheet button or an add-in.

Become a memberAlready a member? Sign in

What you'll learn

  • Enable the Developer tab and create a personal macro workbook
  • Import the JSON converter and ChatGPT VBA modules
  • Configure your OpenAI API key and billing
  • Run prompts via the Quick Access Toolbar or a button
  • Use add-ins for team-wide access

Chapters

4 chapters · 7:31
  1. 1:13 01Intro Members Introduction ChatGPT in Excel.
  2. 3:47 02Setup Members Setting things up VBA modules.
  3. 1:00 03Run Members Run via toolbar or button One click.
  4. 1:31 04Add-ins Members Run via add-ins and outro Share with colleagues.

Jobs this course suits

Our AI checked this course against 500 jobs; these get the most out of it. Each job links to its learning path.

AccountantsFinancial AnalystsBusiness AnalystsBusiness Intelligence AnalystsCompensation AnalystsData AnalystsFinance ManagersInsurance Data AnalystsManager of FinancesMarket Research AnalystsMarket Research ManagersMarketing Analysts