|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-dashboards/
课程评论：没有评论
Coursera Excel 仪表盘基础入门课程 本课程专为Excel新手或对数据透视表（Pivot Tables）有初步了解的学习者设计。无论您是完全零基础还是已有少量经验，本课程都将帮助您掌握Excel处理数据的基本技能，并快速进行数据分析。 **核心内容：** * **理解原始數據結構：** 学习如何识别和处理原始数据。 * **创建基础数据透视表和图表：** 学习如何选择合适的行、列和值来构建数据透视表，并配合图表进行可视化展示。 * **利用数据透视表功能：** 掌握计算字段（Calculated Fields）、排序、筛选、分组等工具，以及如何汇总（求和、平均、计数等）数据透视表的值。 * **美化和定制数据透视表：** 学习修改数据透视表标题、表格格式等。 * **构建交互式仪表盘：** 学习创建切片器（Slicers）并将其连接到多个数据透视表，以实现仪表盘的交互性。 * **动态更新数据：** 掌握如何根据下拉菜单输入来更新数据透视表和图表。 * **设计精美仪表盘：** 学习如何设计专业美观的数据透视图表，并选择主题和其他元素来创建引人注目的仪表盘。 **课程特色：** * **实战导向：** 课程侧重于使用数据透视表、图表和切片器从零开始构建Excel仪表盘，适用于会议和演示。 * **提升职场技能：** 掌握Excel仪表盘制作是2023年雇主最看重的技能之一。 * **无需基础：** 无需Excel数据透视表或图表的预备知识。 * **兼容性：** 适用于Excel 2010及以上版本。 本课程将帮助您快速入门Excel仪表盘制作，并能将所学技能立即应用于实际工作中。
Using Excel: Basics of Excel Dashboards! and gain one of employer's most requested skills in 2023!This course is for everyone who is either completely new, or a beginner with pivots in excel. In this course, you'll learn the basics of Excel, how to work with raw data and carry out data analysis quickly using pivots.This course does not require any prior knowledge of Excel pivots tables or charts. You should be comfortable working with data and prior knowledge of Excel may prove in handy to understand some of the tools and functionalities taught in this course.This course is excellent to kickstart your path to becoming proficient in Excel, you'll learn all the basics to get you started and applying at your job right away!With the course you will learn how to use Excel dashboards for meeting and presentations using pivot tables, charts and slicers from scratch!Excel Dashboards are absolute essential for anyone working with large and complex datasets and want to present vital information in the most concise and visual mannerYou will be working with a lot of pivot tables as well as charts. Pivots allow you to quickly cut through the noise and deep dive into the datasets. Be it analyzing YoY growth rates, looking at market share trends, product profitability and so on - pivots allow to process large datasets and derive insights quicklyYou'll be learning when, how and why to use excel pivot tables as well as charts as part of your day to day analysis. You'll be learning the following-a. Understanding raw data structuresb. Building basic pivot tables and charts choosing relevant rows, column and valuesc. Using calculated fields d. Using sort, filter and grouping tools within pivotse. Summarize pivot table values by sum, average, count etc.e. Modifying Pivot tables - titles, table formattingf. Display outputs through pivot chartsg. Create slicers and connect them to multiple pivot tables to build interactivity into dashboardh. Learn how to update pivot tables and charts based on drop-down inputi. Learn how to design pivot charts, choose themes and other elements to create amazing looking dashboards!Whether you're looking to explore Excel Dashboards for the first time, or are looking to brush up your skills with hands- on exercises. You have come to the right place.This course is compatible on Excel 2010 or later.
