 Ivy Software developed Excel for MBAs in response to the need for Excel functions that would typically be used throughout an MBA program. The module is a series of digitized videos where the instructor reviews each function.  The student is given a spreadsheet that is used to follow along and practice each function after viewing it on the screen.  After completing each section, the student completes a quiz along with a comprehensive module final exam. The module is divided into 4 sections: Basics, Manipulating Data, Analyzing Data and Statistics.

Basics

• Add or delete a column
• Add or delete a row
• Copy
• Formatting a cell
• Formatting numbers
• Formulas – letter
• Formulas- parentheses
• Locking a cell
• Paste
• Paste special
• Selecting a range

Manipulating Data

• Average
• Charting
• COUNT
• COUNTA
• COUNTIF
• COUNTIES
• Max
• Min
• Printing
• Sort Data
• SUM
• SUMIF
• SUMIFS

Analyzing Data

• Data tables
• Goal Seek
• Hardcoding numbers
• Multiple regression
• Pivot tables
• Solver

Statistics

• AND Function
• Binomial Distribution
• IF
• IRR
• LINEST
• MEDIAN
• Normal Distribution
• NPV
• Standard Deviation
• Trend
• Variance