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.
Note: Learners will need PowerPivot to complete some of the exercises. Please use MS Excel 2013 version. If you have other MS Excel versions or a MAC you might not be able to complete all assignments.
This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

RG

It was a great experience to know the powerful tools of data analysis and visualization via excel and explore the potential for an effective storytelling and data representation.

RZ

Mar 23, 2019

Filled StarFilled StarFilled StarFilled StarFilled Star

This course took me from Basic level knowledge of Excel to a really advanced level. Course practice exercises are developed in a very appropriate way to teach the advanced level.

從本節課中

Dashboarding

In the final week of this course, you are going to learn how to create a dynamic dashboard. We are going to discuss how to establish a good understanding of your audience and how to collect key requirements in order to determine what type of dashboard to build. We will talk about some guiding design principles and things to consider when building a dashboard. You’ll have a chance to practice everything you learn this week by creating your own functional dashboard in Excel.

教學方

Alex Mannella

Alumni / Former Principal

腳本

[MUSIC] Welcome back to the final week of this course. During this week, you'll be learning about dashboarding. So what do we mean when we use the term dashboarding? Dashboarding allows a user to quickly focus on the most important aspect of a system using the principles of visualization and data modeling. In many ways, this is the culmination of weeks one through three of this course. Remember, in week one, we learned how to develop a data model. Which then can be used to perform a simulation or scenario analysis like we discussed in week two. Then in week three we learned how to create strong visualizations of the data in order to highlight the main trends and key takeaways. Now we're going to bring together these elements in order to develop highly effective dashboards. Let's talk about how and why we use dashboards. The first thing you need to think about when creating a dashboard is the audience. What are the expectations for the dashboard? Your audience's expectations will drive most decisions regarding the dashboard from the initial design, to the final end product. This is why we will start this week by discussing how to establish a good understanding of your audience, and how to collect key requirements. From there, we will move on to some guiding design principles including choosing chart elements. Then we will discuss core update considerations and how this affects the build of the dashboard. Finally, you will have a chance to practice everything you've learned by creating a functional dashboard in Excel. Dashboards have proved to be a powerful tool for many of my clients. Well thought out dashboards can quickly show the client a quick snapshot of their data. And can be built to allow them to drill down into more details if needed. For example, we helped one of my recent clients understand their medical and pharmacy claims data, by displaying key analytics and combining them in one simple and easy to use dashboard. Summarizing the key metrics in one spot allow the client to get a quick overview of the claims data. And better understand certain risks and opportunities. Just like weeks one through three, you'll go through a series of videos and demonstrations. Have a chance to practice in an Excel workbook, and to demonstrate what you've learned. Thanks for joining me and have a great week. [MUSIC]