Sign-In
Cart
The Excel AI Prompt Book: 350+ Prompts for Formulas, Data Cleaning, Dashboards, Automation and Financial Models
Paperback
Publisher: Independently Published
Published: Jul 26 2026
Pages: 86
Weight: 0.28
Height: 0.18 Width: 6.00 Depth: 9.00
Language: English
It looks right. It uses real functions. It returns #VALUE! - or worse, it returns a number that's wrong.
That happens for five specific reasons, and this book opens by explaining all of them. The AI doesn't know your Excel version, so it hands you XLOOKUP when you're on Excel 2016. It doesn't know your layout, so it references the wrong cells. It assumes your data is clean. It doesn't know whether you want a formula, a spilled array, or a Power Query step. And it guesses with total confidence.
370 prompts, each written to avoid those failures. Every technical prompt asks for your version, your layout, and an explanation you can actually check.
What's inside- 65 formula and function prompts - lookups, text, dates, conditional logic, dynamic arrays, and debugging
- 55 data cleaning prompts - numbers stored as text, broken dates, duplicates, merged cells, and messy exports
- 60 dashboard, chart and PivotTable prompts
- 55 automation prompts - Power Query, VBA and Office Scripts
- 60 financial modelling prompts - structure, three-statement builds, scenarios and model review
- 55 troubleshooting, speed and best-practice prompts
- 20 Power Modifiers that upgrade any prompt instantly
Analysts, accountants, finance teams, operations managers, and anyone who has ever spent an afternoon fighting a formula that should have taken two minutes.
Covers Excel 365, 2021, 2019 and 2016, with Google Sheets differences flagged throughout. Works with ChatGPT, Claude, Gemini and Copilot.
Not affiliated with or endorsed by Microsoft Corporation.
Also from
Reddy, Palgun
The Accountant's IFRS Quick Reference: 24 Standards Summarized for Working Accountants, Including the New IFRS 18
Reddy, Palgun
Paperback
Also in
Business General
Crucial Conversations Tools for Talking When Stakes Are High, Second Edition
Grenny, Joseph
Patterson, Kerry
Switzler, Al
Paperback
The Pig and I: The Tale of Our Relationship with a Beast We Eat
Endresen, Kristoffer Hattleland
Hardcover
Inspired: Understanding Creativity: A Journey Through Art, Science, and the Soul
Richtel, Matt
Hardcover
Quiet Girls Can Run the World: Owning Your Power When You're Not the Alpha in the Room
Holman, Rebecca
Paperback
Inclusive Conversations: Fostering Equity, Empathy, and Belonging Across Differences
Winters, Mary-Frances
Paperback
Disney's Land: Walt Disney and the Invention of the Amusement Park That Changed the World
Richard Snow
Hardcover
Climb: Taking Every Step with Conviction, Courage, and Calculated Risk to Achieve a Thriving Career and a Successful Life
Brown, Carolyn M.
Gadsden-Williams, Michelle
Paperback
The Token: Common Sense Ideas for Increasing Diversity in Your Organization
Farmer, Crystal Byrd
Paperback
Paris Chic & Trendy: Designers' Studios, Hip Boutiques, Vintage Shops
Ribes-Tiphaine, Adrienne
Paperback
The Reverse Centaur's Guide to Life After AI: How to Think about Artificial Intelligence--Before It's Too Late
Doctorow, Cory
Paperback
The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking about
Robbins, Mel
Robbins, Sawyer
Hardcover
Unreasonable Hospitality: The Remarkable Power of Giving People More Than They Expect
Guidara, Will
Hardcover
Hbr's 10 Must Reads on Managing Yourself, Updated and Expanded (Featuring How Will You Measure Your Life? by Clayton M. Christensen)
Gallo, Amy
Review, Harvard Business
Drucker, Peter F.
Paperback
The Risk Worth Taking: A Story of Breaking Free and Trading for a Life You Love
Ijeoma, Teri
Hardcover
Focused & Fearless Leadership: Preventing the Crisis Before It Starts
Overton, Melissa Godwin
Paperback
The Retire Sooner Method: The 5 Secrets Behind America's Happiest (and Unhappiest) Retirees
Moss, Wes
Hardcover
1873: The Rothschilds, the First Great Depression, and the Making of the Modern World
Ahamed, Liaquat
Hardcover
Hbr's 10 Must Reads on Mental Toughness, Updated and Expanded (Featuring How to Stop Worrying about What Other People Think of You by Michael Gervais)
Duckworth, Angela L.
Review, Harvard Business
Gervais, Michael
Paperback
The Goal: 40th Anniversary Edition: A Process of Ongoing Improvement
Cox, Jeff
Goldratt, Eliyahu M.
Paperback
Take Breaks, Work Better: Measure Impact, Not Hours, and Transform Your Profitability
Briggs, John
Paperback
How to Be a Rich Old Lady: Your Guide to Easy Investing, Building Wealth, and Creating the Wild, Beautiful Life You Want
Holden, Amanda
Hardcover
Crucial Conversations: Tools for Talking When Stakes Are High
Grenny, Joseph
McMillan, Ron
Patterson, Kerry
Paperback
How We Could: The Framework to Lead Without Drama, Build Alignment, and Call Teams to Greatness
Dorr, Alex
Hardcover
Hbr's 10 Must Reads on Leadership, Updated and Expanded (Featuring Begin with Trust by Frances X. Frei and Anne Morriss)
Review, Harvard Business
Edmondson, Amy C.
Ibarra, Herminia
Paperback
The Everywhere Millionaire: Who Is Really Rich in America and How They Got There
Zwick, Eric
Zidar, Owen
Hardcover
Money Unlocked: How to Make It, Keep It and Multiply It: The New York Times Bestseller
Lee, John
Paperback
The Freedom-Based Business Method: Reset, Systemize, and Realign Your Business to Live a Life of Harmony
Ellis, Natalie
Hardcover
The Daily Stoic: 366 Meditations on Wisdom, Perseverance, and the Art of Living
Holiday, Ryan
Hanselman, Stephen
Hardcover
Surrender to Lead: The Counterintuitive Approach to Driving Extraordinary Results
Kriegel, Jessica
Terry, Joe
Hardcover
The Courage to Commit: Embrace the Radical Power of Sticking with Something
Johnson, Shawn
East, Andrew
Hardcover
A Guide to the Project Management Body of Knowledge (Pmbok(r) Guide) -- Eighth Edition and the Standard for Project Management
Project Management Institute
Paperback
Who Moved My Cheese?: An A-Mazing Way to Deal with Change in Your Work and in Your Life
Johnson, Spencer
Hardcover
The Infinity Machine: Demis Hassabis, Deepmind, and the Quest for Superintelligence
Mallaby, Sebastian
Hardcover
Conversation: How to Connect with Anyone & Make Every Interaction Count
Van Edwards, Vanessa
Hardcover
The Mom Test: How to talk to customers & learn if your business is a good idea when everyone is lying to you
Fitzpatrick, Rob
Paperback
The Millionaire Next Door: The Surprising Secrets of America's Wealthy
Danko, William D., PH. D.
Stanley, Thomas J., PH. D.
Paperback
Dummies Guide to Starting Your Own Business: Essential Steps to Launching and Scaling a Successful Small Business Venture
Press, Essywrites
Paperback
7-Figure Educator: Turn Your Experience as an Educator Into Income, Impact, and Freedom
Jordan-Thomas, Erica
Paperback
What the Heck Is Eos?: A Complete Guide for Employees in Companies Running on EOS
Wickman, Gino
Bouwer, Tom
Hardcover
Get Scalable: The Operating System Your Business Needs To Run and Scale Without You
Deiss, Ryan
Paperback
Confidence (HBR Emotional Intelligence Series)
Review, Harvard Business
Kanter, Rosabeth Moss
Chamorro-Premuzic, Tomas
Paperback
The Coaching Habit: Say Less, Ask More, and Change the Way You Lead Forever
Stanier, Michael Bungay
Paperback
Never Split the Difference: Negotiating as If Your Life Depended on It
Voss, Chris
Raz, Tahl
Hardcover
I Will Teach You to Be Rich: No Guilt. No Excuses. Just a 6-Week Program That Works (Second Edition)
Sethi, Ramit
Paperback
Twenty Minutes Is the New Hour: The Ambitious Woman's Guide to Doing Less and Achieving More
Hauser, Fran
Hardcover
The Overthinker's Guide to Making Decisions: How to Make Decisions Without Losing Your Mind
Nguyen, Joseph
Hardcover
Stop Asking for Referrals: Build a Magnetic Business Through Intentional Care & Real Relationships
McNally, Flor de Maria
Paperback
Hábitos Atómicos: Cambios Pequeños, Resultados Extraordinarios / Atomic Habits
Clear, James
Paperback
The Eureka Machine: Why AI Is the Key to Unlocking a New Era of Scientific Discoveries
Socher, Richard
Hardcover
Mindful Listening (HBR Emotional Intelligence Series)
Hougaard, Rasmus
Zenger, Jack
Review, Harvard Business
Paperback
Expecting Better: Why the Conventional Pregnancy Wisdom Is Wrong--and What You Really Need to Know
Oster, Emily
Paperback
Atlas of the Heart: Mapping Meaningful Connection and the Language of Human Experience
Brown, Brené
Hardcover
Influence and Persuasion (HBR Emotional Intelligence Series)
Review, Harvard Business
Morgan, Nick
Cialdini, Robert B.
Paperback
A Little More Social: How Small Choices Create Unexpected Happiness, Health, and Connection
Epley, Nicholas
Hardcover
Building Great Businesses: Create Momentum, Overcome Setbacks, and Scale with Confidence
Becker, Scott
Hardcover
Money to Burn: The Unvarnished Truth about Leon Black, Apollo, and the Rise of a New Wall Street
Cohan, William D.
Hardcover
Crucial Accountability: Proven Skills to Build Trust, Address Disappointment, and Get Results, Third Edition
Patterson, Kerry
Grenny, Joseph
Hale, Justin
Hardcover
Power and Impact (HBR Emotional Intelligence Series)
Review, Harvard Business
Cable, Dan
Bregman, Peter
Paperback
Happiness (HBR Emotional Intelligence Series)
McKee, Annie
Gilbert, Daniel
Review, Harvard Business
Paperback
Getting to Yes: Negotiating Agreement Without Giving in
Ury, William
Patton, Bruce
Fisher, Roger
Paperback
The Algorithm: The Hypergrowth Formula That Transformed Tesla, Lululemon, General Motors, and Spacex
McNeill, Jon
Hardcover
How to Work with Complicated People: Strategies for Effective Collaboration with (Nearly) Anyone
Leak, Ryan
Hardcover
No Experience Necessary: Why Betting on Yourself in Your Twenties Is the Best Decision You'll Ever Make
Harary, Ronnen
Hardcover
From Operator to Owner: The Entrepreneur's Guide to Running a Business That Doesn't Run You
Landry, Liz
Hardcover
Mindfulness (HBR Emotional Intelligence Series)
Review, Harvard Business
Langer, Ellen
Goleman, Daniel
Paperback
Feedback That Works: How to Build and Deliver Your Message, Second Edition
Center for Creative Leadership
Paperback
The Way of Excellence: A Guide to True Greatness and Deep Satisfaction in a Chaotic World
Stulberg, Brad
Hardcover
Hbr's 10 Must Reads on Strategy, Updated and Expanded (Featuring the Five Competitive Forces That Shape Strategy by Michael E. Porter)
Kim, W. Chan
Review, Harvard Business
Porter, Michael E.
Paperback
Take It Personal: How to Succeed by Building Relationships and Playing the Long Game
Grutman, David
Hardcover
The Phoenix Project: A Novel about It, Devops, and Helping Your Business Win
Kim, Gene
Behr, Kevin
Spafford, George
Paperback