BATECH 165 - Business Spreadsheet Analysis & Design

5 CR

Previously BTS 165.
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.
Create and use pivot tables to summarize, analyze, explore, and present summary data.
Create and use filters and slicers to build interactive dashboard reports.
Utilize intermediate to advanced software features to solve a business problem.

Find out when this course is offered