|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excelmappivots/
课程评论：没有评论
课程名称：MS Excel 2019 - 数据分析与数据透视表和图表 课程概述：本课程被评为Udemy上最佳的数据透视表与图表Excel课程，由微软认证培训师创建。数据透视表是任何在Excel中处理数据的人必备的工具，它能快速探索和分析原始数据，揭示强大的洞察力和趋势，帮助你寻找答案。不论是探索产品销售，还是分析最有效的营销策略，Excel的数据透视表都能提供快速、准确且直观的解决方案，即使是最复杂的分析问题。 课程内容涵盖Excel数据透视表和数据透视图的全面理解，介绍使用数据透视表的时机、原因以及方法，提供高级排序、过滤和计算工具，通过互动的实际演示和Excel练习进行学习。 课程将从以下几个方面入手： - Excel中的原始数据结构 - 数据透视表的布局和样式 - 设计与格式选项 - 排序、过滤和分组工具 - 计算字段、项目和值 - 数据透视图、切片器和时间轴 - 互动Excel仪表板 - 在Excel中编写公式 注意：课程包括可下载的资源和Excel项目文件、家庭作业和课程测验，终身访问权限以及30天退款保证。大部分讲座适用于Excel 2007、2010、2013、2016、2019或Office 365版本。 学习目标： - 将数据分析技能从零提升到专业水平，掌握Excel数据透视表 - 学会利用数据透视表和数据透视图简化、革新Excel工作流程 - 掌握独特的数据透视表技巧、工具和案例，确保所学内容在其他课程中无法找到 - 获取项目文件、测验和家庭作业的终身访问权 - 通过多个实例测试自己的技能 课程要求： - 需具备Microsoft Excel 2010、2013、2016、2019或Office 365 - 有基本的Excel功能经验（了解图表和公式者尤佳） 适合人群： - 定期使用Excel的任何人（即使没有使用过数据透视表） - 有基本技能的Excel用户，希望在数据探索和分析方面提高效率 - 寻求全面、有趣且高度互动的培训方式的学生 - 有意追求数据分析或商业智能职业的人士
In the Udemy this is the Best Excel Course for Pivot Tables & Pivot Charts Created by Microsoft Certified Trainer.FULL COURSE DESCRIPTION: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. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates. 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 dashboardsWriting formulas in ExcelNOTE: 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.What you'll learn in this Course?Take your data analysis skills from ZERO to PRO with Excel Pivot TablesLearn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in ExcelMaster unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteedBest Pivot table Course by Certified TrainerGet LIFETIME access to project files, quizzes, homework exercisesTest your skills with multiple ExamplesAre there any course requirements or prerequisites?Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365Basic experience with Excel functionality (charts & formulas a plus!)Who this course is for:ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!)Excel users who have basic skills but would like to become more proficient in data exploration and analysisStudents looking for a comprehensive, engaging, and highly interactive approach to trainingAnyone looking to pursue a career in data analysis or business intelligence
