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 |
V
Complete course about excel. I learned a lot, the course is complete and the exercises are good challenges. It's a very good course about excel !
I found this course to be relatively advanced, but taught in a way that made it very easy to follow. There are two sets of workbooks for each week; the teacher's book which is exactly as shown in the videos, and the student's book which is for practice after each week. Overall I am very happy with the course and recommend it strongly !
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
IA
Great