|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-pivot-tables-for-beginners-in-animation/
课程评论：没有评论
课程名称：微软Excel：数据透视表与分析 - 初学者到专业人士 课程概述： 数据透视表是Excel中最受欢迎的功能之一，尤其在工作环境中被广泛使用。本课程将深入讲解数据透视表的多种应用，帮助学员掌握该技能。课程内容包括但不限于： - 从简单数据集插入数据透视表 - 插入字段并自定义数据透视表的形状 - 了解不同视图并调整视图方式 - 移动数据透视表 - 插入与管理时间线 - 插入与管理切片器 - 在Excel中对数据进行分组 - 对数据进行筛选 数据透视表在许多工作任务中至关重要，但在处理复杂数据时可能会耗时较长。 YourExcelGuy是首个提供动画视频教学平台，专注于Excel技能的培训。我们汇集了100多段教学视频，涵盖从初学者到高级用户的各类Excel技能，包括数据转换、图形、条件格式、数据表、数据透视表、仪表盘以及VBA宏等。 讲师简介： 讲师是一位微软认证的Excel专家，专职Excel教练，热爱教学工作。目前已培训超过50000名学生，拥有4年以上的培训经验和11年以上的Excel日常使用经验，积累了丰富的Excel技巧。
PIVOT TABLES are the most sought out feature of Excel and is often used at work environment.In this course you will learn a lot about Pivot Tables.You'll get to learn about the below scenarios:Inserting a Pivot table from a simple datasetInserting Fields and giving a shape to Pivot TableChanging Views and understanding Views for different dataMoving Pivot TablesInserting and Managing TimelinesInserting and Managing SlicersGrouping Data on ExcelFiltering Data on ExcelPivot Tables has been critical for most of the tasks at work. However it had its disadvantages and is often time consuming if the data is complex.YourExcelGuy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine - whether it's for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.About the Instructor: I'm a Microsoft Certified Excel Expert and a full time Excel coach, I train people on Excel and that's something I really love doing. Currently I have trained over 50000+ students. With over 4 years of training experience and 11+ years of using Excel every single day I've learnt a lot of tricks in excel
