Aug 08, 2020  
2017-2018 Catalog 
2017-2018 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BSTEC 165 - Microsoft Excel

5 Credits
The student will gain the experience to work with Excel workbooks for common office business needs. The students will learn how to advance formulas and functions, insert tables, and create charts. Students will also learn how to create PivotTables and PivotCharts. Student will learn to manage multiple worksheets and workbooks, learn to use advanced filter, conditional formatting, sorting, and other advanced formatting features.

Pre-requisite(s) READ 081 or BSTEC 105
Placement Eligibility English 091/Reading 091 or higher
Course Note Basic computer knowledge highly suggested.
Fees CF

Designed to Serve BSTEC students and others interested in learning Excel.
Active Date 2015-04-07

Grading System Decimal Grade
Variable Credit Yes Range 1-5
Class Limit 30
Contact Hours: Lecture 55 Lab 0 Worksite 0 Clinical 0 Other 0
Total Contact Hours 55
Degree Distributions:
Course Outline
> Getting Started with Excel.

> Formatting Workbook Text and Data.

> Calculating Data with Formulas and Functions.

> Analyzing and Charting Financial Data.

> Creating Excel Tables, PivotTables, and PivotCharts.

> Managing Multiple Worksheets and Workbooks.

> Developing an Excel Application.

> Working with Advanced Functions.

Student Learning Outcomes

Add to Portfolio (opens a new window)