Problem Solving With Excel
School: PwC (PricewaterhouseCoopers LLP)
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.