|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2016-intermediate/
课程评论：没有评论
课程名称：Excel 2016 中级 课程概述：本课程旨在提升学员对 Excel 2016 的中级使用能力。学员将学习如何链接工作簿和工作表、创建命名范围并在公式中使用这些范围、构建逻辑函数如 IF、AND 和 OR，并利用查找函数查找和比较数据。此外，课程还会介绍 Excel 的表格功能，教会学员创建和修改表格。学员将学习如何创建和修改数据透视表和数据透视图，以分析大型数据集，排序数据，并使用切片器和时间线切片器对数据进行筛选。 具体内容包括：创建和修改图表、使用闪填功能、处理小计和大纲，以及定制 Excel 环境。Intellezy 提供近 10,000 个关于桌面应用、技术概念和商业技能的培训视频，涵盖数百门课程，帮助您和您的团队保持竞争力，提升技能。我们的培训视频不仅富有吸引力，还包含评估工具，可用于课程前后测试知识水平。我们的内容也会定期更新，以确保您获取最新软件信息和技巧。 本课程符合 CAP 知识体系，并有望获得 4 个 recertification 认证积分，适用于技术与信息分发内容领域。完成课程后，请发送完成证明至 info@intellezy.com 以获取证书。
This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, create named ranges and utilize them in formulas, build Logical functions such as IF, AND, and OR, and use Lookup functions to locate and compare data. Students will also be introduced to and work with Excel's Table feature, learning to create and modify Tables. Students will also create and modify PivotTables and PivotCharts to analyze large data sets, sort the data, and use Slicers and Timeline Slicers to filter the data. Additionally, students will create and modify Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.This course aligns with the CAP Body of Knowledge and should be approved for 4 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
