|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pivottable-master-in-less-than-1-hour/
课程评论：没有评论
课程名称：从初学者到数据透视表大师 - Excel中的最佳工具 概述：自2016年1月以来已有1500多名学员注册！这是Udemy上增长最快的课程之一！在当今的就业市场中，Excel的熟练使用是必不可少的。不仅要流利地使用Excel，还要将其灵活地应用于日常工作中，越来越多的雇主对Excel的熟练程度提出了要求，但实际工作中缺乏相关培训。 提示：想提升简历吗？成为微软认证的Excel专家！这门课程是获得认证的第一步，将为你在这一核心领域做好准备，并帮助你走上获得最有价值的专业认证的道路！Excel 2010认证考试由微软学习提供，考试编号为 #77-882。请查看推广视频获取链接！ 课程内容涵盖了众多学习方式，但许多方式缺乏所需的实际应用能力。你需要能够将工作中使用的数据集转化为用户友好的、易于分析的报告，使你的老板甚至高层领导能够阅读并据此做出实时决策。如今的行业比以往任何时候都更加依赖数据，你会成为那个闪光的人吗？ 这门全面的PivotTable课程将为你提供一步步的指南，让你能够开发和使用数据透视表。课程设计适合从基础初学者到有经验的用户，确保你能够学习到的宝贵知识和技能，立即可以应用于工作。这些是Excel中最重要的工具，所有的分析都源于数据透视表。简而言之，它们是基本用户的总结工具，但经过高手的开发，它们可以真正影响公司的决策！ 通过本课程，结束后你不仅能熟练掌握Excel数据透视表，还能掌握开发和实施强大实时报告的技能，令你的老板甚至高管印象深刻！ 课程内容包括： - 将数据格式化为表格 - 优化工作簿 - 使用逻辑函数提取信息 - 应用筛选和排序 - 创建多个数据透视表 - 应用数据透视表样式 - 深入分析细节 - 展示销售数据 - 使用高级公式（例如GetPivotData、IfError、Left & Right） - 操作和配置实时决策数据 - 刷新数据透视表 - 修复常见错误 - 创建数据透视图 - 高级数据透视图格式化 - 构建和使用数据透视图仪表板 掌握数据透视表是掌握Excel的巨大飞跃，这就是你的解决方案！
Over 1500+ enrolled since January 2016! One of Udemy's fastest growing courses!In today's job market Excel proficiency is required. The ability to not only fluently use Excel but implement it into the daily routine is increasingly mandatory. A majority of employers requires Excel proficiency but lack any real on-the-job training in this software.Pro tip: Want to improve your Resume? Become a Microsoft Certified Excel Specialist! This course is the first step towards becoming certified! It will prepare you in a core aspect of the certification and set you on the path towards one of the most valuable Professional Certifications you can earn!Excel 2010 Certification Exam Offered via Microsoft Learning Exam #77-882See Promo Video for Link!There are numerous ways to learn, yet many lack the real world application you desire. You need to be able to take data sets your job uses and turn them into user-friendly, easy-to-analyze reports that your boss and even his bosses can read to use to make real-time decisions. Today's industries are more data driven than ever; will you be the one to shine?This is comprehensive PivotTable course will provide you with a step-by-step guide into developing and using PivotTables. It is designed in a way that even the most basic beginner to an experienced user can follow along and take away valuable knowledge and skills you can immediately apply to your job. These are Excel's most important tools. Quite literally, all analysis stems from PivotTables. In short, they are a summarizing tool to the basic user. But developed by an ace, they can literally shape the decisions a company makes!By the end of this course you will be able to not only be well versed in Excel PivotTables, but empowered with the skills to develop and implement powerful, real-time reports your bosses, even executives would be impressed with!This course covers:Formatting data as a tableOptimizing your WorkbookUsing logic functions to extract informationApplying filters and sortsCreating multiple PivotTablesApplying PivotTable StylesDrilling down detailsPresenting sales dataUsing Advanced FormulasGetPivotDataIfErrorLeft & RightManipulating and configuring data for real-time decision makingRefreshing you PivotTablesFixing Common ErrorsCreating PivotChartsAdvanced PivotChart FormattingBuilding & Using PivotChart DashboardsMastering PivotTables is a massive leap forward to mastering Excel, this is the solution!
