BTS 165 Business Spreadsheet Analysis & Design • 5 Cr.


Introduces key concepts to develop and analyze business spreadsheets. Topics include formulas, formatting, logical, financial and lookup functions, charts, pivot tables, data tables, and multiple workbooks. Projects integrate skills to create business spreadsheets that communicate financial and operational performance.


After completing this class, students should be able to:

  • Manage and Share Workbooks within a professional business setting. Apply Custom Formats and Layouts to analyze and customize business data. Create Advanced Formulas in advanced business scenarios. Create Advanced Charts and Tables to clearly communicate data in Excel documents. Utilize intermediate to advanced software features to solve a business problem.