|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-excel-shortcut-guide/
课程评论：没有评论
**课程名称：** Ultimate Excel Shortcut Guide Become a Power User in Days! **课程概述：** 本课程是Infinite Skills提供的Microsoft Excel快捷键指南培训。它将带领学员深入Excel，学习大量实用的快捷操作。本课程适合已有Excel基础知识的用户。课程内容涵盖： * 基础快捷键，如为Excel对象添加超链接和使用填充柄进行快速数据填充。 * Excel界面快捷键，快速在工作簿和工作表之间切换，以及创建和使用自定义视图。 * 日期和时间处理的快捷键。 * 数据和公式处理的快捷键。 * 创建图表和数据透视表的快捷键，包括在公式中引用数据透视表数值以及将单个数据透视表拆分到不同工作表。 完成本视频课程后，学员将能熟练运用Excel的众多快捷键。课程包含练习文件，方便学员跟随讲师同步学习。
This Microsoft Excel - Shortcut Guide training course from Infinite Skills takes you beyond the basics of Excel, showing you numerous useful shortcuts within this spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by learning simple shortcuts, such as adding hyperlinks to Excel objects and using the fill handle for quick data patterns. You will then jump into learning Excel interface shortcuts, how to move swiftly between workbooks and worksheets, and creating and using custom views. Guy proceeds to teach you how to work with dates and times, as well as working with data and formula. Finally, this video tutorial will show you shortcuts for creating charts and pivot tables, including referencing a pivot table value in a formula and separating worksheets from a single pivot table. By the completion of this video based training course, you will be comfortable with using many of these shortcuts in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
