|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-2019-basics/
课程评论:没有评论
Coursera 课程 “精通 Excel 2019 - 基础” 旨在帮助学习者掌握 Microsoft Excel 2019 的基本操作和功能。 **课程内容摘要:** 本课程将引导您: * **熟悉 Excel 界面:** 学习如何创建和保存工作簿,快速访问命令,以及选择和输入数据。 * **进行数据计算:** 掌握使用公式和函数进行数据计算的方法。 * **管理工作表:** 学习如何插入、删除行和列,以及管理多个工作簿内部的工作表(添加、删除、重命名、排序、复制和颜色编码)。 * **美化和格式化数据:** 应用文本、数字和单元格的格式,包括使用单元格样式和条件格式。 * **控制打印输出:** 了解如何使用页面布局选项、分页符以及页眉和页脚来控制工作表的打印效果。 * **自定义 Excel:** 学习如何通过添加功能区组和修改快速访问工具栏来自定义 Excel。 * **利用视图功能:** 掌握使用视图功能比较工作簿、工作表或保存自定义视图。 **课程亮点:** Excel 是现代商业中最实用、最有价值的技能之一。掌握 Excel 能够帮助您从整理列表到创建复杂的交互式报告,甚至解答诸如投资回报率 (ROI)、预算分配、费用跟踪等关键业务问题。本课程是您迈向 Excel 专家之路的第一步,提供超过四小时的高质量高清内容,采用 Bigger Brains 独有的“高度互动”师生教学风格。
You will be able to:Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering dataPerform calculations using formulas and functionsInsert and delete rows and columnsApply formatting to text, numbers, and cells including using Cell Styles and Conditional FormattingControl how your worksheets print using Page Layout options, Page Breaks, and Headers and FootersManage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheetsUse View features to compare workbooks, compare worksheets, or save Custom ViewsCustomize Excel by adding Groups to the Ribbon and modifying the Quick Access ToolbarLearn how to use the world's most popular software tool for organizing and analyzing data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders-from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.This is our most requested training course!Topics covered include:Navigating the interfaceCreating and saving workbooksSelecting and entering dataPerforming calculationsFormatting dataManaging multiple worksheetsCustomizing your optionsOver four hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!