|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-in-30-minutes-analyzing-data-with-tables-formatting/
课程评论：没有评论
Coursera 上的这门课程名为“30分钟精通 Excel：使用表格和格式化分析数据”。 **课程概述：** 这门课程旨在帮助学习者在30分钟内掌握 Excel 2019 或 Excel 365 中创建、修改表格以及应用高级条件格式的技能。在现代商业环境中，精通 Excel 是一项极其实用且有价值的技能，因为它在大多数企业中都得到了广泛应用。该系列课程共十一门，每门30分钟，旨在提升业务生产力和个人发展。 **课程内容涵盖：** * 从现有数据创建表格。 * 应用表格工具修改表格。 * 使用表格样式（Table Styles）格式化表格。 * 利用“快速分析”（Quick Analysis）快捷键访问常用功能。 * 为表格添加标准函数和公式。 * 使用“总计行”（Total row）汇总表格数据。 * 通过“规则管理器”（Rules Manager）设置规则优先级、添加和删除条件格式。 * 创建公式以应用条件格式。 **目标受众：** 具备 Excel 2019 或 Excel 365 基础知识，希望运用更复杂的函数和功能来分析数据的人员。 **课程目标：** 学完本课程后，学习者将能够创建和修改表格，并能将高级条件格式应用于电子表格。 **特别说明：** 这是“Bigger Brains Mastering Excel 2019 - Intermediate”系列课程中的一门。内容为高品质高清，采用“独具吸引力”（Uniquely Engaging）的师生互动教学风格。
Learn to create and modify tables and apply advanced Conditional Formatting to a spreadsheet in Excel 2019 or Excel 365-all in under 30 minutes!When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our "Excel in 30 Minutes" series can help you get started.This course is one in a series of eleven 30-minute courses.Topics covered include:Creating a table from existing dataApplying table tools to modify a tableFormatting a table with Table StylesUsing the Quick Analysis shortcut to access commonly used featuresAdding standard functions and formulas to tablesSummarizing table data with the Total rowSetting rule precedence and adding and deleting Conditional Formatting using the Rules ManagerCreating formulas to apply conditional formattingTake the full series and you will have completed our "Bigger Brains Mastering Excel 2019 - Intermediate" course.High-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Target Audience: People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.Course Goal: By the end of this course, you will be able to create and modify tables, and apply advanced Conditional Formatting to a spreadsheet.
