|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-dashboard-masterclass-for-beginners-from-zero-to-hero/
课程评论：没有评论
**课程名称：** Excel仪表盘大师课 - 从零到英雄 (Excel Dashboard Masterclass - From Zero to Hero) **课程概述：** 本课程适合所有希望从基础入门，学习如何创建强大交互式Excel仪表盘的用户。您将学会如何将Excel数据转化为强大的表格、图表、可视化元素以及最终的仪表盘。 **课程亮点：** * 通过实践视频教程和丰富的可下载资源学习。 * 理解数据可视化和仪表盘构建的目标。 * 学习条件格式的入门知识及其在仪表盘构建中的关键应用。 * 回顾IF、AND、OR等Excel逻辑函数，并学习如何在仪表盘中使用它们。 * 从构建柱状图、条形图、饼图和折线图开始展示您的数据。 * 学习更复杂的图表，如散点图和组合图，以用于数据可视化和决策。 * 利用MATCH() 和 INDEX() 函数使您的仪表盘更具交互性。 * 在仪表盘中运用数据透视表，增加更多交互功能。 * 从零开始，学习仪表盘创建的艺术，将庞杂的数据以更有意义的形式呈现。 **立即加入课程，将您的Excel技能提升到一个新的水平！**
This course is for all Excel users who wish to learn how to create powerful interactive dashboards right from the Basics to putting everything together. This course will teach you to turn your Excel data into powerful tables, graphs, visuals and dashboards.Highlights:• Learn from Practical Video tutorials and ample of downloadable resources. • Understand the goals of data visualization and dashboard building. • Learn the basics of conditional formatting and the key aspects of it for dashboard building. • Review the Excel logic functions like IF, AND, OR and using them in your dashboards, • Start by building bar charts, column charts, pie charts and line charts to display your data.• Learn more complex charts like scatter plots, combination charts for data visualization and decision making. • Make your dashboards more interactive with the MATCH () and INDEX () functions.• Leverage pivot tables within your dashboard to add even more interactivity.• All in all learn the art of dashboard creation right from scratch to show off your large cumbersome data in a more meaningful form.So What are you waiting for ? Jump right into the course and Take your Excel Skills to a whole new level.
