Ivy Software developed Excel for Undergraduate Business Majors in response to the need for Excel functions that would typically be used throughout an undergraduate business 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 Undergraduate Business Majors 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

Statistics

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