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中使用 ChatGPT
在第一部分中，您将学习将 Excel 与 AI 相结合的基本思路。我们将重点介绍 ChatGPT，但您也可以将所述方法应用于其他 AI 工具，例如 Gemini 和 Claude，甚至可以应用于本地安装的对话模型。
第 1 章介绍了 Excel 的基本概念，并阐述了电子表格为何与 AI 辅助天然契合。本章描述了 AI 为 Excel 带来的优势，包括速度、易用性以及对复杂分析的支持，同时也探讨了 AI 价值有限或可能掩盖简单逻辑的情境。本章还通过一个简单示例，演示了 AI 如何更快地完成常见的 Excel 操作。最后，本章概述了适用于 Excel 的主要 AI 工具，为后续章节的实际应用奠定基础。
第2章介绍了一种基于叙事弧（背景、核心观点和行动）的实用框架，用于构建与ChatGPT的对话。这种方法鼓励一种超越单一AI工具的思维方式。本章不侧重于如何操作特定系统，而是帮助您通过结构良好的prompt，培养一种可复用的AI交互思维模式。 该框架通过 ChatGPT 进行演示，并应用于常见的 Excel 任务。本章结尾提供了创建基本函数和公式的实操 prompt。
第3章阐述了如何利用ChatGPT加速常见Excel任务，例如模板创建、自动填充和数据增强。基于第2章介绍的prompt结构，本章展示了如何通过清晰、可重复的指令，将结构化的Excel操作委托给ChatGPT。通过实际案例和练习，本章既突出了效率提升，也强调了验证AI生成结果的重要性。
第4章探讨了利用ChatGPT进行的高级Excel操作，重点涵盖数据分析、数据透视表以及基于宏和VBA的自动化。本章展示了ChatGPT如何帮助识别数据集中的关键问题、生成解答公式，并引导分析工作流的实施。同时，还演示了如何利用ChatGPT编写、泛化及调试VBA宏，在实现更复杂自动化操作的同时，确保用户仍能掌控验证与最终决策。
第四部分的第一个附录将第一部分的理念付诸实践。它没有重复理论讲解，而是引入了一系列围绕“应用小说”构建的实践活动——这是一种沉浸式学习形式，借鉴了小说的元素来引导您应对现实情境。随着叙事的推进，概念自然浮现，让您在跟随故事发展的过程中完成学习。
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.