Microsoft Excel Business Analytics and Modeling

Microsoft Excel Business Analytics and Modeling, available at $19.99, has an average rating of 3.67, with 20 lectures, 1 quizzes, based on 3 reviews, and has 10 subscribers.

You will learn about Solve common, real world business problems with Excel Get hands-on solutions you can apply to your work immediately Model your data and know when to use Excel functions and tools Utilize tools like Solver to find the optimal solution for time schedules, production mixes, loan repayment and more Enjoy a competitive advantage over others by unlocking powerful analytics Employ tools like Monte Carlo simulation and probability theory to drive everyday decisions This course is ideal for individuals who are Business professionals who want to take their career to the next level or Restaurant owners and managers, caterers, food and drink manufacturers and suppliers and other professionals in the food service industry who want to glean insights using an everyday software tool It is particularly useful for Business professionals who want to take their career to the next level or Restaurant owners and managers, caterers, food and drink manufacturers and suppliers and other professionals in the food service industry who want to glean insights using an everyday software tool.

Enroll now: Microsoft Excel Business Analytics and Modeling

Summary

Title: Microsoft Excel Business Analytics and Modeling

Price: $19.99

Average Rating: 3.67

Number of Lectures: 20

Number of Quizzes: 1

Number of Published Lectures: 20

Number of Published Quizzes: 1

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Solve common, real world business problems with Excel
Get hands-on solutions you can apply to your work immediately
Model your data and know when to use Excel functions and tools
Utilize tools like Solver to find the optimal solution for time schedules, production mixes, loan repayment and more
Enjoy a competitive advantage over others by unlocking powerful analytics
Employ tools like Monte Carlo simulation and probability theory to drive everyday decisions

Who Should Attend

Business professionals who want to take their career to the next level
Restaurant owners and managers, caterers, food and drink manufacturers and suppliers and other professionals in the food service industry who want to glean insights using an everyday software tool

Target Audiences

Business professionals who want to take their career to the next level
Restaurant owners and managers, caterers, food and drink manufacturers and suppliers and other professionals in the food service industry who want to glean insights using an everyday software tool

Do you want to estimate a demand curve for your product or service and then use it to maximize profit?

Would you like to know the odds that a customer has to wait more than 3 minutes in a line or on hold?

Given a production constraint, would you like to know the optimal product mix to produce to maximize profit?

Do you want pick a route with several stops that minimizes the amount of miles driven by your driver?

Would you like to be able to use Scenario analysis to determine the best case, worst case and expected case of cash flow when deciding whether or not to undertake a business decision?

You don’t need a Standford PhD or an expensive consulting firm to answer these questions. This course and an $8 a month subscription to Excel will give you the tools you need to solve everyday, real-life problems that every business faces.

There are countless courses out there that will teach you how to use Excel functions, but to truly unlock its power, you need to know whento use a function and how to model (setup) your data to launch your business or career to the next level.

Course Curriculum

Chapter 1: Course

Lecture 1: How do I minimize my driver's miles if he has to make 7 stops?

Lecture 2: Which product should I produce to maximize profit?

Lecture 3: How many tickets over capacity should you sell to your event?

Lecture 4: What is the probability my customers will wait for more than 3 minutes?

Lecture 5: How much should I pay to each credit card balance?

Lecture 6: How do I quickly consolidate reports across workbooks?

Lecture 7: How much dough do I order if I only want a 4% chance of my pizzeria running out?

Lecture 8: How do I create my own demand curve and set profit-maximizing price?

Lecture 9: How do I visualize my data to support my decision?

Lecture 10: How do I set my workers' schedule to ensure each has two consecutive days off?

Lecture 11: How do I make reports from other systems Excel-friendly?

Lecture 12: Can I extract text strings from poorly formatted data?

Lecture 13: How do I calculate the max interest I can be charged?

Lecture 14: Under which scenarios should I acquire a company?

Lecture 15: How do I quantify my best, worst, and likely cases for a decision?

Lecture 16: How much potato salad am I supposed to make when I don't know the daily demand?

Lecture 17: Can I connect my workbook to an external website to automatically import data?

Lecture 18: Can I quickly bring in data for commonly used data types?

Lecture 19: How do I figure out how many female vegans are in my city?

Lecture 20: How do I calculate the odds of price greater than X dollars in T time?

Instructors

Jay Karimi
Corporate Finance and Accounting Professional

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu