NBA 6430

NBA 6430

Course information provided by the Courses of Study 2020-2021.

The goal of this hands-on, lab-style course is to develop proficiency in quantitative modeling within the environment of Microsoft Excel. Students develop and use spreadsheets to analyze a variety of business problems. The course has two principal components: spreadsheets and models. Spreadsheet topics include principles of good spreadsheet design, the effective presentation of information through spreadsheets (including graphical controls and dashboard design), and advanced Excel features (e.g., conditional formatting, data validation). Modeling topics include the art of finding the appropriate level of modeling detail, sensitivity analysis, and using solver and regression to perform optimization and estimation tasks.

When Offered Fall, Spring.

View Enrollment Information

Syllabi: none
  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 14063 NBA 6430   LEC 001

  • Instruction Mode: Hybrid-Online and In Person
    The instructor for this class will be teaching Virtually Enrollment limited to: Johnson and Graduate Students Only Hybrid: rotational in person attendance. You will be notified of your eligibility to attend in person and students should connect remotely until a seat is assigned. There will be no enrollment from a wait list into a class if you have a time conflict or if it will create an overload. Students dropping this course after February 15, 2021 will be assessed a fee of $100. The deadline to drop the class without a “W” is March 8, 2021 @11:59pm but you will still be charged the $100 late fee. This course is a Management Science Elective.

Syllabi: none
  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 14064 NBA 6430   LEC 002

  • Instruction Mode: Hybrid-Online and In Person
    The instructor for this class will be teaching Virtually Enrollment limited to: Johnson and Graduate Students Only Hybrid: rotational in person attendance. You will be notified of your eligibility to attend in person and students should connect remotely until a seat is assigned. There will be no enrollment from a wait list into a class if you have a time conflict or if it will create an overload. Students dropping this course after February 15, 2021 will be assessed a fee of $100. The deadline to drop the class without a “W” is March 8, 2021 @11:59pm but you will still be charged the $100 late fee. This course is a Management Science Elective.