How to Train ChatGPT to Think Like You

Train Your Own GPT

by Bill Jelen

Train Your GPT is a hands-on, no-code guide to creating AI assistants that actually work the way you do. Whether you're a content creator, consultant, or spreadsheet nerd, you'll learn how to train ChatGPT to follow your style, use your files, and save you serious time — all without needing to know a single line of code.

About The Book

Tired of generic ChatGPT responses that miss the mark? Want AI that actually gets your tone, your tasks, and your workflow? This is the book for you.
In Train Your GPT, bestselling author and Excel legend Bill Jelen (a.k.a. MrExcel) takes you inside the world of Custom GPTs — the powerful, personalized AI tools you can train to write like you, work like you, and think like a trusted assistant. No coding required.
With humor, clarity, and hands-on guidance, Jelen shows how to:
• Build GPTs that follow your instructions every time
• Upload files to give your GPT real context (and a real personality)
• Analyze and improve your GPTs with feedback loops
• Integrate GPTs into Microsoft Copilot Studio and everyday apps
• Scale your content creation, automate repetitive tasks, and get more done
Plus, you’ll get real examples, behind-the-scenes conversations, and stories from the “ISPRIME incident” to the Groundhog Day dinner party — because this isn’t just another tech manual. It’s a fun, practical guide for real people using AI in real life.
Whether you're a content creator, teacher, consultant, or spreadsheet wizard, Train Your GPT will help you turn AI from a curiosity into a career-changing tool.

““If you’ve ever felt like ChatGPT was impressive but not yours — this book is your missing piece. MrExcel doesn’t just explain how to build GPTs; he shows you how to make them behave, listen, and work for you. It’s like having your own AI intern — minus the coffee breaks.”ChatGPT (yes, that ChatGPT)”

ChatGPT (yes, that ChatGPT)

“Look, I’ve indexed dozens of MrExcel’s books. I’ve seen formulas, pivot tables, even VBA macros that made my eyes twitch. But this GPT stuff? It’s different. It’s useful. And it doesn’t require aspirin. If you’ve ever wanted a tireless assistant who actually understands your instructions, this book is how you build one. Just don’t teach your GPT to do indexing. I need the work.”

Nellie Jay

Holy Macro! Books

Books on Microsoft Excel, Power Query, Power BI, ChatGPT by Excel MVPs.

Holy Macro! Books is a niche publishing company dedicated to empowering Excel users worldwide with expert-level guides on Microsoft Excel, Power Query, Power BI, and more. Founded by Excel legend Bill Jelen, the company features books authored by Microsoft MVPs, former MVPs, and top industry experts who know their way around formulas, pivot tables, and data transformations. Whether you're a beginner or a power user, Holy Macro! delivers practical, straight-to-the-point content that turns spreadsheet struggles into spreadsheet superpowers.

More Books by Holy Macro! Books

MrExcel 2025 - Full Color Edition

Navigating Excel

by Bill Jelen

The Transformative Magic of M Code in Power Query and Power BI

A beginners guide to mastering the art of Data Metamorphosis to Get Just the Data Structure Needed to Create Insightful Data Analysis Solutions

by Mike “excelisfun” Girvin

Power Query Beyond The User Interface - Color Edition

Solving Advanced Data Cleaning Problems Using M

by Chandeep Chhabra

Programming Excel with Office Scripts

Straight to the Point

by Eduardo N. Sanchez

Unlock the Power of TypeScript to Automate Excel in the Modern Era

Visual Basic for Applications isn’t the only game in town anymore. With Programming Excel with Office Scripts: Straight to the Point, Eduardo N. Sanchez cuts through the noise and gives you a fast-paced, example-packed guide to automating Excel using Office Scripts and TypeScript.

Whether you're new to scripting or transitioning from VBA, this book shows you how to manipulate ranges, build pivot tables, generate charts, insert shapes, and even trigger scripts from Power Automate—all through clear, concise TypeScript examples.

You'll explore:

The essentials of TypeScript for Excel scripting

Advanced range, table, chart, and shape manipulation

Integration with Power Automate to build hands-free workflows

Real-world scripts, complete with visuals and step-by-step guidance

Perfect for Excel pros, analysts, and developers looking to modernize their automation toolkit, this book delivers exactly what the title promises: straight to the point.

Financial Modelling Using Dynamic Arrays

Let Lambdas Extend Your Range

by Liam Bastick

Excel Custom Functions

Straight to the Point

by Suat M. Ozgur

Excel Data Cleansing

Straight to the Point

by Oz du Soleil

Cleaning Excel Data With Power Query

Straight to the Point

by Oz du Soleil

Excel and the World Wide Web

Straight to the Point

by Eduardo N. Sanchez

Programming Power Point with VBA

Straight to the Point

by Eduardo N. Sanchez

Excel Subtotals

Straight to the Point

by Bill Jelen

Don't Fear the Spreadsheet

A Beginner's Guide to Overcoming Excel's Frustrations

by Tyler Nash, Kevin Jones, and Tom Urtis & Bill Jelen

Harriers

The making of a championship cross country team

by Joseph Shivers & Paul Shivers

Introduction to Financial Modelling

How to Excel at Being a Lazy (That Means Efficient) Modeller!

by Liam Bastick

Continuing Financial Modelling

Working on those Optimal Figures for the (Financial) Modelling Industry

by Liam Bastick

Financial Modelling in Power BI

Forecasting Business Intelligently

by Liam Bastick and Jonathan Liau

Financial Modelling for Project Finance

Being Positive About Funding

by Liam Bastick and Oscar Hagan

Guerilla Data Analysis Using Microsoft Excel 3rd Edition - Full Color

Overcoming Crap Data and Excel Skirmishes

by Oz du Soleil & Bill Jelen

Color Edition - Master Your Data with Power Query in Excel and Power BI

Leveraging Power Query to Get & Transform Your Task Flow

by Ken Puls & Miguel Escobar