|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/copilot-in-excel-365-beginner/
课程评论：没有评论
**课程名称：Excel 365 Copilot 入门** **课程简介：** 本课程旨在为Excel用户介绍Excel Copilot的基础知识，无需任何Copilot的先验知识。课程将从许可和工作环境要求入手，确保学员能够顺利上手。学员将使用与讲师相同的示例数据文件进行学习。 **课程内容将涵盖：** * **Copilot 面板探索：** 详细介绍Copilot面板的各项功能。 * **提示词工程：** 学习如何撰写有效的提示词，以便Copilot能够精确理解并执行任务。 * **数据处理与分析：** * 让Copilot创建计算列。 * 在不同工作表上生成汇总计算。 * 执行数据操控和公式编写，以管理现有数据。 * **PivotTables 的应用：** 探索Copilot在数据筛选和汇总时如何生成PivotTables，并深入分析其输出结果，理解其工作原理。 * **数据格式化与样式：** * 利用Copilot根据特定条件高亮数据。 * 生成仪表板风格的图标和格式。 * 处理多列数据，应用包含多个条件的格式化和样式，尤其会考察Copilot如何利用Excel的条件格式功能。 * 对Copilot生成的格式化结果进行审阅和调整。 * **数据汇总与图表生成：** * 让Copilot对数据进行汇总并创建各种类型的图表。 * 展示和解释数据塑形（Data Shaping）的概念，并分析Copilot生成的结果。 **总体而言，本课程将帮助您掌握如何利用Excel Copilot来提高数据处理、分析、格式化和可视化工作的效率。**
This course introduces Excel users to the basics of Excel Copilot. No previous experience with Copilot is required. This course starts by examining the licensing and work environment requirements to get started.Students follow the instructor with the same data files that the instructor uses. The Copilot pane is explored, and its features examined.Writing good prompts is explained and Copilot is asked to create calculated columns in tables, summary calculations on different worksheets, and data manipulation formulae to manage existing data.Excel Copilot often creates PivotTables when it needs to filter or summarize data. This aspect of Copilot is explored and demonstrated. The output of Copilot is deconstructed to understand how Copilot answers questions of this type.Formatting and styling data comes next. Copilot is asked to highlight data based on specific criteria. Dashboard style icons and formatting result. Formatting and styling are done with multiple criteria against different columns of data in a table. Copilot often leverages Excel's Conditional Formatting feature. The results are examined and changed, as necessary.Finally, data is summarized and charted by Copilot. Copilot can use many chart types, and several are used in this course. Data shaping is explained and demonstrated, and the output of Copilot is examined.
