Problem Solving with Excel

If you are a PwC Employee, gain access to the PwC Specialization and Courses for free using the instructions on the PwC L&D Spark page or simply search "Coursera" on PwC Spark.This Specialization will help you get practical with data analysis, turning business intelligence into real-world outcomes. We'll explore how a combination of better understanding, filtering, and application of data can help you solve problems faster - leading to smarter and more effective decision-making. You'll learn how to use Microsoft Excel, PowerPoint, and other common data analysis and communication tools, and

Created by: Alex Mannella

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you've learned. Finally, you will have a chance to put your knowledge to work in a final project. Please note, the content in this course was developed using a Windows version of Excel 2013. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

icon
Instructor Details

placeholder

PLEASE NOTE: If you are experiencing access or payment issues, please reach out the the Coursera support center at https://learner.coursera.help/hc/en-us for help. Alex Mannella was a founding member and Partner in PwC's Information and Analytics Practice and is a seasoned professional on the issues of customer value management (CVM), response modeling, database marketing, and data mining. He has extensive experience in developing response and segmentation algorithms for organizations of varying sizes, database development, and the use of artificial intelligence for data mining studies. Prior to joining PwC, Alex was head of research at Econometrics, Inc.. He was instrumental in the redesign of their national database of more than 180 million records for response modeling, data mining and direct marketing campaigns. In addition, Alex played a key role in the development of the life-stage variable at Econometrics, a variable that is a key component in CRM and market basket analysis. Alex is an active member of the American Statistical Association (Chicago Chapter) and the Chicago Association of Direct Marketing. Alex is a guest lecturer at UCLA, Stanford, ITAM (Mexico), Universidad de los Andes (Colombia), IIM-B, and ISB. In addition, Alex sits on an advisory board at the University of Chicago Graham School.

icon
More courses by Alex Mannella

Data-driven Decision Making

Free

Data Visualization with Advanced Excel

Free

icon
Reviews

4.8

377 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Aswin R on 7-Nov-16

Good Intermediate level course. Including useful functions we experience being part of Finance profile. Thanks

By Shahzaib M on 28-May-18

This is a nicely structured and informative course that fulfills its purpose. It is a good introduction to how to use Excle in more powerful ways; I did not feel like any special knowledge was needed until the last week when the course touched upon statistics and finance (though it provided explanations in a user-friendly fashion). In some videos audio quality is pretty bad; there are also minor mistakes in practise spreadsheets (most of them already pointed out by the community), hence I gave this course 4 stars.

By raghuveer n on 24-Nov-16

I learned many skills that I can apply on the job.

By Caio A A O on 18-Mar-17

The course is well structured, but some of the files are not properly audited so there are mistakes which can lead to wrong answers in the quizzes.

By Stefano C on 20-Jan-17

In general, this is a good course. It provides many handy tools. But I still wish it had provided a larger scope of other tools we could learn in the future, even if the course doesn't teach these. In essence, I learned much, but my horizon wasn't broadened much.

By Hermon A on 8-Apr-18

Good course, although some of the videos were poor quality and I thought that explanations for some tasks could have had more clarity. It went from very simple to quite complex very quickly, and I would have liked a lot more practice questions to really get the hang of some of the functions and formulas introduced.

By Shubhra S on 25-Nov-17

I found some mistakes in the excel workbooks. This caused slight confusions. Other than than, I learned some new tricks in excel, which i have even began using in practice. Thank you and regards,

By Carlos V on 12-Apr-17

I would give this course a 4.5 if I could. I liked the course overall, but felt that there could have been more explanations with the answers to the weekly projects. For answers I couldn't solve, I had to look at the solutions and back out the correct formula to teach myself sometimes. I thought the videos were very helpful, but sometimes hard to follow since the text being input in the video was hard to see.

Great course! Very informative. Thanks PWC and Coursera for this course.

By Zhaoqing X on 28-Jan-17

Good Course! However, a few errors in the exercises; regardless, they made me better in the end. A few minor issues with poor video/audio quality on the exercises. Still, a worthwhile course.

By RJ C on 2-Jan-18

I was already familiar with advanced Excel techniques but this course re-affirmed these and introduced exciting new techniques for familiar functions and logic. New advanced formulas were also introduced and very practical and insightful. Invaluable - really enjoyed the course!

By Mathieu D on 20-Mar-18

it's really help in my care