|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-microsoft-excel-pivot-tables/
课程评论：没有评论
**课程名称：使用 Microsoft Excel 数据透视表进行数据分析 (阿拉伯语)** **课程概述：** 本课程旨在为学习者提供对 Excel 数据透视表和数据透视图的全面深入的理解。数据透视表是 Excel 中处理数据的必备工具，能够帮助用户快速探索和分析原始数据，揭示其中隐藏的强大见解和趋势。无论是在分析产品销售、营销活动效果，还是追踪房地产市场趋势，数据透视表都能提供快速、准确且直观的解决方案。 **课程内容亮点：** * **基础知识：** 涵盖原始数据结构、数据透视表布局、样式、设计和格式选项。 * **高级功能：** 深入讲解排序、筛选、分组工具，以及计算字段、项目和值。 * **可视化与交互：** 学习创建数据透视图、切片器和时间线，并构建交互式 Excel 仪表板。 * **实战案例：** 通过一系列真实世界的数据集进行分析和探索，包括： * 圣地亚哥卷饼评分 * 1900-2016 年鲨鱼袭击记录 * Spartan Race 的 Facebook 帖子数据 * 美国职业棒球大联盟球队统计数据 * 旧金山员工薪资 * 每日股市数据 * IMDb 电影评分 * Apple Store 手机应用评分 * 葡萄酒评分和描述 本课程通过互动式演示和实际操作练习，确保学习者在整个学习过程中都能有所收获。
Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:Raw data structure in ExcelPivot Table layouts & stylesDesign & formatting optionsSorting, filtering, & grouping toolsCalculated fields, items & valuesPivot Charts, slicers & timelinesInteractive Excel dashboardsWe'll then explore and analyze Excel datasets from a number of real-world case studies, including:San Diego burrito ratingsShark attack records from 1900-2016Facebook Post data from Spartan RaceMajor League Baseball team statisticsSan Francisco employee salariesDaily stock market dataIMDb movie ratingsApple Store mobile app ratingsWine ratings and descriptions
