|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2019-data-visualization-with-charts-and-dashboards/
课程评论：没有评论
**课程名称：** Excel 2019 - 使用图表和仪表板进行数据可视化 **课程概述：** 本课程旨在帮助学习者超越传统的电子表格思维，深入掌握Microsoft Excel 2019及其最新版本（Office 365, Excel 2016）强大的数据可视化工具和技巧。课程将全面讲解Excel中超过20种图表类型，包括条形图、柱形图、直方图、帕累托图、折线图、面积图、饼图、圆环图、散点图、气泡图、箱型图、树状图、旭日图、瀑布图、漏斗图、雷达图、股价图、热力图、三维曲面图、等高线图、分级统计图、地理空间图、自定义组合图表以及迷你图等，并解释它们适用的场景、原因和具体使用方法。 课程还将教授一系列高级数据可视化技术，如自定义图像叠加图、利用命名范围和 OFFSET/COUNTA 函数实现自动化、使用Excel窗体控件实现滚动和缩放功能、制作动态图表以可视化时间变化、构建动态自定义Excel仪表板、实现基于值的图表格式化、创建自定义仪表图和进度图，以及利用Excel数组公式创建网格视觉效果。 本课程适合所有希望提升Excel数据可视化技能的学习者，无论您是初学者寻求快速入门，还是希望拓展Excel技能广度，亦或是想要大幅提升Excel数据可视化专业水平。 **课程特色：** * **全面深入：** 100%涵盖Excel 2019及更新版本的数据可视化功能。 * **实践导向：** 提供互动式、动手操作的演示和练习。 * **最佳实践：** 教授数据可视化的关键最佳实践。 * **高级主题：** 独家讲解高级数据可视化技术。 * **资源丰富：** 提供可下载的资源和Excel项目文件，助力学习。 * **支持与保证：** 包含作业、课程测验、终身访问权限和30天退款保证。 **兼容性：** 大多数讲课内容兼容 Excel 2016, Excel 2019 或 Office 365。
DescriptionFULL COURSE DESCRIPTION:Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts - and I'm here to prove it.This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.__________We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2019, including: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 chartsChloropleths & Geospatial mapsCustom combo charts & graphsSparklinesAnd more...__________We'll cover advanced Excel data viz topics that you won't find anywhere else, including:Custom image overlay chartsAutomation with named ranges and OFFSET/COUNTA functionsScroll & Zoom functionality with Excel form controlsAnimated charts to visualize changes over timeDynamic, custom Excel dashboardsValue-based chart formattingCustom gauge charts & pacing chartsGrid visuals using Excel array formulasWhether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.See you there!-Srinivas Reddy (Founder, Excel Map)__________*NOTE: 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 2016, Excel 2019 or Office 365.
