|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-in-30-minutes-worksheets-and-workbooks/
课程评论:没有评论
**课程名称:Excel in 30 Minutes: Worksheets and Workbooks** **课程概述:** 本课程旨在帮助学习者在30分钟内快速掌握Excel 2019或Excel 365中关于工作表和工作簿的管理技巧,从而轻松地查看和比较数据。在现代商业环境中,掌握Excel是一项极其实用且有价值的技能,对于提升业务效率和个人发展大有裨益。本课程是“30分钟精通Excel”系列课程之一。 **课程内容亮点:** * **工作表管理:** 学习如何添加、删除、重命名、重新排序、复制和为工作表添加颜色标记。 * **隐藏与取消隐藏工作表:** 掌握隐藏和显示工作表的技巧。 * **创建自定义视图:** 学会保存显示和打印设置,并轻松切换不同的视图。 * **冻结窗格:** 学习如何在使用滚动条滚动时保持标题行或首列可见。 * **拆分窗格:** 掌握使用拆分功能来同时查看同一工作表的不同部分,方便比较。 * **工作簿属性:** 了解如何查看和添加工作簿的属性信息,以跟踪重要数据。 **学习目标:** 完成本课程后,您将能够: * 熟练管理工作表,包括添加、删除、重命名、重新排序、复制和为工作表添加颜色标记。 * 创建自定义视图,保存并轻松切换显示和打印设置。 * 使用冻结窗格功能保持标题行或首列在滚动时可见,并利用拆分窗格功能比较工作表的不同部分。 * 轻松地在多个文件或工作表之间进行比较和切换。 * 查看和添加工作簿属性,以跟踪工作簿的相关信息。 **课程方式:** 本课程采用“独具匠心、引人入胜”的Bigger Brains师生互动教学风格,提供高质量高清内容。 **完成本系列课程的成就:** 完成“30分钟精通Excel”系列的所有课程,相当于完成了“Bigger Brains精通Excel 2019基础”课程。 **目录:** 无(本课程不提供详细的课程目录)
Learn to manage multiple worksheets and workbooks and easily view and compare data in Excel 2019or Excel 365-in under 30 minutes!When you master Excel, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our "Excel in 30 Minutes" series can help you get started. This course is one in a series of ten 30-minute courses. Topics covered include:Managing your worksheets by learning to add, remove, rename, reorder, copy, and color-code themHiding and unhiding sheetsCreating Custom Views to save display and print settings and easily switch between themKeeping header rows or initial columns visible when scrolling by using Freeze PanesUsing Split to display two different parts of the same worksheetTracking important information about a workbook by viewing and adding Workbook PropertiesTake the full series and you will have completed our "Bigger Brains Mastering Excel 2019-Basics" course. High-quality HD content in the "Uniquely Engaging" TMBigger Brains Teacher-Learner style!Objectives. You will be able to:Manage your worksheets including adding, removing, renaming, reordering, copying, and color-coding themCreate Custom Views to save display and print settings and easily switch between themKeep header rows or initial columns visible when scrolling by using Freeze Panes, and use Splitto to compare different sections of a worksheetEasily compare or switch between multiple files or sheetsTrack important information about a workbook by viewing and adding Workbook Properties