|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-excel-pivot-tables/
课程评论：没有评论
课程名称：Microsoft Excel：使用Excel数据透视表进行数据分析 概述：Excel数据透视表是任何数据分析或商业智能工作者必备的工具。数据透视表可以帮助你快速探索和分析Excel中的原始数据，揭示隐藏在复杂数据中的强大见解和趋势。从产品销售到市场营销效果分析，或是过去10年公寓价格的变化，Excel数据透视表提供了快速、准确且直观的解决方案，帮助你解答各种复杂的数据分析问题。本课程将全面深入地讲解Excel数据透视表和数据透视图的使用。 课程内容将涵盖： - Excel原始数据结构 - 数据透视表布局和样式 - 设计和格式选项 - 排序、过滤和分组工具 - 计算字段、项目和数值 - 数据透视图、切片器和时间线 - 互动Excel仪表板 此外，课程还将基于多个实际案例研究，分析Excel数据集，包括： - 圣地亚哥的墨西哥卷饼评分 - 1900-2016年的鲨鱼攻击记录 - Spartan Race的Facebook帖子数据 - 大联盟棒球队统计 - 旧金山员工薪资 - 每日报市数据 - IMDb电影评分 - Apple Store移动应用评分 - 葡萄酒评分和描述 无论你是想快速掌握数据透视表的基础，还是希望提升你的Excel技能和分析能力，这门课程都非常适合你。在当今数据驱动的世界里，分析技能供不应求，能够将数据转化为见解的人正引领潮流。立即报名，开始你的Excel数据分析之旅吧！ 此外，课程还提供可下载的资源、Excel项目文件、作业和课程测验，终身访问以及30天退款保证。大部分讲座与Excel 2007、2010、2013、2016、2019或Office 365兼容。
Excel Pivot Tables are an absolutely essential tool for anyone working in data analytics or business intelligence.Pivot Tables 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 data 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 descriptionsWhether you're looking for a quick Excel Pivot Table primer, trying to diversify your MS Excel skill set, or hoping to step up your analytics or business intelligence game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!See you there!-Chris (Founder, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"-Monique C."Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"-Paul M."One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."-Ernie A.*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.
