Alex Mannella
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. With offices in 157 countries and more than 208,000 people, PwC is among the leading professional services networks in the world. Our purpose is to build trust in society and solve important problems. We help organisations …
Instructor Details
Courses : 4
Specification: Data Visualization with Advanced Excel
|
91 reviews for Data Visualization with Advanced Excel
Add a review
| Price | Free |
|---|---|
| Provider | |
| Duration | 10 hours |
| Year | 2017 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
FREE
Chen Z –
clear and useful.
Jorge A –
Good course
Bao N Q –
Excellence and helpful course with a lot of tools for business.
Kavin P –
Extremely useful course for excel and data analysis enthusiasts. Great help by PwC team. Thanks for the same.
Tan H R –
Very structured teaching & taught me a lot of new functions that I did not know was available. Loved the exercises which showcases real life business.
Farhan A –
Great course content. Really enjoyed this course. Surely this is a great value addition for a finance student like me 🙂
Noah V –
A lot of the functions are outdated and due to the countless versions of Excel that are now available, not all of the different functions necessary to do this course are not potentially plausible.
Satya G T –
Excellent refresher and more..
Wenny –
Thanks so much for PwC experts kind sharing. Very useful and well organized course. I have learned a lot. Really app
Pranay C –
The course touches all key concepts which should be further built upon by exploring and practising.
Samba M –
great course
Kate T –
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.
Camilo A –
Very useful! Thank you
Camilo A –
Very useful! Thank you
Romeo C –
Great course. I learned a lot of high level concepts. As suggested in the course, however, I’ll have to dig a lot deeper into other individualized courses to learn specific information better. For example, to really appreciate the pivot table, I’d say that you’ll have to take a pivot table course on another platform like Linked Learning or through another course here on Coursera.
Purvam M –
Course was very well organized. Each topic was explained adequately. I just wish that for certain tools like Scenario manager more examples could be incorporated.
Romeo C –
Great course. I learned a lot of high level concepts. As suggested in the course, however, I’ll have to dig a lot deeper into other individualized courses to learn specific information better. For example, to really appreciate the pivot table, I’d say that you’ll have to take a pivot table course on another platform like Linked Learning or through another course here on Coursera.
Purvam M –
Course was very well organized. Each topic was explained adequately. I just wish that for certain tools like Scenario manager more examples could be incorporated.
Nora D –
Very helpful and super easy to apply skills for better visualizing data sets.
Nora D –
Very helpful and super easy to apply skills for better visualizing data sets.
Tan Z Q –
Worth to learn and comprehensive teaching method. Overall higher that my expectation and good investment on my time. Definitely from zero to hero. Thank you PwC and Coursera to allow me expose into this worshipful course.
Tan Z Q –
Worth to learn and comprehensive teaching method. Overall higher that my expectation and good investment on my time. Definitely from zero to hero. Thank you PwC and Coursera to allow me expose into this worshipful course.
Sudipto D –
Awesome course for anyone who wants to Excel at Excel!!
Sudipto D –
Awesome course for anyone who wants to Excel at Excel!!
Caitlyn –
First of, PowerPivot is not available on Mac which was not made known from the start of the course. If this course is going to use PowerPivot (a feature unavailable on Mac), it should have been stated the pre requisites. Unresponsive instructors students are troubleshooting and speaking amongst ourselves. Many threads are left without any replies at all, most were common issues. Some threads are as old as 3 years ago and still without replies from the instructors. I understand there is a lot of thread to go through but it is an expectation that tutors reply to most (if not, all) threads similar to course expectations on other platforms like Udemy. The course content sequence is illogical Why is the student workbook section comes before the video section explaining the instructor’s exercises? If that is the plan then you should have included instructions telling students to watch the rest of the videos before attempting the exercise. Also, answer sheet errors and incorrect answers should be rectified ASAP because it is very misleading for students (especially those newer to the subject matter) to understand whether they are getting the correct answer or not i.e. Week 1 Pivot 3b. There is a thread about this issue from 3 YEARS AGO and the answer sheet is still not revised.
Caitlyn –
First of, PowerPivot is not available on Mac which was not made known from the start of the course. If this course is going to use PowerPivot (a feature unavailable on Mac), it should have been stated the pre requisites. Unresponsive instructors students are troubleshooting and speaking amongst ourselves. Many threads are left without any replies at all, most were common issues. Some threads are as old as 3 years ago and still without replies from the instructors. I understand there is a lot of thread to go through but it is an expectation that tutors reply to most (if not, all) threads similar to course expectations on other platforms like Udemy. The course content sequence is illogical Why is the student workbook section comes before the video section explaining the instructor’s exercises? If that is the plan then you should have included instructions telling students to watch the rest of the videos before attempting the exercise. Also, answer sheet errors and incorrect answers should be rectified ASAP because it is very misleading for students (especially those newer to the subject matter) to understand whether they are getting the correct answer or not i.e. Week 1 Pivot 3b. There is a thread about this issue from 3 YEARS AGO and the answer sheet is still not revised.
Sulani D S –
Valuable course,really interesting.
Sulani D S –
Valuable course,really interesting.
David T –
This course really ticks many important points, far exceeded my expectations!!!
ruby –
This course was really useful to learn how to use really useful tools for business in Excel. I feel that I am really satisfied with what I learned through this course. Widely recommended.
David T –
This course really ticks many important points, far exceeded my expectations!!!
ruby –
This course was really useful to learn how to use really useful tools for business in Excel. I feel that I am really satisfied with what I learned through this course. Widely recommended.
Judith A V –
Excellent, thanks!
Judith A V –
Excellent, thanks!
Shivani b –
one of the best courses .thankyou pwc! for inhancing my analyatical skills.
Shivani b –
one of the best courses .thankyou pwc! for inhancing my analyatical skills.
Oleksandr P –
Basic course, but provides good overall view on Excel visualization capabilities (charts, powerpivot, pivotchart, slicers, etc.)
Oleksandr P –
Basic course, but provides good overall view on Excel visualization capabilities (charts, powerpivot, pivotchart, slicers, etc.)
Pratyush S –
1) Please Try to include more Excercises. Explore more excel functionalities
Pratyush S –
1) Please Try to include more Excercises. Explore more excel functionalities
Patricia B –
Clear explanation and pretty useful content.
Patricia B –
Clear explanation and pretty useful content.
Angelica B –
This course has reminded me of all the fun tools in excel that I love and make numbers more visually appealing! Easy to follow, great practice problems and overall a good introductory course to visualization.
Salman R –
Great job!
Angelica B –
This course has reminded me of all the fun tools in excel that I love and make numbers more visually appealing! Easy to follow, great practice problems and overall a good introductory course to visualization.
Salman R –
Great job!
Igor F L –
Extraordinary course. Thank you PWC and Coursera!
Igor F L –
Extraordinary course. Thank you PWC and Coursera!
Karen W –
I know a lot of visualization concepts, and I am surprised that Excel can do interactive charts. Thank you all of the instructors for incredible guidance!!
Karen W –
I know a lot of visualization concepts, and I am surprised that Excel can do interactive charts. Thank you all of the instructors for incredible guidance!!
Fasih K –
Highly recommended for excel users
Fasih K –
Highly recommended for excel users
Aymen A –
Incredibly helpful
Aymen A –
Incredibly helpful
Robert R –
Good quality videos. Step by step instructions for most of the processes. Good instructions for assignments, and answers already provided so you can self verify that you’re using the tools and concepts properly.
Robert R –
Good quality videos. Step by step instructions for most of the processes. Good instructions for assignments, and answers already provided so you can self verify that you’re using the tools and concepts properly.
john P R T –
Good one and simple to understand and learn
john P R T –
Good one and simple to understand and learn
Haifeng W –
High level philosophy well explained with hands on tips and tricks, very useful for client oriented works, thanks!
Haifeng W –
High level philosophy well explained with hands on tips and tricks, very useful for client oriented works, thanks!
Narcis S G –
Great structure of the curse with chances to practice every new concept as the course progresses.
Narcis S G –
Great structure of the curse with chances to practice every new concept as the course progresses.
Sherif E –
Excellent!
Sherif E –
Excellent!
MD. M R –
To progress in career this course is very helpful.
MD. M R –
To progress in career this course is very helpful.
Ahmed H A –
Dashboarding has never been easier to learn and practice!
Ahmed H A –
Dashboarding has never been easier to learn and practice!
Yash W –
assugnments could have been better
Yash W –
assugnments could have been better
Alejandro A W –
Excellent course, dynamic and very interactive clases!!!
GUNJAN R –
This is really very good course, which is used in management report
Alejandro A W –
Excellent course, dynamic and very interactive clases!!!
GUNJAN R –
This is really very good course, which is used in management report
Alexandra W –
This course was very helpful, it really added to my Excel arsenal of skills. The other courses from PWC did a great job of providing summaries you can go back to, but this course doesn’t so if you want to return to the information, take good notes!
Alexandra W –
This course was very helpful, it really added to my Excel arsenal of skills. The other courses from PWC did a great job of providing summaries you can go back to, but this course doesn’t so if you want to return to the information, take good notes!
Fouzia B –
it was great
Fouzia B –
it was great
Farzeen C W –
I thoroughly enjoyed this course and all the exercises that came with it. I would have liked to learn more about building dashboards in Excel but I feel this course has given a good starting point to explore the feature on my own. I look forward to completing other PwC courses on Coursera.
Farzeen C W –
I thoroughly enjoyed this course and all the exercises that came with it. I would have liked to learn more about building dashboards in Excel but I feel this course has given a good starting point to explore the feature on my own. I look forward to completing other PwC courses on Coursera.
Yuhuan Z –
Great course! It has taught me many hidden but useful skills provided by Excel.
Yuhuan Z –
Great course! It has taught me many hidden but useful skills provided by Excel.
Nisarg T –
Amazing course. I learnt a lot of new things and the ability to practice what i learnt right away and apply it to a business context is what i liked the most from this course.
Nisarg T –
Amazing course. I learnt a lot of new things and the ability to practice what i learnt right away and apply it to a business context is what i liked the most from this course.
Jatin G –
good content
Jatin G –
good content
Saurabh H J –
Great experience!
Saurabh H J –
Great experience!
Siddhartha D –
Useful material for client presentations!
Siddhartha D –
Useful material for client presentations!
Apurv G –
Great course for Data visualization and dashboard. course content is good but course is outdated it should cover more new features and no discussion going on in the Forums