Publication Date:

Discipline:

Source:

Product number:

Length:

description

The updated Spreadsheet Modeling course teaches students how to use Microsoft Excel 2013 as both a reporting tool and a modeling tool for solving business problems. It is appropriate for both beginning and experienced users of Microsoft Excel. The course begins with an in-depth tour of the Excel environment and includes many helpful shortcuts and tips for mastering the functions in Excel. Students apply this knowledge to creating spreadsheet models, powerful tools for analyzing data and making business decisions. The course is set in a fictional bakery specializing in French pastries. Students use the features of Microsoft Excel to study product costs, determine pricing, and track payroll. They build spreadsheet models to help make informed business decisions. The course closes with the Monte Carlo simulation, a tool for understanding the effect of uncertainty on business decisions. Course topics are presented in a highly interactive format with narrated animations and self-correcting exercises designed to engage students in the learning process and help them understand complex concepts quickly. Microsoft Excel worksheets are included to assist students as they work towards mastering the subject matter. The course includes pre- and post-assessments. Student progress and test scores can be viewed online or downloaded to Excel format. Seat time is 17 to 20 hours, depending on the student's experience with the material. Spreadsheet Modeling Online Course: Excel 2007 is also available.

learning objective:

Demonstrates how to use Microsoft Excel 2013 to create spreadsheet models to solve business problems

Publication Date:

Discipline:

Source:

Product number:

Length:

description

NEW! This online course is now available in sections. (See Supplemental Materials below.)

Mathematics is used to solve a wide range of practical business problems. This online course is designed to level the playing field among incoming MBA students, regardless of prior professional or academic background. Mathematics for Management reviews the key mathematics concepts students should be familiar with in order to solve quantitative problems in the MBA curriculum. The complete course includes the following sections: Algebra, Calculus, Statistics, Probability, and Finance. Each section is also available separately. The course engages students by using the storyline of several families operating small businesses in a fictional suburb of Las Vegas. Narrated animations, videos, and over 150 "do-it-yourself" exercises help students grasp difficult concepts quickly. At the end of each topic, students work through self-correcting exercises to check their mastery of the topic. Many exercises also include Excel 2007 functionality, in combination with interactive features, to further enhance understanding of essential mathematics concepts. Student progress and test scores can be viewed online or downloaded to Excel format. Approximate seat time: Beginner-12-20 hours. Experienced-5-10 hours.

learning objective:

Review the key mathematics concepts that students should be familiar with in order to solve quantitative problems in the MBA curriculum. A secondary objective is to illustrate and teach students the Microsoft Excel functions and formulas that facilitate the application of these math concepts.

Publication Date:

Discipline:

Source:

Product number:

Length:

description

This course material is the Calculus Section from the complete Mathematics for Management Online Course. Courses may be adopted in their entirety or by individual sections.

The Calculus Section of the Mathematics for Management Online Course reviews the calculus topics that students encounter in an MBA curriculum. The section includes: Motivation for Differential Calculus / Determining the Slope of a Function / Slope and Tangent Lines / Rules for Computing Derivatives / Second Derivatives, Convex, and Concave Functions / Maximizing and Minimizing Functions / Inflection Points. Includes pre- and post-test assessments. The complete Mathematics for Management Online Course is intended to give all students-regardless of their professional or academic background-a comprehensive review of the mathematical concepts that are essential for a business education. The course engages students by using the storyline of several families operating small businesses in a fictional suburb of Las Vegas. Narrated animations, videos, and numerous "do-it-yourself" exercises help students grasp difficult concepts quickly.

learning objective:

The primary objective of the course is to review the key calculus concepts that students should be familiar with in order to solve quantitative problems in the MBA curriculum. This section covers a wide range of concepts from computing derivatives to maximizing and minimizing functions.

Publication Date:

Discipline:

Source:

Product number:

Length:

description

This course material is the Probability Section from the complete Mathematics for Management Online Course. Courses may be adopted in their entirety or by individual section.

The Probability Section of the Mathematics for Management Online Course reviews the fundamentals of predicting outcomes in a business setting. The section includes: Experiments, Sample Spaces, and Events / Calculations Involving Sample Spaces / Mutually Exclusive Events / Complementary Events / Conditional Probability / Independent Events / Random Variables / Continuous Random Variables / The Normal Random Variable. Includes pre- and post-test assessments. The complete Mathematics for Management Online Course is intended to give all students--regardless of their professional or academic background--a comprehensive review of the mathematical concepts that are essential for a business education. The course engages students by using the storyline of several families operating small businesses in a fictional suburb of Las Vegas. Narrated animations, videos, and numerous "do-it-yourself" exercises help students grasp difficult concepts quickly.

learning objective:

The primary objective of the course is to review the key probability concepts that students should be familiar with in order to solve quantitative problems in the MBA curriculum. This section covers a wide range of concepts from basic probability calculations to continuous random variables.

Publication Date:

Discipline:

Source:

Product number:

Length:

description

This course material is the Finance Section from the complete Mathematics for Management Online Course. Courses may be adopted in their entirety or by individual sections.

The Finance Section of Mathematics for Management covers the essential concepts in finance that students need to know as part of the MBA curriculum. The section includes: Net Present Value (NPV) / Internal Rate of Return (IRR) / Payback Criteria / Future Value / Annuities / Perpetuities / Growing Perpetuity / Compound Interest / Basic Bond Math / CAGR: Compound Annual Growth Rate / Option Pricing. Includes pre- and post-test assessments. The complete Mathematics for Management Online Course is designed to level the playing field among incoming MBA students, regardless of prior professional or academic background. The course engages students by using the storyline of several families operating small businesses in a fictional suburb of Las Vegas. Narrated animations, videos, and numerous "do-it-yourself" exercises using formulas in Excel 2007 help students grasp difficult concepts quickly.

learning objective:

The primary objective of the course is to review the key math concepts that students should be familiar with in order to solve quantitative problems in the MBA finance curriculum. This section covers a wide range of concepts from calculating net present value to option pricing.

Publication Date:

Discipline:

Source:

Product number:

Length:

description

This course material is the Statistics Section from the complete Mathematics for Management Online Course. Courses may be adopted in their entirety or by individual section.

The Statistics Section of Mathematics for Management covers statistical concepts commonly applied within an MBA curriculum. The section includes: Summation Notation / Using Bar Graphs and Histograms to Summarize Data / Measures of Central Tendency / Skewness and Measure of Central Tendency / Measures of Variability / The Rule of Thumb and Outliers / Covariance and Correlation. Includes pre- and post-test assessments. The complete Mathematics for Management Online Course is designed to level the playing field among incoming MBA students, regardless of prior professional or academic background. The course engages students by using the storyline of several families operating small businesses in a fictional suburb of Las Vegas. Narrated animations, videos, and numerous "do-it-yourself" exercises using formulas in Excel 2007 help students grasp difficult concepts quickly.

learning objective:

The primary objective of the course is to review the key statistics concepts that students should be familiar with in order to solve quantitative problems in the MBA curriculum. This section covers a wide range of concepts from summation notation to covariance and correlation.

*required field. You can change details at any time before activation.

The enrollment number will not limit students' access to materials. Accurate enrollment allows
us to manage site traffic and course activity.

If your course is affiliated with an institution not listed here or you need to create a course to last longer than 6 months,
please contact HBP Customer Service at custserv@hbsp.harvard.edu or 800-545-7685.

Type the information in each box. Boxes marked with an asterisk (*) are required information.
You can change the coursepack information, including the Start and Stop Dates and the quantity,
at any time before you activate the coursepack.

If your coursepack is affiliated with an institution not listed here or you need to create a coursepack
which is longer than 6 months, please contact HBP Customer Service at custserv@hbsp.harvard.edu
or 800-545-7685.