|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/interactive-excel-dashboards/
课程评论：没有评论
《交互式Excel仪表板》是一门由Microsoft Excel资深培训专家教授的进阶课程，旨在帮助学员从零开始创建具有视觉吸引力且功能高度交互的Excel仪表板。 **课程亮点：** * **实操项目：** 包含两个完整的跟学仪表板项目——销售仪表板和人力资源仪表板，让您学以致用。 * **交互性设计：** 教授创建能够根据用户选择动态更新数据的交互式仪表板。 * **高效更新：** 学习如何在几秒钟内用新数据快速更新您的仪表板。 * **实用技能：** 涵盖仪表板架构、数据准备与清理、常用Excel公式、数据透视表和数据透视图、高级图表技术以及交互式控件（窗体控件）的应用。 * **海量内容：** 提供超过9小时的视频教程，包含70多个独立视频讲座，并配有练习文件，助您充分掌握各项技能。 * **广泛兼容：** 课程使用Excel 365录制，但也适用于Excel 2019、2016和2013等近期版本。 **课程涵盖主题：** * 仪表板架构与灵感来源 * 数据准备与清洗 * 创建仪表板的实用Excel公式 * 数据透视表与数据透视图的创建与编辑 * 高级图表技术 * 添加交互式控件 * 从零开始创建销售仪表板 * 从零开始创建人力资源仪表板 本课程是为那些希望提升Excel数据分析与可视化能力，并能创建令人印象深刻的动态报告的学员而设计的。学员好评如潮，称赞讲师的教学方式清晰易懂，内容实用，能够立即应用于工作，节省大量时间。课程结束后，您将获得结业证书。
**Includes exercises and two, follow-along Dashboard Projects**Have you ever looked at an interactive dashboard in Excel and thought "I wish I could create something like that!". Well, now you can. We've drawn on our years of expertise as a Microsoft Excel training provider and have put together the ultimate Excel dashboards course.We'll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.Once we've taught you all the techniques you need to create your dashboards we end the course with two, super projects:Creating a fully interactive Sales Dashboard from scratchCreating a fully interactive HR Dashboard from scratchIn this course you will learn:About Dashboard architecture and inspirationHow to prepare data for analysis (cleaning data)Useful formulas for creating dashboards in ExcelHow to create and edit Pivot Tables in ExcelHow to create Pivot Charts from Pivot TablesAdvanced chart techniques in ExcelHow to add interactive elements (form controls) into your dashboardsHow to create a Sales Dashboard from scratchHow to create an HR Dashboard from scratchThis course includes:9+ hours of video tutorials70+ individual video lecturesExercise files to practice what you learnedCertificate of completionThis course was recorded using Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2019, 2016, and 2013.Here's what our students are saying…"The instructor has a nice way of teaching - I really need this skill for my job. I am pretty sure I can learn it! Very happy with the instruction style so far."- Irma"I liked her teaching, once trained skipped over simple items and didn't waste our time with repeating it. Dashboard courses I have taken two already and I always pick up new things - here spark lines. Thank You"- Duane"Clear, concise, easy to follow. It is 'early days' for the rating, but I have no doubt I'll enjoy the remainder of the course. Best of all, I'm learning things that I can use at work tomorrow, and it will save me LOTS of time."- Robert
