May 28, 2024  
2017-18 Catalog 
2017-18 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

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.

Course Outcomes
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.

Find out when this course is offered

Add to Favorites (opens a new window)