Best Free MOOCs In Business For December

Excel

Problem Solving With Excel

 

School: PwC (PricewaterhouseCoopers LLP)

Platform:Ā  Coursera

Registration Link: REGISTER HERE

Start Date: December 5, 2016 (4 Weeks Long)

Workload: 3 Hours Per Week

Instructor: Alex Mannella

Credentials: Manella is a partner at PwC, where he was the founding member of the firmā€™s information and analytics practice. His expertise includes database marketing, data mining, econometrics, and customer relationship management. He has also been a guest lecturer at several schools, including Stanford and UCLA.

Graded: To earn a passing mark, students must complete all graded assignments.

Description: 50 years ago, accountants would manually tabulate transactions using columns and rows. It was a time-consuming, manual process where the sheer volume of data made it difficult to spot profit-and-loss centers. While some still consider electronic spreadsheets to be glorified calculators, they are really a vehicle that levels the playing field between finance professionals and their poet counterparts. Here, you can apply formulas and manipulate variables to manage budgets, model and forecast financial performance, and pinpoint trends. This course takes learners through basic Excel functions before moving into more complex applications, including VLookups, Pivot Tables, and Statistical Forecasting. The course concludes with a final project where students create documents that integrate the concepts that they have learned.

Review: ā€œSome topics were rather basic; however, this is a great and insightful course for beginner/intermediate Excel users on how to leverage the tools in Excel in data analytics!ā€ For additional reviews, click here.

Additional Notes: This is the second of five courses that comprise PwCā€™s ā€œData Analysis and Presentation Skills: The PWC Approachā€ specialization. To learn more about this specialization and register for it, click here.

Questions about this article? Email us or leave a comment below.