BCT 220: Spreadsheets II

Download as PDF

Class Program

Business Computer Technology

Credits

Weekly Contact Hours

Course ID

092367

Meets Degree Requirements For

Restricted Elective

Description

Preparation for Microsoft Office Specialist Excel Expert exams. Students will manage and share workbooks, apply and share custom formatting, present data in Pivot Tables and Pivot Charts, create models and scenarios, and create advanced formulas by using functions.

Grading Basis

Graded

Prerequisites

BCT 130 or MOS Certification in Excel or Instructor Permission

Course Learning Outcomes

Setting up and maintaining workbooks intended for sharing, distribution, and data collection.

Applying custom data formats, advanced conditional formatting and filtering, and custom styles and templates.

Using functions to calculate dates and times, perform statistical or financial analysis, work with text strings, and look up values.

Creating advanced chart elements.

Creating and managing PivotTables and PivotCharts.

Core Topics

Manage and share workbooks
Apply custom formats and layouts
Create advanced formulas
Create advanced charts and tables