NBA 6470

Last Updated

  • Schedule of Classes - June 7, 2023 8:54PM EDT
  • Course Catalog - June 7, 2023 7:14PM EDT

NBA 6470
Advanced Spreadsheet Modeling

Course information provided by the Courses of Study 2022-2023.

The goal of this hands-on course is to develop further proficiency with Microsoft Excel with emphasis on the following main components. Accessing, managing, and analyzing data with power query, power pivot, data model, hierarchies, advanced charting, regression and forecasting. Designing malleable pivot tables using sorting, grouping, conditional formatting, calculated fields, etc. Developing excel applications using WordArt, macros, and visual basic.  Ensuring authenticity of data using data validation, protecting (as needed) the workbook content.

When Offered Spring.

Fees Course fee: $125 for Instant Access materials.
Prerequisites/Corequisites Prerequisite: NBA 6430 or permission of instructor.

View Enrollment Information

Syllabi: none

  •   Seven Week - Second. 

  • 1.5 Credits GradeNoAud

  • 11892 NBA 6470   LEC 001

  • Instruction Mode: In Person
    Enrollment limited to: Johnson MBA and Graduate Students Only Preferred Pre-Req: NBA 6430 or approval from faculty. Add/Drop Dates: January 17th at 9:00am thru January 30th at 11:59pm with an additional Add/Drop period beginning March 15th at 9:00am to March 22nd at 11:59pm. You may only add or drop a second-half class after March 22nd with permission of the faculty AND a late fee of $100.00 will be charged for each add or drop transaction. If you are dropping after April 12th you will also receive a "W" on your transcript in addition to the late fees. Non-Johnson students may add themselves to the waitlists during the enrollment periods, however Johnson Students have priority into the classes and non-Johnsons will be enrolled: 1) IF seats are still available after Johnson students complete their enrollment period and 2) IF the instructor allows. Non-Johnson students must see their college registrar regarding policies connected with adding/dropping a second half Johnson School class. A petition may be required. This course is a Management Science Elective.

    Department Consent Required (Add)