Skip to Content
学习 Excel 生成式人工智能工具 (Chinese Edition)
book

学习 Excel 生成式人工智能工具 (Chinese Edition)

by Angelica Lo Duca
April 2026
Intermediate
390 pages
5h 31m
Chinese
O'Reilly Media, Inc.
Content preview from 学习 Excel 生成式人工智能工具 (Chinese Edition)

附录 D. 练习题答案

第1章

A crossword puzzle featuring terms related to Excel and ChatGPT, highlighting concepts such as "worksheet," "copilot," and "AI."

第 2 章

在本章中,您 学习了如何构建有效的 prompt,以充分利用 CHATGPT 处理 Excel 任务,并将其分为三个基本部分:背景、要点和操作。背景(CONTEXT)定义了构建问题所需的数据和信息,要点(MAIN POINT)描述了所需的操作,而操作(ACTION)则说明了如何使用结果。

ChatGPT可作为助手执行各类任务,例如生成用于计算(如求和或求平均值)的公式,或使用VLOOKUP等函数进行查找操作。结合这些策略,有助于您提高工作效率、实现复杂计算的自动化,并快速解决数据集中的问题。

第 3 章

A word search puzzle highlighting terms related to productivity and calculation strategies, including "autofill" and "context."

Excel 的“自动填充”功能可补全模式或数据,而 AI 则能加速这一过程。

第 4 章

A crossword puzzle with words like "PIVOT," "DATA," "SALES," and "EXCEL" reflecting concepts of data management and analysis.

第 5 章

A crossword puzzle with Excel-related terms demonstrating key concepts such as "EDIT," "UNDERSTAND," and "GRAPH," relating to data preparation and manipulation.

第 6 章

在本章中,您了解了在进行任何分析之前,正确的数据准备工作是多么重要。

为了支持这一过程,您还探索了在 Excel 中与 COPILOT 交互时如何构建有效的 prompt。

本章涵盖了三项核心操作:识别并删除重复值、处理缺失值,以及应用一致的数据格式。

这些步骤对于消除噪声、纠正错误以及确保数据能够产生可靠的洞察力都至关重要。

例如,向 Copilot 提供清晰具体的指令,能使其更有效地响应您的需求。同时,诸如“突出显示规则”和自定义公式等工具,有助于确保数据集的可靠性和一致性。

请谨记:数据预处理不仅仅是一个技术步骤;它能让规律浮现、将错误降至最低,并让您有信心得出有意义的结论。

第 7 章

在本章中,您学习了如何使用 Copilot 来解释、生成和调整文本公式,处理现实世界中的数据错误,以及应用条件逻辑。

第 8 章

A crossword puzzle with words such as "MEDIAN," "CELLS," and "EXCEL," illustrating data-related terms from the chapter on using Copilot for handling text formulas and conditional logic.

第 9 章

Word search puzzle with various words circled, illustrating text manipulation concepts.

COPILOT 引导数据使用。

第 10 章

在本章中,您学习了如何在 Excel 中使用 Copilot 创建完整的报告工作流,从数据清理到可视化、构建摘要、设计仪表板、生成折线图,甚至使用宏自动化任务,所有这些都是为了生成清晰且可操作的报告。

第 11 章

AI 加载项通过提供专门的数据分析和自动化工具,增强了 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

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’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.
Head of Cybersecurity
QuotationMarkI 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.
Field Engineer
QuotationMarkI’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.
Data Platform Tech Lead
QuotationMarkI'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.
Mark W.
Embedded Software Engineer

You might also like

向量数据库 (Chinese Edition)

向量数据库 (Chinese Edition)

Nitin Borwankar

Publisher Resources

ISBN: 0642572371579