4.1 out of 5
4.1
127 reviews on Udemy

Excel Case Studies for Business Students

Learn Excel functions & business analytics via authentic case studies. A QuickStart tutorial is included for beginners!
Instructor:
Jeff Knowlton
1,540 students enrolled
English [Auto]
Analyze business data with Excel. Starting from text data, students will be able to import the data, use Excel functions to clean the data, preparing it for analysis, summarize the data with pivot tables, visually display the results with charts, and present the results in a written report.

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.

Students learn Excel while answering real business questions.

The second case study is based on service repair and analysis. Students are given text files with the repair history of two different service sub-contractors (more than 50,000 records). The data must be imported, cleaned, and harmonized, using Excel text, date, and logical functions. Finally, the data can be analyzed with pivot tables and the results displayed visually: Which sub-contractor repairs products more quickly?

These are the skills employers are looking for!

The course begins with an optional “Quickstart” Tutorial for beginners, or for those students who haven’t used Excel in awhile, to refresh their knowledge.

The University of Oregon uses these case studies in two of their information management courses. And my other Udemy courses are recommended by the Oregon Business Education Association.

This course covers these topics in Excel:

  • Formatting Data
  • Cleaning "Dirty Data" with Functions: Text, Date, and Logical Functions
  • Filtering and Sorting Data with Table Functions
  • Analyzing Data with Pivot Tables
  • Visualizing the Results with Charts and Conditional Formatting

Content and Overview

In five hours of content including 50+ lessons, this course covers the important Excel functions to analyze business data. Most lessons have a practice session. I provide two Excel files for each practice session: the starting point and the finish point. I also provide the written script for most lessons.

Upon completion, students will be able to analyze large sets of business data. Students will be able to import large text files with tens of thousands of records, use Excel functions to clean data, use logical functions to build complex expressions, use the VLOOKUP function to work with cross-reference tables, analyze the data with pivot tables, display the results visually with charts, and explain the results in writing, and with clarity.

And you’ll know more than 80% of the casual Excel users in business today!

Let’s get started!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
127 Ratings

Detailed Rating

Stars 5
78
Stars 4
31
Stars 3
12
Stars 2
5
Stars 1
1
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Excel Case Studies for Business Students
Price:
$55.98 $39

Community

For Professionals

For Businesses

We support Sales, Marketing, Account Management and CX professionals. Learn new skills. Share your expertise. Connect with experts. Get inspired.

Community

Partnership Opportunities

Layer 1
samcx.com
Logo
Register New Account
Compare items
  • Total (0)
Compare
0