Microsoft Excel – 数据可视化，Excel图表和图形

你将学到什么

课程概况

*** Course access includes project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee ***

__________

Hear why this is one of the TOP-RATED Excel courses on Udemy:

“Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all Excel users looking to improve their skills.”

-Nirav Mehta

“Excellent from start to finish, picked up a bunch of things that will be useful in the workplace with entry level to ramping it up to some very cool advanced visualizations. Loved all of it, hope I can learn more in the future from this wonderful individual!”

-Robert Cordova

“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 courses!”

-Judit Bekker

__________

FULL COURSE DESCRIPTION:

Ask people what comes to mind when they think of Excel, and odds are they’ll say “spreadsheets”. The truth is, Excel is an incredibly powerful, robust, and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and I’m here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel’s latest data visualization tools and techniques. I’ll show you when, why, and how to use each chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and exercises every step of the way.

课程大纲

Before We Dive In
5 个讲座
09:43

PivotTable 101
13 个讲座
49:37

PivotTable Formatting
9 个讲座
29:46

Sorting, Filtering & Grouping
11 个讲座
42:13

Calculated Values, Fields & Items
17 个讲座
01:12:34

PivotCharts
12 个讲座
55:22

PivotTable Case Studies
21 个讲座
02:30:58

Wrapping Up
2 个讲座
03:19

面向人群

Anyone looking to create beautiful and effective data visualizations in Excel
Excel users who have basic skills but want to master advanced charts, graphs & dashboards
Students looking for an engaging, hands-on, and highly interactive approach to training

预备知识

Microsoft Excel, ideally 2016+ or Office 365 for PC (some charts are not available in other versions of Excel)
Mac users are welcome, but note that the user experience will be significantly different across platforms