|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-spreadsheet-shortcuts-in-ms-excel/
课程评论：没有评论
**课程名称：精通Excel电子表格快捷键** **课程概述：** 本课程专为会计专业人士设计，旨在帮助您掌握Microsoft Excel中的必备快捷键，从而更高效地工作，告别低效重复任务。课程涵盖所有Excel版本通用的实用快捷键，并教您如何创建自定义快捷键，让Excel真正为您所用。 **课程内容亮点：** * **鼠标操作技巧：** 学习何时何地使用双击或右击，发掘隐藏功能。 * **打印预览恢复：** 演示如何在Excel 2010及更高版本中恢复经典的打印预览界面。 * **单元格合并替代方案：** 探索比合并单元格更高效的替代方法。 * **文本朗读功能：** 学习如何让Excel朗读数字，便于核对。 * **工作表保护与解锁：** 掌握锁定和解锁工作表单元格的技巧，以及更高效的替代方案。 * **版本兼容性：** 课程内容涵盖Excel 2016、2013、2010和2007版本。 * **恢复隐藏功能：** 学习如何将在Excel 2007及更高版本中隐藏的“窗体”命令重新添加回来。 * **文件格式转换：** 轻松将Excel 2003文件转换为现代工作簿格式。 * **自定义快捷键：** 为Excel的“冻结窗格”功能创建键盘快捷键。 * **保存与兼容性：** 通过“兼容性检查器”将工作簿另存为.XLS文件。 * **高效筛选：** 通过基于单元格内容进行筛选，绕过筛选下拉列表，实现一键式操作。 * **格式转换：** 仅需两键即可将.XLS工作簿转换为最新的.XLSX格式。 * **快速访问：** 掌握快速访问本地或网络存储的文件夹和工作簿的技巧。 * **版本回溯：** 学习自动提供回溯位置的技术，以便在需要时查看早期版本的电子表格。 * **数据核对：** 通过Excel朗读数字，轻松复查手动输入的数据。 * **去除重复项：** 运用鼠标点击，快速从列表中删除重复项。 * **文本缩减提示：** 了解在页面上容纳更多文本时，文本如何被缩减。 * **表格功能：** 学习“表格”功能如何改变筛选任务。 * **导航大型工作簿：** 通过隐藏菜单和键盘快捷键，轻松导航大型工作簿。 * **简化重复操作：** 创建自定义键盘快捷键，简化重复性任务。 * **数据管理：** 学会通过筛选而非排序来处理长数据列表。
MASTERING SPREADSHEET SHORTCUTS IN MS EXCEL FOR ACCOUNTING PROFESSIONALSAre you working Excel or is it working you? Many users end up working harder than necessary in Excel carrying out repetitive tasks in an inefficient manner. In online course focuses on helpful shortcuts that can be used in all versions of Excel. The online course also covers many Excel keyboard shortcuts and even shows you how to create your own custom keyboard shortcuts.Course Content:when and where to double-click or right-click with your mouse to uncover hidden functionality,how to restore the classic print preview screen in Excel 2010 and later,an alternative to the merged cells feature, andhow to have Excel read numbers aloud to youlocking and unlocking worksheet cells, as well as alternatives that are more efficientmaterials cover Excel 2016, 2013, 2010, and 2007.add the hidden Form Command back to Excel 2007 and laterconverting Excel 2003 files to modern workbook formats with ease.creating a keyboard shortcut for Excel Freeze Panes featuresaving workbooks as.XLS files by dispatching the Compatibility Checkerbypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse clickconvert.XLS workbooks to the up-to-date.XLSX format with just two keystrokesdiscover how to quickly access folders and workbooks, regardless of whether they are stored on your computer or on a networkdiscover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheetdouble-check manual inputs easily by having Excel read numbers aloud to youeliminate duplicates from a list with just a few mouse clickskeep an eye on how much your text is being reduced as you try to squeeze more on a pagelearn how the Table feature allows you to transform filtering tasksnavigate large workbooks with ease by way of a hidden menu as well as keyboard shortcutsrestore classic Print Preview functionality in Excel 2007 and latersimplify repetitive tasks by creating your own keyboard shortcutswrangle long lists of data by filtering instead of sorting
