You’ll begin this course by looking at some advanced Excel skills – including index formulas, logical text and nested functions. You’ll also look at data connections to external databases, and Visual Basic for Applications (the programming language behind Excel). Once you’re comfortable with that, you’ll move on to preparing a spreadsheet for a client – giving it a clean design and making it easy to use and reproduce.
Then you’ll learn how to create dynamic client-facing data dashboards. Finally, you’ll be given a complex raw data file, from which you’ll build a dynamic data dashboard from scratch.
This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
Course 3 of 5 in the Data Analysis and Presentation Skills: the PwC Approach Specialization.
Preparing a Professional Excel
During this first week, you are going to learn about the development of data models and databases. We will cover the components of data sets and the relational database models, database keys, relationships, and joins. We will also look at a tool called PowerPivot that is used to import and prepare data to build relational models, as well as visualize data. By the end of the week, you will have a working knowledge of how to develop a data model.
Graded: Week 1 Quiz
Advanced Scenario Analysis
This week, we are going to explore three different analytical methods used to help model different scenarios and deal with variable uncertainty. These methods are scenario analysis, sensitivity analysis and simulation. We’ll look at what each method is and then go deeper into why and how you use each. Following some guided demonstration, you’ll be given a chance to practice in an Excel workbook and demonstrate what you’ve learned.
Graded: Week 2 Quiz
This week we are going to focus on data visualization. We will start off by discussing data visualization basics, outlining the theory and concepts behind data visualization. We will also discuss how to enable effective story telling through the correct selection, creation, and presentation of tables and charts. You’ll get a chance to learn how to created detailed graphs and charts to effectively tell a story about your data.
Graded: Week 3 Quiz
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.
Graded: Week 4 Quiz
ENROLL IN COURSE