April 2026
Beginner
390 pages
9h 23m
English
Content preview from Learning Generative AI Tools for Excel
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Part III. Other AI Tools for Excel
Part III focuses on extending Excel beyond its native capabilities by integrating external AI tools and Python-based workflows. You’ll learn how to connect Excel with specialized add-ins and programming tools bringing more automation, intelligence, and flexibility into your spreadsheets. The chapters show how Excel evolves from a traditional calculation tool into a hub for AI-assisted data processing, advanced analysis, and semi-automated workflows combining formulas, code, and external services.
Chapter 11 presents alternative AI tools to Copilot that can be used directly in Excel, many of which offer free plans that are especially suitable for working with small datasets. After introducing the role of add-ins and how they extend Excel with specialized AI capabilities, the chapter explores several tools in practice. You’ll see how Numerous.ai brings AI into formulas for extraction and classification, how GPT for Work supports structured data extraction and text generation, how Power GPT assists with formulas and workflow guidance, and how Sally Suite enables AI-driven analysis and even provides Python code.
Chapter 12 shows how Python and AI can expand Excel into a more powerful and flexible analysis tool. We start with embedded Python in Excel using the =PY() function, learning how to run small analyses directly in cells and understanding its limitations. The chapter then introduces how to connect Excel, Python, and the OpenAI API, where Excel ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.