Excel Case Studies for Business Students

Excel Case Studies for Business Students
English | Size: 1.90 GB
Category: Video Training

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.

Download Faster with Resume Support with Premium Account



If any links die or problem unrar, send request to http://goo.gl/t4uR9G

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.