Nov 26, 2021  
2021-22 Catalog 
    
2021-22 Catalog
Add to Favorites (opens a new window)

BTS 265 - Advanced Business Spreadsheet Analysis & Design


5 CR

Develops advanced spreadsheet skills including application programming using software such as Microsoft Excel on the personal computer.

Prerequisite(s): BTS 165 .

Course Outcomes
  • Make business and financial recommendations based on sound data analysis principles.
  • Analyze and make recommendations for business performance using scenarios and what-if analyses.
  • Create and report manual and automated business solutions with Solver.
  • Import data from various sources into worksheets and PivotTables.
  • Apply basic programming principles to the design of macros with Visual Basic for Applications (VBA).
 


Find out when this course is offered




Add to Favorites (opens a new window)