|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-excel-charts-graphs/
课程评论：没有评论
**课程名称：Microsoft Excel 数据可视化：图表与图形精通** **课程概览：** 本课程旨在提供对 Microsoft Excel 最新数据可视化工具和技术的全面深入的理解，帮助学员跳出传统行列式思维，体验 Excel 作为强大动态数据可视化平台的潜力。课程将详细讲解何时、为何以及如何使用 Excel 中的每一种图表类型，介绍关键的数据可视化最佳实践，并通过一系列互动式实操演示和练习，引导学员逐步掌握。 课程内容涵盖： * **Excel 20+ 种图表与图形探索：** * 条形图与柱形图 * 直方图与帕累托图 (Office 365, Excel 2016 或 Excel 2019) * 折线图、面积图与趋势线 * 饼图与甜甜圈图 * 散点图与气泡图 * 箱形图 (Office 365, Excel 2016 或 Excel 2019) * 树状图与旭日图 (Office 365, Excel 2016 或 Excel 2019) * 瀑布图与漏斗图 (Office 365, Excel 2016 或 Excel 2019) * 雷达图与股票图 * 热力图、3D 表面图和等高线图 * 分级统计地图与地理空间地图 * 自定义组合图 * 迷你图 * **高级 Excel 数据可视化实战：** * 基于实际获奖作品改编的项目和仪表板演示，这些作品来自微软、麻省理工学院和纽约时报。 * **独家高级主题：** * 自定义图像覆盖图 * 使用命名范围和 OFFSET/COUNTA 函数实现自动化 * 通过 Excel 表单控件实现滚动与缩放功能 * 制作动画图表以可视化随时间变化的数据 * 构建动态自定义 Excel 仪表板 * 实现基于数值的图表格式化 * 创建自定义仪表图与进度图 * 利用 Excel 数组公式创建网格视觉效果 **课程目标：** 无论您是想快速入门、拓展 Excel 技能，还是希望大幅提升 Excel 数据可视化和商业智能能力，本课程都将满足您的需求。 **讲师：** Chris (Founder, Maven Analytics) **学员评价亮点：** * “非常棒的内容。我真的很享受！Chris 真是 Excel 大师。我强烈推荐这门课程给所有想提升 Excel 图表和图形技能的用户。” - Nirav M. * “从头到尾都非常出色！我学到了一些能在工作中用到的 Excel 数据可视化技巧，包括一些非常酷的高级 Excel 可视化和自定义图表。非常喜欢，希望能从这位优秀的讲师那里学到更多！” - Robert C. * “一开始我就惊叹于 Excel 的能力，然后被讲师的操作折服，现在我感觉自己也能做到。我肯定会购买他其他的 Excel 和数据可视化课程！” - Judit B. **重要提示：** * 完整课程包含可下载资源和 Excel 项目文件、作业和课程测验、终身访问权限以及 30 天退款保证。 * 大部分课程内容兼容 Excel 2016、Excel 2019 或 Office 365。 （搜索“Maven Analytics”可浏览更多 Excel、Power BI、SQL、Tableau、Python、Alteryx 和机器学习课程。）
Microsoft Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and spreadsheets, and I'm here to prove it.This course gives you a deep, 100% comprehensive understanding of MS 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 in Excel, including: Bar & Column chartsHistograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)Line charts, Area charts & trend linesPies & 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 ChartsSparklinesFrom there we'll dive into a series of advanced Excel demos guaranteed to turn you into an absolute data visualization and analytics rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects and dashboards adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times.We'll cover advanced Excel data visualization 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 or business intelligence game in a major way, this course is for you.See you there!-Chris (Founder, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."Nirav M."Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"Robert C."At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"Judit B.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.
