university of tulsa logo

Excel for MBA Students

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.

Register for this course