|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/tables-in-excel/
课程评论：没有评论
**课程名称：** Excel表格 (Excel Tables) **课程概述：** 尽管名称普通，Excel表格却是Excel中最被低估的功能之一。一旦将数据集转换为Excel表格，它就能获得一系列有助于简化数据处理的属性。本教程将涵盖使用Excel表格需要了解的全部要点，包括： * **创建Excel表格的多种方法** (包括使用VBA) * **使用Excel表格的十大优势** * **在Excel表格中使用VLOOKUP函数** * **在Excel表格中创建累计总计 (Running Total)** * **在Excel表格中自动编号行** * **连接Excel表格** **（无课程大纲）**
Maybe because of its' generic name, Excel Table is one of the most underused features of Excel.As soon as you convert a data set into an Excel Table, it will acquire a set of properties that will make that data easier to handle.In this Tutorial you will go through the essential things you need to know about the Table feature in Excel.Different methods to create Excel Table (including VBA)10 different advantages of using Excel TableHow to use VLOOKUP on Excel TablesHow to create Running Total using Excel TableHow to AutoNumber Rows using Excel TableHow to Connect Excel Tables
