About this course: 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. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
Taught by: Alex Mannella, Principal
| Basic Info |
Course 3 of 5 in the
Data Analysis and Presentation Skills: the PwC Approach Specialization.
|
| Level | Beginner |
| Commitment | 4 weeks of study, 3-4 hours per week |
| Language | English |
| Hardware Req | Excel 2013. You'll need to install the Power Pivot add-in in Microsoft Excel. |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
| Audit | Purchase Course | |
|---|---|---|
| Access to course materials | Available | Available |
| Access to graded materials | Not available | Available |
| Receive a final grade | Not available | Available |
| Earn a shareable Course Certificate | Not available | Available |
Excellent course. Thjanks to PWC for helping to access to this knowledge!
One of the most useful and interesting courses I've taken that can help me in my career.
very much useful content.
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
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.