|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-data-visualization
课程评论：没有评论
课程名称：Excel中的数据可视化 课程概述：在这个由“大数据”驱动的时代，我们需要通过数据可视化来快速传达关键信息，使其易于理解并便于采取行动。数据可视化是一项日益重要的技能，它不仅需要以易于理解和具有吸引力的方式呈现数据，还要为数据提供上下文和讲述故事，以达到形式与功能的完美平衡。虽然Excel在这个领域面临许多竞争者，但仍然是一个优秀的选择，特别是当您的数据存储在Excel中时。Excel提供了丰富的可视化工具，我们将探索如何利用这些工具展示环境数据集的趋势、预测、细分和比较。 课程目标：通过五周的学习，我们将利用实用案例，帮助环境分析师Rohan创建数据可视化。Rohan需要利用条件格式、迷你图、专业图表及自定义图表等工具，来讲述数据故事并准备数据，制作出具有专业水准的报表和仪表板。 课程内容： 第1周：使用条件格式、迷你图和宏创建动态可视化 第2周：讲述故事的图表技术 第3周：创建专业和自定义图表 第4周：使用数据透视表和数据透视图进行汇总和过滤 第5周：在Excel中创建互动仪表板 这是我们的数据分析和可视化专业化的第二门课程。第一门课程“Excel基础知识用于数据分析”涵盖了数据准备和清理，同时教授一些此课程所需的先决条件，例如表格、命名范围、文本和查找函数。我们建议您先完成第一门课程或具备相关经验，以获得最佳学习效果。 加入我们，在这个令人兴奋的旅程中，深入了解Excel中的数据可视化技能。
Name:Welcome and critical information
Description:
Name:Data Visualizations using Conditional Formatting, Sparklines and Number Formats
Description:This week we will explore a host of data visualisation tools that do not include charts. We will learn about conditional formatting, including custom conditional formatting using formulas, drop down lists, and macros. We will then move on to learning about sparklines, shapes, and custom number formats.
Name:Mastering charting techniques
Description:This week we will explore a range of options to visualise your data using charts. We will look at standard charts such as line charts, pie charts, and scatter charts – to help you visualise your data. We will also look at charts to add to your standard toolkit such as area charts, donut charts, and bubble charts – which will add that wow factor to your work.
Name:Specialized charts
Description:This week we will explore a range of innovative and creative charts – many of which are new to Excel. These charts include: hierarchy charts, waterfall charts, funnel charts, and geospatial charts. We will also look at customising and creating our charts when we look at population charts and gauge charts – giving you ideas to be innovative and creative.
Name:Create an Interactive Dashboard Using Pivot Charts and Slicers
Description:This week we take a turn into data analytics by exploring Pivot Tables. We will look at how to summarise data with Pivot Tables, as well as how to customise, group, sort, and filter pivot data. We will then look at performing calculations in Pivot Tables. Finally we explore Pivot Charts which help us visualise the data in our Pivot Tables.
Name:Complete the Dashboard with Creative Visualisations and Dynamic Charts
Description:This week we will explore putting all our tools and knowledge together in aesthetic, interactive, and informative dashboards. Putting dashboards together will also help you revise all the tools and concepts that you have gathered along the way. By the end of the week you will be able to incorporate themes, macros, hyperlinks, as well as utilise slicers to make your dashboards interactive.
Name:Final assessment
Description:This final assessment covers all content in weeks 1 to 5.
In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy to understand and attractive way, but they must also provide context for the data, tell a story, achieving that fine balance between form and function. Excel has many rivals in this space, but it is still an excellent choice, particularly if it's where your data resides. It offers a wealth of tools for creating visualizations other than charts and the chart options available are constantly increasing and improving, so the newer versions now include waterfall charts, sunburst diagrams and even map charts. But what sets Excel apart is its flexibility, it gives us total creative control over our designs so if needed we could produce our own animated custom chart to tell the right story for our data. Over five weeks we will explore Excel's rich selection of visualization tools using practical case studies as seen through the eyes of Rohan, an environmental analyst. Rohan is required to produce visualizations that will show trends, forecasts, breakdowns and comparisons for a large variety of environmental data sets. As well as utilising the usual chart types he wants to use conditional formats, sparklines, specialised charts and even create his own animated charts and infographics. In some cases, he will also need to prepare the data using pivot tables to drill down and answer very specific questions. We are going to help him achieve all this and present our finished visualizations in attractive reports and dashboards that use tools like slicers and macros for automation and interactivity. These are the topics we will cover: Week 1: Dynamic visualizations with conditional formatting, custom number formatting, sparklines and macros Week 2: Charting techniques for telling the right story Week 3: Creating specialised and custom charts Week 4: Summarising and filtering data with pivot tables and pivot charts Week 5: Creating interactive dashboards in Excel This is the second course in our Specialization on Data Analytics and Visualization. The first course: Excel Fundamentals for Data Analysis, covers data preparation and cleaning but also teaches some of the prerequisites for this course like tables and named ranges as well as text, lookup and logical functions. To get the most out of this course we would recommend you do the first course or have experience with these topics. In this course we focus on Data Visualization in Excel, join us for this exciting journey.
