Preview Mode

large

ChatGPT Free Version vs Paid Version

Get Familiar with the ChatGPT Interface

The input box is used to:

Insert macros

Type prompts and questions

Adjust AI settings

Save files

The sidebar allows you to:

Change the theme of Excel

Edit Excel sheets

Switch between conversations

Run Python

“Regenerate response” is used to:

Generate an alternative answer

Delete the previous prompt

Switch models

Export to Excel

Prompt Engineering Tips

A good prompt should be:

Random

Vague

Overly long

Clear and detailed

Adding examples to a prompt:

Improves accuracy

Stops the model responding

Makes the output less accurate

Confuses ChatGPT

Which is the most effective prompt?

“Help”

“Create a 200-row sales table with UK dates and numeric values”

“Make data”

“Fix this now”

Customise ChatGPT

Custom instructions allow you to:

Install macros

Set your preferred response style

Change Excel settings

Rewrite system files

A useful custom instruction might be:

“Control my computer”

“Access my private database”

“Turn off all safety rules”

“Always create Excel-ready tables”

CHALLENGE 01: Practice working with ChatGPT

A good starter exercise is:

Performing SQL queries

Editing registry keys

Writing VBA loops

Creating small sample datasets

Practising different prompts helps students learn:

How responses change based on input

How to install add-ins

How to run Mac Automator

How to confuse the model

The main benefit of this exercise is:

Replace Excel

Build pivot tables

Build confidence using AI

Learn Python scripting

Up next - Basic Excel with ChatGPT