|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-mac-2011-beginning/
课程评论：没有评论
**Coursera 课程摘要：《Microsoft Excel for Mac 2011 - 入门与进阶》** 本课程由专业企业培训师教授，采用友好、循序渐进的教学方法，方便学员跟随练习。课程旨在帮助学员全面掌握 Excel 核心功能，并建立自信。 **课程内容涵盖：** * **基础操作：** 从空白工作簿开始，学习输入数值、进行计算和使用公式。 * **函数应用：** 掌握 AVERAGE、SUM、MIN、MAX 等常用函数及其修改方法。 * **数据管理：** 学习将数据转换为表格的优缺点，以及如何按多重条件进行排序和筛选。 * **图表制作：** 学习创建图表，并了解如何添加数据系列以实现图表的自动更新。 **通过本课程，您将能够回答以下问题：** * 工作簿、工作表、模板、文件之间的区别是什么？ * 标签和数值的区别及其重要性是什么？ * 能否自信地使用和修改 AVERAGE、SUM、MIN、MAX 等计算公式？ * 何时应将数据转换为表格范围，其优缺点是什么？ * 如何根据多个条件对数据进行排序和筛选？ * 如何向数据范围添加系列，使图表自动更新？ 如果您对以上任何问题表示“否”，那么本课程将是您的理想选择。课程将详细解答这些问题，并带来更多收获。欢迎加入，一同探索 Excel 的强大功能！
This course is taught by a professional corporate trainer in a friendly, step by step method so that you can follow along and do the steps with the instructor. If you prefer to watch and listen, that works great too! This course is designed to give you complete confidence in your knowledge of Excel. You will learn core features that you will use and build on throughout the course as we increase our knowledge of key features. We start with a blank workbook and will build out multiple sheets from entering values to calculations and functions, all the way to building charts and updating data series. This course is titled Beginning Excel but actually covers intermediate topics, too! Can you answer these questions? 1. What is the difference between workbooks, spreadsheets, templates, sheets, file? 2. What is the difference between labels and values and why is that important? 3. Can you confidently use and modify calculations and average, sum, min and max formulas? 5. When should you convert your data to a table range and what are the pro's and con's? 6. How do I sort and filter my data by multiple criteria? 7. How do I add a series to a data range and have a chart automatically update? If you answered "no" to any of these questions, then this course is for you! We will answer all of these questions and much more! Come on in and join us! We look forward to having you!
