|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-charts/
课程评论：没有评论
这门 Coursera 课程“创建专业商务图表”旨在帮助您掌握创建具有专业水准、能够生动展示数据并一眼洞察关键信息的商务图表。 课程将教会您15种核心的商务和财经图表，涵盖一般管理和高层决策所需。您将深入理解如何根据数据选择最合适的图表类型，应用最佳的样式，并有效地揭示信息，即使数据再复杂。课程提供按部就班的图表构建指导，以及优化图表格式和数据结构的实用技巧，让图表制作流程顺畅便捷。 课程强调超越标准的 Excel 图表输出，重点教授如何将图表及其底层数据打磨至可直接发布的专业商务水准。所有图表均提供可下载的、即用型、完全成型且可发布的资源。学成后，您将能够以完全相同的专业格式创建所有课程中涉及的图表。 通过动手实践的讲座，课程将探索每种图表的概览、应用场景以及具体构建方法。您将获得在商务和财经环境中如何使用这些图表（包括适配离散型和连续型数据，从类别划分、相对份额到相关性、评级、排名和聚合）的实践感。课程涵盖了柱状图、条形图等常用图表，也包括如何从零开始、无需任何插件在 Excel 中构建 Marimekko 图等较为少见的图表。 具体涵盖的图表包括： * 堆积柱状图 * 分组柱状图 * 条形图 * 条形/柱状图的子类别变体 * 数据的透视表图表变体 * 折线图 * 组合图 * 散点图 * 直方图（Excel 2016 前后版本） * 甜甜圈图 * 旭日图 * 瀑布图（Excel 2016 前后版本） * 气泡图 * 雷达图 * 梅科图 (Mekko Charts) * 热力图 * 以及劝阻大家使用饼图的讨论 :)
This course brings together everything you need to know to create professional business charts that make an impact, bring data to life, and reveal key insights at a glance.You will learn about the key business and finance charts you'll need for all general management and executive decision making. That's 15 charts in all, and you do not need to know any more unless you're a specialist! You will develop a deep understanding of how to select the right graph for the data, applying the best styles and revealing the most relevant insights, no matter how complex. With step-by-step guidance on how to construct each of the charts, along the way you'll uncover all the handy tips and tricks you'll need to format charts and structure the underlying data, making charting seamless and simple.We NEVER settle for the standard Excel chart output and ALWAYS demonstrate the important extra mile: how to structure and style your chart (and data) to a ready-to-publish business professional standard. Every chart is available as a downloadable resource, in a ready-to-go, fully formed and publishable format. You'll walk away from this course able to create each and every one of the charts in the exact same professional format. In the hands-on lectures, we explore both the overview / application and the construction of each graph / chart. You'll gain a practical sense of how each chart is used in a business and finance setting, fitting both discrete and continuous data, from category-based through relative share, as well as correlation, rating, ranking and aggregation. This includes mastering well-known charts like column and bar, and learning to build lesser-known charts like Marimekko from scratch in Excel with no plugins at all! We cover these charts:Stacked column chartsGrouped column chartsBar chartsSubcategory variations on bar / column chartsPivotChart variation on column chartsLine chartsCombo chartsScatterplotsHistograms (both prior and post Excel 2016)Doughnut chartsSunburst chartsWaterfall charts (both prior and post Excel 2016)Bubble chartsRadar chartsMekko chartsHeatmapsAn attempt to talk you out of pie charts:)
