|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-tables-deep-drive/
课程评论：没有评论
**课程名称：Microsoft Excel - 表格深度解析** **课程概述：** 本课程由Infinite Skills提供，旨在帮助已有Excel基础知识的用户深入掌握Excel表格的创建与使用。课程内容涵盖： * **表格基础：** 数据准备、表格创建与命名、表格转范围。 * **表格记录管理：** 添加与删除记录、数据录入窗体、排序与筛选。 * **表格格式化：** 修改与创建自定义及默认表格样式。 * **表格计算：** 计算列创建、结构化引用、表格行操作。 * **表格工具：** 表格移动、删除重复项、从表格创建图表。 完成本课程后，您将能够熟练创建、使用、修改和自定义Excel表格。课程包含配套练习文件，方便学员同步学习。
This Microsoft Excel - Tables Deep Dive training course from Infinite Skills takes you beyond the basics of Excel, diving deep into creating and using tables in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start out by the learning the basics of Excel tables, such as how to prepare data for tables, creating and naming tables, and converting tables back to ranges. From there, you will move into working with table records, including how to add and delete records, use the data entry form, and sort and filter table records. Erin will teach you how to format tables and modify and create custom and default table styles. This video tutorial will also teach you table calculations, including how to create calculated columns, understand structured references, and work with table rows. Finally, you will learn how to work with table tools, such as moving tables, removing duplicates, and how to create charts from tables. By the completion of this computer based training course, you will be fully capable of creating, using, modifying, and customizing tables in Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
