|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-the-next-level-expert-with-formulas-and-charts/
课程评论：没有评论
**Coursera 课程总结：Excel 进阶 – 公式与图表专家** 本课程专为已有 Excel 基础，希望提升技能以创建专业报告的学习者设计。课程将深入讲解如何进行强大的数据计算和图表可视化，以高效处理数据流程。 **课程内容概览：** * **Excel 基础设置：** 深入了解“信息”和“选项”区域，学习如何正确配置和设置 Excel 文件及报告。 * **功能与选项：** 全面介绍各个功能区（Ribbon）的强大功能和选项。 * **高级格式化：** 掌握条件格式的运用，实现数据的动态可视化。 * **数据验证：** 学习如何为单元格和区域定义数据验证规则，确保数据准确性。 * **核心公式与函数：** 重点讲解文本函数、查找与引用函数、信息函数、逻辑函数等常用高级函数的应用。 * **图表创建与格式化：** 学习如何为不同类型的数据创建和美化图表。 * **数据透视表与数据透视图：** 掌握数据透视表和数据透视图的创建与管理，进行高效的数据分析。 * **工作表与工作簿保护：** 学习如何对工作表（整体或部分）和工作簿进行保护，确保数据安全。 **学习成果：** 完成本课程后，您将能够： * 生成复杂的专业报告。 * 有效分离数据与公式。 * 格式化专业的数据表格。 * 轻松创建和修改各类图表。
This is a course for those who are already familiar with Microsoft Excel but need to move to the next level and understand how to create professional reports which require strong calculations and graphical representations of the data and data flow. The students get a first overview of the Info and Options areas where a lot of information and configuration is done in order to setup your files and report in the correct way. The course includes then: An overview of the functionalities and options of the different ribbons information about how to create advanced formatting using the conditional formatting functionalities instructions about how to define data validation for set of cells and ranges explanations of the main formulas and functions, especially about text, lookup & reference, information, logical, and more instructions about how to create and format charts will different set of data tutorial on how to create and manage pivot tables and charts instructions to protect a worksheet (entirely or partially) and a workbook At the end the students will be able to generate complex report, separating data from formulas, formatting tables, generate easily charts and modify them at a glance is a few clicks.
