|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/secrets-of-excel-data-visualization-excel-chart-graphs/
课程评论：没有评论
**Excel图表课程：从基础到高级** 本课程将带您深入探索Excel数据可视化技术，助您成为数据可视化专家。您将学习如何利用Excel强大的内置功能创建多达20余种令人惊艳的图表，并掌握7种以上的进阶自定义技巧，为您的报告增添专业色彩。课程强调，许多人忽视了Excel本身强大的图表制作能力，而倾向于购买昂贵的高级工具。本课程将详细讲解何时、为何以及如何有效地使用Excel图表，并涵盖以下关键图表类型： * **基础图表:** 条形图、柱形图、折线图、面积图、饼图、圆环图、散点图、气泡图。 * **特定版本支持图表:** 直方图、帕累托图 (Office 365, Excel 2016/2019), 箱型图 (Office 365, Excel 2016/2019), 树状图、旭日图 (Office 365, Excel 2016/2019), 瀑布图、漏斗图 (Office 365, Excel 2016/2019)。 * **其他图表:** 雷达图、股票图、热力图、3D曲面图、等高线图、分块图、地理空间地图、自定义组合图、迷你图等。 在掌握基础图表后，课程将进一步深入高级Excel数据分析工具。您将学习： * **高级图表自定义:** 使用图片叠加自定义柱形图，利用OFFSET和COUNTA函数实现图表自动更新。 * **交互式图表:** 为图表添加滚动条和缩放功能，以展示特定时间段的数据；实现图表动画效果。 * **仪表盘技巧:** 学习如何更改图表形状，使用选项框或复选框增强仪表盘的交互性。 * **分类图表格式化** * **数据透视表图表** * **进度条和仪表图 (Pacing and Gauge Charts)** * **网格线图表 (GRID Charts)** 无论您是初学者还是经验丰富的用户，本课程都将为您提供前所未有的实用技巧。本课程致力于帮助您创建专业的报告、仪表盘和摘要，提升您的数据呈现能力。
Explore Excel Data Visualization Techniques which can make you a data viz expert. Once you complete this course, I can guarantee that you will not look for other Data Viz tools because everybody these days thinking to buy some advanced tools to create awesome data visualization or creating advanced level charts/graphs. However most of the people are unaware that they can create advanced level charts in Microsoft Excel itself because this is widely used and everybody has access to spreadsheets. Am I right? So lets explore 20+ amazing Excel Data visualization along with 7+ advanced level customization to create awesome effect on your reports. In this course, I am going to talk Why, When, How we should be using Excel Graphs and Charts and need of these by explaining every single details.Lets explore these Excel Charts and Techniques to create professional reports, dashboards, summary. This course covers:Bar & Column chartsHistograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)Line charts & trend linesArea chartsPies & DonutsScatter plots & Bubble chartsBox & Whisker charts (Office 365, Excel 2016 or Excel 2019)Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)Radar & Stock chartsHeat maps, 3-D Surface & contour chartsChoropleths & Geospatial mapsCustom combo charts & graphsSparklineAnd many more...Once you understand the basic about these given charts, then we will do a deep dive by covering advanced excel data analysis tools. Also explore practice papers to get trained on these visualization. Next Deep dive in this course includes:Customizing Column Charts with Image overlayUpdating Charts automatically with Offset and CountA functionsEnabling Scroll and Zoom Controls on the Chart to show specific periodsEnabling animations on the ChartUsage of various dashboarding tricks i.e. Changing shapes on the chart, using option boxes or checkboxesCategorical Chart FormattingPivot ChartsPacing and Gauage Chart to show the progressGRID ChartsWhether you are a beginner or expert, you will find amazing tricks which you would not have heard before. I am sure that this journey will be amazing. Lets get startedBest Wishes
