Problem Solving with Excel

share ›
‹ links

Below are the top discussions from Reddit that mention this online Coursera course from PwC.

This course explores Excel as a tool for solving business problems.

Data Analysis Microsoft Excel Pivot Table Data Cleansing

Reddsera may receive an affiliate commission if you enroll in a paid course after using these buttons to visit Coursera. Thank you for using these buttons to support Reddsera.

Taught by
Alex Mannella
Alumni / Former Principal
and 7 more instructors

Offered by
PwC

Reddit Posts and Comments

0 posts • 4 mentions • top 4 shown below

r/Accounting • comment
1 points • RyanRiot

Like others have said, there are a lot of (free) online courses that should teach you what you need. This Coursera class from PwC looks like it should hit all the main points.

r/excel • comment
1 points • businessrenegade111
r/datascience • comment
3 points • american_rugbier

PwC did a Data Analysis and Presentation Skills specialization course sequence with Coursera a while back. I found the first three modules very useful to learn about Excel's analytic features:

Data-driven Decision Making -- In this course you'll get an introduction to Data Analytics and its role in business decisions. You'll learn why data is important and how it has evolved. You'll be introduced to “Big Data” and how it is used. You'll also be introduced to a framework for conducting Data Analysis and what tools and techniques are commonly used. Finally, you'll have a chance to put your knowledge to work in a simulated business setting.

Problem Solving with Excel -- 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.

Data Visualization with Advanced Excel -- 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.

r/BestOnlineCourses • post
2 points • Marshall215
Data Analysis with Excel: Best Online Courses

PwC did a Data Analysis and Presentation Skills specialization course sequence with Coursera a while back. I found the first three modules very useful to learn about Excel's analytic features:

  • Data-driven Decision Making -- In this course you'll get an introduction to Data Analytics and its role in business decisions. You'll learn why data is important and how it has evolved. You'll be introduced to “Big Data” and how it is used. You'll also be introduced to a framework for conducting Data Analysis and what tools and techniques are commonly used. Finally, you'll have a chance to put your knowledge to work in a simulated business setting.

  • Problem Solving with Excel -- 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.

  • Data Visualization with Advanced Excel -- 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.

Other Courses: