|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/office-excel-2016-intermediate/
课程评论：没有评论
**课程名称：**Microsoft Office Excel 2016：第二部分（中级） **课程概述：** 本课程旨在帮助学员深入掌握Excel 2016的中高级功能，以组织、分析和可视化数据，并通过公式解决实际任务。在当今数据驱动的环境中，从原始数据中提取有价值的洞察力对于提升竞争力至关重要。本课程将教授您如何让Excel为您提供数据的答案，从而做出明智的决策。 **教学方法：** 讲师将循序渐进地讲解Microsoft Excel的关键功能和实用技巧。课程提供丰富的辅助材料，包括练习文件、讲义和测验，以巩固学习效果。本课程内容涵盖Microsoft Office Specialist（MOS）考试目标，为备考Excel 2016考试和Excel 2016专家级考试的学生提供支持。 **适合人群：** * 已有Excel基础知识的学习者。 * 希望利用Excel高级功能进行数据分析和呈现的学习者。 **先修课程：** 本课程建立在“Microsoft Office Excel 2016：第一部分”课程所介绍的基础知识之上。 **学习目标：** 成功完成本课程后，您将能够创建高级工作簿和工作表，加深对组织信息能力的理解。掌握分析海量数据、提炼有价值信息并将其呈现給决策者的能力，是组织高水平竞争力的基础。您将能够利用数据分析和呈现的力量，做出明智的组织决策。具体而言，您将学会： * 运用各种函数。 * 处理和管理列表。 * 进行数据分析。 * 使用图表进行数据可视化。 * 创建和使用数据透视表（PivotTables）和数据透视图（PivotCharts）。
COURSE DESCRIPTIONExcel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. In this advanced course, you will learn how to organize, analyze, and visualize your data and calculations. We'll also show you how to apply formulas to solve tasks. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you.METHODThe trainer explains step by step all important and useful functionalities and features for working with Microsoft Excel. Benefit from the extensive additional materials that are integrated into the training. Look forward to practice files, handouts and quizzes. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.THIS COURSE IS SUITABLE FOR YOU IFyou already have a foundational knowledge in Excelyou wish to take advantage of some of the higher-level functionality in Excel to analyze and present dataPREREQUISITESThis course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part 1 course.COURSE OBJECTIVESIn this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:Work with functionsWork with listsAnalyze dataVisualize data with chartsUse PivotTables and PivotCharts
