Save for later

Data Visualization with Advanced Excel

Data Analysis and Presentation Skills: the PwC Approach,

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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.7 based on 300 ratings
Length 5 weeks
Effort 4 weeks of study, 3-4 hours per week
Starts Jun 26 (43 weeks ago)
Cost $79
From PwC via Coursera
Instructor Alex Mannella
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Get a Reminder

Send to:

Similar Courses

What people are saying

very useful

Thank you for everything, The course is very useful.

Very useful as it provided me with advanced techniques in Excel which are musts to be successful in current business jobs.

Very useful and professional!

Very useful in everyday work-life.

It is an interesting course where I learned very useful tools of Excel that will help me to visualize information in a more understanding and clear way to the client, underlining the most important ideas and results.

I can't wait to get into excel and improve the Very useful on practise course A great course to follow up the basic excel course provided before.

Although I feel we must discuss more case studies Very useful insights and definitely a knowledge enhancing course Very interesting, well- explained, and practical course.

Very useful techniques A great course for people working with data Excellent course materials, very applicable for professionals who work with data Practical, step-by-step guide and easy to understand, thank you very much for PwC instructor's efforts to design and develop such a fantastic course, look forward to completing the whole specialization!

Very useful and comprehensive I really learned a lot during this course especially how to build data models and dashboards.

It was a very useful course.

High level philosophy well explained with hands on tips and tricks, very useful for client oriented works, thanks!

Very useful!

Thank you The information provided within is very useful and laid out with helpful tools, however it relies entirely on the PowerPivot function that is not available on a MAC platform, which was not listed in the course description and which made the course totally useless for my needs.

Very useful and well-organized course.

Read more

very good

I expected something about VBA Grrrrrrreat learning :) Very good, dynamic and easy to understand!

Very good I learned many knew tools in excel during this course.

It's a very good course about excel !

very good In depth step by step explanations in how to use Excel for Analysis and Visualization I have already had the basic skills in excel, but I learned many new things.

Very good overview and practical exercises to keep learners focus.

This is really very good course, which is used in management report assugnments could have been better Dashboarding has never been easier to learn and practice!

bad quality Very good course for people who have basic excel and would like to utilize excel in visualization.

Very Good Modul kind of amazed how I didn't know about excel and how dashboarding until this course.

good Excel course with very good exercises that give you practice.

Very good material for learning advanced feature of EXCEL Good course for learning to build Dashboard in Excel Very good course!

Read more

data analysis

The theme is excellent, the instructors are very professional and it shows that they have a lot of experience in Excel and data analysis.

Well executed from PwC team 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.

Great course to data analysis and excel!

Extremely useful course for excel and data analysis enthusiasts.

This course gives me new learning which will help to boost my carrier and productivity as well as increase the thirst of my knowledge about data analysis and finance.

Extraordinary course to learn advanced excel skills Excelent course, great to introduce in data analysis and visualization.

Read more

real life

very good course Really Very much helpful course for applying it in real life situations It was a great course highlighting the important tools for dashboarding.The explanation was lucid with multiple examples.

Enables you to get your hands on real time problems solutions Excellent approach to the tools in excel; exercises concise, practical and with real life situations.

It really helps to gain the in-depth visualization and analysis skills Exc Great business practice advices, but not very rich with real life practice, like print preview, professional colour theme chosen, etc.

Loved the exercises which showcases real life business.

course is very nice plese give the link for certificate it does not show my certificate Dashboards are extremely useful and effective as well as impressive, I really appreciate the course for insights on how to build them and use in real life Very easy way to explain some key functions of excel that can help a lot in the art of visualization, thanks!

Read more

more advanced

Very good introduction to some more advanced Excel functionalities.

This gave a complete view of more advanced options and how I can manipulate my data Some more assignments would have helped.

Although, I did expect things to be more advanced like in week five material and further.

Simple and effective guidance on the more advanced Excel functions like PowerPivot, scenario analyses and the developer tools were really helpful.The examples were given in a business context, hence making it easier to visualise the real world applications.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

MBA Candidate Class of 2013 $36k

Instructor & Italian Programme Coordinator (2013-2014) $43k

2013 MBA Candidate $46k

MBA class of 2013 $49k

English Language Development, AVID & AVID Excel Teacher $53k

Substitute Professor (Adjunct-2013) $58k

Assisted Sales Rep For Holiday 2013 $60k

Excel Reporting Developer $68k

Assistant Writer - 2013 NBC Scene Showcase $75k

Excel/Access DTS Developers $78k

Excel VBA Developer $82k

2013 Ohio Bus Conductor $123k

Write a review

Your opinion matters. Tell us what you think.

Rating 4.7 based on 300 ratings
Length 5 weeks
Effort 4 weeks of study, 3-4 hours per week
Starts Jun 26 (43 weeks ago)
Cost $79
From PwC via Coursera
Instructor Alex Mannella
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now