April 2026
Intermediate
390 pages
5h 31m
Chinese
Content preview from 学习 Excel 生成式人工智能工具 (Chinese Edition)
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.
第三部分： 适用于 Excel的其他 AI 工具
第三部分重点介绍如何通过集成外部 AI 工具和基于 Python 的工作流，将 Excel 的功能扩展到其原生能力之外。您将学习如何将 Excel 与专业插件和编程工具连接起来，为电子表格带来更多的自动化、智能和灵活性。各章节展示了 Excel 如何从传统的计算工具演变为 AI 辅助数据处理、高级分析以及结合公式、代码和外部服务的半自动化工作流的枢纽。
第 11 章介绍了除 Copilot 之外、可直接在 Excel 中使用的替代性 AI 工具，其中许多提供免费套餐，特别适合处理小型数据集。在介绍加载项的作用及其如何通过专业 AI 功能扩展 Excel 之后，本章将深入探讨几种工具的实际应用。 您将看到Numerous.ai如何将AI融入公式以实现数据提取和分类，GPT for Work如何支持结构化数据提取和文本生成，Power GPT如何协助公式计算和工作流指导，以及Sally Suite如何实现AI驱动的分析并提供Python代码。
第 12 章展示了 Python 和 AI 如何将 Excel 扩展为更强大、更灵活的分析工具。我们将从使用=PY()函数在 Excel 中嵌入 Python 开始，学习如何直接在单元格中运行小型分析，并了解其局限性。随后，本章将介绍如何连接 Excel、Python 和 OpenAI API，其中 Excel 作为界面，Python 负责处理和调用 AI 服务。
附录 C收录了受第三部分各章启发的实践活动，以应用型虚构故事的形式呈现。这些基于叙事的练习让您能在真实的情境故事中实践各章的技术概念，在保持学习体验生动有趣的同时，巩固您的理解。
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.