Excel Case Studies for Business Students

MP4 | Video: 1280x720 | 76 kbps | 44 KHz | Duration: 6 Hours | 1.90 GB

Genre: eLearning | Language: English

Learn Excel functions & business analytics via authentic case studies. A QuickStart tutorial is included for beginners!

Excel has become the primary analytical tool of the business world. But this is not just an Excel course: this course is about business analytics. It’s about turning business data into valuable information, using Excel as the tool.

This course is designed for college students taking business courses. While giving a guest lecture at the University of Oregon, I learned that both students and faculty were not happy with the existing business courses that taught Excel. The courses were too focused on the mechanics of Excel, on the commands and menu paths. And they used contrived, artificial examples.

Improve your grades in business classes. Be better prepared for interviews.

So I designed this course around authentic case studies from my experience as a senior business executive. The first case study is based on sales reporting and analysis. Students are given all of the sales information for a small company for an entire year. Through applying Excel functions like VLOOKUP and IF, the data is prepared for analysis. Then using pivot tables, the data is summarized and analyzed. The results are displayed visually with charts. Finally, the results are explained in writing. And students learn some “Business Basics” along the way, about invoicing, credit memos, and sales analysis.