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.
Excel© for MBAs Function List
Basics
- Add or delete a column
- Add or delete a row
- Adding a worksheet
- Adjusting a row height
- Copy
- Formatting a cell
- Formatting numbers
- Formulas – letter
- Formulas- parentheses
- Linking a cell
- 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