|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-2019-intermediate/
课程评论：没有评论
Coursera 课程《精通 Excel 2019 - 中级》中文内容摘要： 本课程旨在帮助您熟练掌握世界上最受欢迎的数据组织和分析工具 Excel 2019。掌握 Excel 是一项极其实用且宝贵的现代商业技能。您将学习如何从组织列表、创建多层交互式报告，到解答投资回报率（ROI）、预算分配、费用跟踪等关键业务问题。 本课程是在您已有 Excel 基础知识之上，进一步教授您如何利用图表和表格高效管理数据，以及如何使用强大的报告工具，如数据透视表（Pivot Tables）、数据透视图（Pivot Charts）、切片器（Slicers）、时间线（Timelines）等。 课程内容包括： * 使用命名区域（Named Ranges） * 插入函数（Functions） * 应用高级排序和筛选技术（Advanced Sorting and Filtering Techniques） * 插入表格（Tables） * 应用高级条件格式（Advanced Conditional Formatting） * 插入图表和图形（Charts and Graphics） * 应用高级图表工具（Advanced Charting Tools） * 使用数据透视表、数据透视图、切片器和时间线（Pivot Tables, Pivot Charts, Slicers, and Timelines） 课程由微软认证培训师 Kathy Jones 教授，提供超过 5 小时的优质高清内容，采用 Bigger Brains 独具特色的“引人入胜”师生互动教学风格，帮助您将电子表格技能提升到新的水平，更高效地分析数据。如果您已熟悉 Excel 的基础操作，本课程将带您深入学习更高级的主题，解锁 Excel 的强大潜力。
Become proficient in using the world's most popular software tool for organizing and analyzing data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders-from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to efficiently manage data using charts and tables, and how to use powerful reporting tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.This is our most requested training course!As you learn to use Excel effectively, you will start to see how powerful it is in managing small or large datasets. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Kathy Jones walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.Topics covered include:Working with named rangesInserting functionsUsing advanced sorting and filtering techniquesInserting TablesApplying advanced Conditional FormattingInserting charts and graphicsApplying advanced charting toolsWorking with Pivot Tables, Pivot Charts, Slicers, and TimelinesOver five hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
