|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-introduction-to-excel-online-pivot-tables-in-3-hrs/
课程评论：没有评论
课程名称：三小时全面介绍Excel在线数据透视表 课程概述：您是否在寻找一个能让您快速掌握Excel数据透视表的课程，而不浪费时间？这个课程正是为您量身定制的，内容清晰，循序渐进，帮助您打下坚实的基础，成为数据透视表的专家。使用Excel 365 Online，您将获得强大的数据透视表功能，能够迅速汇总和聚合数据。 关于课程：在当今商业环境中，数据分析、报告制作和仪表盘创建的技能极为重要。Excel作为全球最常用的数据分析工具，广泛应用于报告开发、数据分析和仪表盘制作。本课程将教您如何利用数据透视表在几秒钟内分析和汇总数据，数据透视表无疑是Microsoft Excel中最强大的功能之一。 您将在本课程中学习到： - 课程介绍及内容概述 - 创建数据透视表的方法 - 聚合方法，包括求和、平均值、最小值、最大值和计数 - 数据透视表的过滤和切片 - 趋势分析 - 创建互动销售仪表盘 - 高级计算，包括与前值的差、累计总和和排名 - 条件格式化 - 财务互动仪表盘 - Excel与Power BI的结合 * 课程材料和练习活动终身访问。 关于讲师：Ian Littlejohn是一位在Udemy平台上享有盛誉的讲师，拥有超过10年的培训与管理咨询经验。他专注于数据分析，涵盖Excel、Power BI、Google Data Studio和Amazon Quicksight。Ian拥有超过25万名学生，课程平均评分超过4.5，以提供结构清晰、易于理解的课程而闻名。 我们期待您参加我们的课程，一起学习和探索Excel数据透视表及数据透视图的强大功能。请注意，本课程是Excel大师课程系列中的第三门课程，您可以搜索我的讲师资料以购买其他课程。 课程1 - Excel Power Query全面介绍 课程2 - Excel Power Pivot全面介绍 课程3 - Excel互动仪表盘与数据分析
Looking for a course that will get you up and running with Excel Pivot Tables without wasting your time? Looking for a course that makes sense and builds your knowledge up in a logical fashion? That's exactly what this course delivers. Get the crucial foundation you need to become a Pivot Table expert, using Excel 365 Online.Microsoft 365 Online Excel provides you with access to the powerful Pivot Tables features that can summarize and aggregate your data in a few clicks of the mouse.ABOUT THE COURSESkills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.In this course you will learn the INCREDIBLE power of Pivot Tables to analyze and summarize data in seconds. Pivot Tables are without doubt the most powerful feature in Microsoft Excel. In this course you will cover:Introduction and Course ContentCreating Pivot TablesMethods of Aggregation including Sum, Average, Min, Max and CountFiltering and Slicing Pivot TablesTrend AnalysisCreate an Interactive Sales DashboardAdvanced Calculations including Difference From, Running Total and RankingConditional FormattingFinance Interactive DashboardExcel and Power BI* Life time access to course materials and practice activities. *ABOUT THE TRAINERIan Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.Ian has over 250,000 students and with an average course rating of over 4.5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.We look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.Please note that this course is the third course in a series of three courses for the Excel Master Class series. Search for my instructor profile to purchase these other courses.Course 1 - Complete Introduction to Excel Power QueryCourse 2 - Complete Introduction to Excel Power PivotCourse 3 - Excel Interactive Dashboards and Data Analysis
