|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-analysis-with-pivot-tables/
课程评论：没有评论
**课程名称：Excel：数据透视表数据分析** **课程概述：** 本课程将帮助您掌握Excel中强大的数据透视表工具，从大量数据中提取有价值的见解。您将学会如何创建、格式化和操作数据透视表，以便有效地汇总、可视化和制表您的数据。此外，课程还将涵盖连接外部数据源、整合多表数据、创建自定义字段、格式化以及高级筛选等重要功能。 **适合人群：** * 需要存储和报告数据的Excel用户 * 希望更有效地处理Excel数据的进阶和中级用户 **课程内容重点：** * 准备数据并创建数据透视表 * 处理本地和外部数据源 * 创建表之间的关系 * 汇总、组织、筛选和格式化数据透视表 * 刷新和更改数据透视表数据 * 创建和修改数据透视图 **您将能够：** * 从本地单数据源、本地多数据源以及外部数据源创建数据透视表 * 有效地组织、排序和筛选数据透视表中的数据 * 灵活地更改数据透视表的格式和选项 * 创建和美化数据透视图 **教学风格：** 本课程采用“独特引人入胜”的Bigger Brains师生互动式教学风格，内容为获奖高清视频，由Microsoft认证的资深培训师Kathy Jones授课。课程设计围绕关键学习目标，并提供可下载的讲义，确保您能以最高效的方式掌握知识。
Excel - Data Analysis with PivotTablesSubHead: Get actionable insight from your data with Excel's popular power toolGet more from Excel using the power of PivotTablesPivotTables are the perfect tool to analyze large amounts of data in Excel. The ability to summarize, visualize, and tabulate your data makes PivotTables an important option for Excel users who need to store and report on data. You will learn how to create, format and manipulate PivotTables and PivotCharts so you can easily get the actionable results you need from your data.You'll also learn how to connect to external data and create PivotTables from multiple tables. Custom fields, formatting, and advanced filtering options are also important features covered in this course. Taught by Microsoft certified trainer Kathy Jones, Excel - Data Analysis with PivotTables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts.Topics covered include:Preparing data and creating PivotTablesWorking with local and external data sourcesCreating relationships between tablesSummarizing, organizing, filtering, and formatting PivotTablesRefreshing and changing PivotTable dataCreating PivotChartsEnjoy award-winning HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and downloadable handouts.You will be able to:Create a PivotTable from a local data source, multiple local data sources, and external sourcesOrganize data within a PivotTableSort and filter dataChange PivotTable formattingModify PivotTable optionsCreate and modify a PivotChart
