|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-shortcuts-for-2007-2010-2013-2016/
课程评论：没有评论
Microsoft Excel 键盘快捷键：全面指南 本课程名为“Microsoft Excel 键盘快捷键：全面指南”，旨在帮助学员通过一系列技巧、窍门和键盘快捷键，逐步精通 Microsoft Excel。课程由 Tolan 主讲，他也是 ProductivityMe 的联合创始人。 **课程亮点：** * **内容丰富：** 包含超过 250 个独立课程，并定期更新。 * **实用资源：** 提供一个动态的 Excel 文件，列出课程中使用的全部 233 个键盘快捷键，以及一份彩色 PDF 格式的参考指南。 * **高效学习：** 通过独特、有趣且易于理解的视频教程，学员可以在一周内成为 Excel 高手。 * **掌握核心技能：** 学习如何用秒级速度执行 Excel 的常见操作和功能，包括但不限于： * 自动求和与格式更改 * 添加、格式化和删除单元格边框 * 隐藏、分组、添加和删除列/行 * 单元格、工作表或工作簿的移动、复制和删除 * 扩展或缩减选区 * 创建表格、筛选器、图表和数据透视表 * 启动宏和 VBA 编辑器 * **课程结构清晰：** 每节课都遵循一致的结构：介绍 -> 演示快捷键 -> 无快捷键操作演示 -> 课程回顾 -> 下节课预告。 **课程目标：** Excel 已成为处理表格数据的行业标准，本课程旨在帮助您成为高效率的 Excel 用户，能够快速定位、分析和管理数据。学完本课程，您将能够熟练运用超过 230 个键盘快捷键，大大提升您的 Excel 操作效率。 **特别提示：** 课程提供与讲师的即时交流机会。 **讲师：** Tolan 和 Ryan (ProductivityMe 联合创始人)
A Brief Introduction to the Course Come. Watch. Learn. Conquer. Excel. One Simple Lesson at a Time.Hi and welcome! Hi and welcome! My name is Tolan, and I am the co-founder of ProductivityMe. I'd like to welcome you to Excel Keyboard Shortcuts, where through a series of awesome tips, tricks, and keyboard shortcuts you'll learn to Master Microsoft Excel, one simple lesson at a time. Through a comprehensive set of unique, fun, easy-to-follow video tutorials, you can learn to become a Microsoft Excel Power User in less than a week! What is Included in This Course?250+ individual lessonsRegular course updatesA dynamic, response Excel file listing all 233 keyboard shortcuts used in the courseA colored PDF reference guide of those 233 keyboard shortcutsInstant access to course instructor What is the Purpose of This Course? Excel has become the industry standard for organizing, analyzing, manipulating, a storing both data and information in tabular form. Thus, this course is designed to get you up and running as a highly-proficient Excel user by being able to use hundreds Excel's most common actions and functions in seconds. By the end of this course, you'll be able to use and deploy more than 230 keyboard shortcuts that will make you AWESOME at Microsoft Excel. For example, you'll learn shortcuts like: Shift + F11 Inserting a New Worksheet (Lesson 04.01)Ctrl + Shift + "=" Inserting Rows or Columns (Lesson 05.02 or Lesson 05.03)Shift + Spacebar Selecting an Entire Row (Lesson 07.01)Ctrl + Spacebar Selecting an Entire Column (Lesson 07.02)Ctrl + Enter Entering the Same Data in Multiple Cells (Lesson 11.06)Ctrl + Alt + V Displaying the Paste Special Dialog Box (Lesson 14.10)Ctrl + Shift + ~ Applying General Format (Lesson 17.01)Alt + = Autosumming Selected Cells (Lesson 18.04)Ctrl + ` Toggling Formulas On and Off (Lesson 18.05)F11 Creating a Chart in New Worksheet (Lesson 19.10)Alt + F8 Opening the Macro Dialog Box (Lesson 20.06)More generally, you'll be able to apply keyboard shortcuts for actions such as:Autosumming cell values & instantly changing their formattingAdding, formatting, and removing cell borders in a flashHiding, grouping, adding, deleting columns and rowsMoving to the next cell, worksheet, or workbookCopying, moving, or deleting a cell, a selection, or a worksheet in ExcelExpanding or reducing your active selection by one or more cells, columns, or rowsInstantly creating new tables, filters, charts, and PivotTablesLaunching macros & the VBA Editor with two simple clicksAnd much, much more In every lesson, we to follow the same logical structure.Consistent Lesson Structure: First, we'll provide an introduction to what we'll cover in the lessonThen we'll show you the keyboard shortcutNext we'll show you how to achieve the same result without using the specific shortcutThen. we'll review what we covered in the lessonAnd lastly, we'll discuss what is coming up in the next lesson Final Thoughts: ALRIGHT! The quality of our content speaks for itself. Come and check it out today!See you in a few. Cheers, Tolan & RyanCourse Instructors & ProductivityMe Co-Founders
