This course was developed for MBAs in response to the need for Excel functions that would typically be used throughout an MBA program. This course is a series of digitized videos where the instructor reviews each function. The student will also be given a spreadsheet that is used to follow along and practice each function after viewing it on 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. Functions in this course include:
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
Register during daytime hours and take the course on your schedule.
GBP Foundation Course: Excel for MBA Students
Registration Fee: $150.00
This registration fee is for TU Graduate Business Students.