» » » Excel Case Studies for Business Students
uploaded.to



Information of news
30-10-2015, 00:32

Excel Case Studies for Business Students

Category: Tutorials / Other

Excel Case Studies for Business Students

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.


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!

rapidgator_net:
http://rapidgator.net/file/027cc6929367d99d6cd826c22490b1a2/p71sj.Excel.Case.Studies.for.Business.Students.part1.rar.html
http://rapidgator.net/file/aeb1466397e9157be32e3cd97e05238e/p71sj.Excel.Case.Studies.for.Business.Students.part2.rar.html
http://rapidgator.net/file/45ec92efa4ca4f9058a224b239eb5d46/p71sj.Excel.Case.Studies.for.Business.Students.part3.rar.html
http://rapidgator.net/file/32b4fa42f7bf315789a6dd31724577cf/p71sj.Excel.Case.Studies.for.Business.Students.part4.rar.html
http://rapidgator.net/file/0866a119962255ee16f51f0536074ae1/p71sj.Excel.Case.Studies.for.Business.Students.part5.rar.html
http://rapidgator.net/file/b2726cb23c2dadb6fbc28acf657ead74/p71sj.Excel.Case.Studies.for.Business.Students.part6.rar.html
http://rapidgator.net/file/5bf7e4c77db165e99b0a493106f4a601/p71sj.Excel.Case.Studies.for.Business.Students.part7.rar.html
http://rapidgator.net/file/7f8b18952c3fdd200c37dac8817ffae9/p71sj.Excel.Case.Studies.for.Business.Students.part8.rar.html

secureupload_eu:
https://www.secureupload.eu/wpbelsyu7vrq/p71sj.Excel.Case.Studies.for.Business.Students.part1.rar
https://www.secureupload.eu/v9cd8t3i07kx/p71sj.Excel.Case.Studies.for.Business.Students.part2.rar
https://www.secureupload.eu/0ac08tve2nyt/p71sj.Excel.Case.Studies.for.Business.Students.part3.rar
https://www.secureupload.eu/2xk234sxl6lc/p71sj.Excel.Case.Studies.for.Business.Students.part4.rar
https://www.secureupload.eu/7mgvxjglr2lc/p71sj.Excel.Case.Studies.for.Business.Students.part5.rar
https://www.secureupload.eu/q4ihzk1b2bu3/p71sj.Excel.Case.Studies.for.Business.Students.part6.rar
https://www.secureupload.eu/jqxzy4p6636p/p71sj.Excel.Case.Studies.for.Business.Students.part7.rar
https://www.secureupload.eu/tf4khg6e81ev/p71sj.Excel.Case.Studies.for.Business.Students.part8.rar

uploaded_net:
http://uploaded.net/file/bss0arjg/p71sj.Excel.Case.Studies.for.Business.Students.part1.rar
http://uploaded.net/file/6m3c4ryp/p71sj.Excel.Case.Studies.for.Business.Students.part2.rar
http://uploaded.net/file/si1ql3oq/p71sj.Excel.Case.Studies.for.Business.Students.part3.rar
http://uploaded.net/file/kajtey5g/p71sj.Excel.Case.Studies.for.Business.Students.part4.rar
http://uploaded.net/file/yxauv4wt/p71sj.Excel.Case.Studies.for.Business.Students.part5.rar
http://uploaded.net/file/t8qec8a9/p71sj.Excel.Case.Studies.for.Business.Students.part6.rar
http://uploaded.net/file/0t0el6ec/p71sj.Excel.Case.Studies.for.Business.Students.part7.rar
http://uploaded.net/file/w4ykuvrc/p71sj.Excel.Case.Studies.for.Business.Students.part8.rar

nitroflare_com:
http://nitroflare.com/view/68787ACCDA13CE4/p71sj.Excel.Case.Studies.for.Business.Students.part1.rar
http://nitroflare.com/view/B267CA3A001F462/p71sj.Excel.Case.Studies.for.Business.Students.part2.rar
http://nitroflare.com/view/CF94AD05B58F1A7/p71sj.Excel.Case.Studies.for.Business.Students.part3.rar
http://nitroflare.com/view/7BC2061614D7FFB/p71sj.Excel.Case.Studies.for.Business.Students.part4.rar
http://nitroflare.com/view/0783E361BE1223C/p71sj.Excel.Case.Studies.for.Business.Students.part5.rar
http://nitroflare.com/view/8DB5475AD3DC3AF/p71sj.Excel.Case.Studies.for.Business.Students.part6.rar
http://nitroflare.com/view/1CCA1F482A5CA96/p71sj.Excel.Case.Studies.for.Business.Students.part7.rar
http://nitroflare.com/view/29EE1B29964413A/p71sj.Excel.Case.Studies.for.Business.Students.part8.rar


uploaded


Rapidgator.net

Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

^
 
free html hit counter