In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards.
本课程是 Data Analysis and Presentation Skills: the PwC Approach 专项课程 专项课程的一部分
提供方

课程信息
您将获得的技能
- Dashboard (Business)
- Microsoft Excel
- Data Virtualization
- Data Visualization (DataViz)
提供方
授课大纲 - 您将从这门课程中学到什么
Preparing a Professional Excel
Advanced Scenario Analysis
Data Visualization
Dashboarding
审阅
- 5 stars80.73%
- 4 stars16.38%
- 3 stars1.96%
- 2 stars0.49%
- 1 star0.42%
来自DATA VISUALIZATION WITH ADVANCED EXCEL的热门评论
Just so much to learn... With the lessons here, an activity that would cost 30min time to execute should take 10min or less if the tools are utilized... Excel has lots of magic hidden wands!
Amazing course. I learnt a lot of new things and the ability to practice what i learnt right away and apply it to a business context is what i liked the most from this course.
One of the Best course which make data visualization simple for me. It help me to enhance my Microsoft Skills, I will recommend it to anyone who wants to visualize data or anyhow related to business.
Nice, especially part with dashboards.
I was pretty familiar with all techniques, but it good to have an understanding of what big company is expecting from you.
关于 Data Analysis and Presentation Skills: the PwC Approach 专项课程

常见问题
我什么时候能够访问课程视频和作业?
我订阅此专项课程后会得到什么?
有助学金吗?
还有其他问题吗?请访问 学生帮助中心。