O'Reilly First Edition

Learning Generative AI Tools for Excel

Speed up everyday work with Microsoft Excel, Copilot, ChatGPT, and beyond.

Bring together spreadsheet practice, prompt design, data science workflows, and applied fiction to show how generative AI can become a practical partner inside Excel.

Cover of Learning Generative AI Tools for Excel by Angelica Lo Duca

About the book

From formulas and prompts to dashboards and Python

What you will learn

The book shows how to combine Excel with generative AI to speed up repetitive tasks, sharpen analysis, and make advanced workflows more approachable.

Tools covered

ChatGPT, Microsoft Copilot, Excel AI add-ins, and Python workflows all appear in practical, workbook-centered examples.

Who it is for

Analysts, Excel power users, data practitioners, and curious teams who want to turn AI into a useful daily habit instead of a vague promise.

Inside the chapters

A practical path through the Excel AI landscape

Part I

Using ChatGPT in Excel

Learn prompt structure, formula help, template creation, data enrichment, and troubleshooting through conversational workflows.

Part II

Data Science with Copilot

Move from data preparation to statistics, visualization, dashboards, and reporting with Copilot directly inside Excel.

Part III

Other AI tools for Excel

Explore add-ins, OpenAI-powered workflows, and Python-based extensions for more specialized use cases.

Part IV

Stories and solutions

Finish with applied fiction and activity solutions that turn technical learning into something memorable and hands-on.

Extracts from the book

A few lines from the opening pages

“Excel no longer waits passively for precise instructions; it collaborates, suggests, explains, and accelerates.”

Preface

“This book is about learning how to use Excel and generative AI together, effectively and responsibly, to transform everyday work.”

Preface

“The core concept of applied fiction is using entertainment to increase engagement while learning.”

Part IV overview

Applied fiction

Where narrative becomes part of the learning design

A story that moves with the analysis

The book’s final part connects to a broader applied fiction approach: a narrative framework in which fictional scenarios, datasets, and analytical tasks evolve together, helping readers stay engaged while building practical data skills.

Read online

Access the full book on O’Reilly Online Learning

Read on desktop or mobile

You can read the full book on the O’Reilly Media Online Learning platform with a subscription, including access from desktop and mobile devices. You can also preview the book with a 10-day free subscription.

Resources

Explore the companion GitHub repository

The book’s companion repository includes code examples, exercises, and supporting material related to the chapters and hands-on workflows.