|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pivottables-from-slicers-to-dashboards/
课程评论：没有评论
**课程名称：** PivotTables: From Slicers to Dashboards ( összefoglalás angolul: PivotTables: From Slicers to Dashboards ) **课程概述：** 本课程将带您深入了解 **Excel 数据透视表** 的强大功能，从基础知识到高级应用。您将学会如何**快速、轻松地提取和分析数据**，并利用**切片器 (Slicers) 和时间线 (Timelines)** 等交互式工具实现数据的筛选和可视化。此外，课程还将指导您创建**交互式数据透视图 (PivotCharts)**，最终能够构建一个集多种关键信息于一体的**交互式数据仪表板 (Dashboard)**，实现“一目了然”的数据概览。 **学习内容亮点：** * **数据提取与分析：** 掌握使用数据透视表高效处理和分析数据的技巧。 * **交互式筛选：** 学习使用切片器和时间线对数据进行动态筛选，深入洞察。 * **动态可视化：** 创建交互式数据透视图，将数据以更直观的方式呈现。 * **仪表板构建：** 掌握将各类分析结果整合到单一交互式工作表中，构建专业的数据仪表板。 **学习体验：** * **实践驱动：** 每节课都配有相应的 Excel 演示文件和练习文件，方便您边学边练。 * **便捷下载：** 提供一个 ZIP 文件，集合了所有课程演示文件，方便一次性下载。 **重要提示：** * 本课程旨在展示最佳实践，但我们不承担因不当使用 Microsoft Excel 而产生的任何责任。 * Microsoft Office 软件会持续更新，部分新功能可能未及时覆盖。我们将尽力保持课程的更新，但您可能会遇到部分功能的变化。
Excel PivotTables have been around for a while, but it's only recently that the full power of PivotTables has been realised. Using PivotTables you can quickly and effortlessly extract and analyse your data in Excel. They are also interactive; you can filter data using ‘Slicers' and ‘Timelines', and from this data you can also create interactive ‘PivotCharts'.Ultimately, you can create a Dashboard, which is a single ‘interactive' worksheet that contains all your key information as a visual summary, ‘at a glance'.Each lesson in the course is accompanied by the Excel file used in the demonstration with step-by-step instructions, and also an Excel exercise for you to practise in your own time. Note that we have now also added a zip file under Lesson 1 to download all course demo files in one go.Disclaimer - although we have made every effort to ensure that the methods and techniques shown are Best Practice, we accept no liability for any costs that may be incurred as a result of incorrect use of Microsoft Excel. Microsoft Office is now continuously updated by Microsoft, with new features appearing at any time, sometimes unannounced; we shall endeavour to keep the course up to date, but you may find that some features have changed or are not yet covered on the course.
