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 create both basic and advanced formulas and functions, insert tables, and create charts, including PivotTables and PivotCharts. Student will learn to manage multiple worksheets and workbooks, and learn to use advanced filtering, conditional formatting, sorting, and other advanced formatting features.

Course Note Basic computer knowledge highly suggested.
FeesCF

Quarters Typically Offered
Fall Online
Spring Day

Designed to Serve Students interested in mastery and application of intermediate Excel skills in a business or academic environment.
Active Date 20201208T18:00:07

Grading Basis Decimal Grade
Variable Credit Yes
Class Limit 30
Shared Learning Environment Yes
Contact Hours: Lecture 55
Total Contact Hours 55
Degree Distributions:
ProfTech Course Yes
Restricted Elective Yes
PLA Eligible Yes

Course Outline

Getting Started with Excel.
Formatting Workbook Text and Data.
Performing Calculations with Formulas and Functions.
Analyzing and Charting Financial Data.
Working with Excel Tables, PivotTables, and PivotCharts.
Managing Multiple Worksheets and Workbooks.
Developing an Excel Application.
Working with Advanced Functions.

Student Learning Outcomes
Students will construct worksheets and workbooks using professionally formatted text, charts, formulas, and functions.

Students will use an appropriate formula or function to meet a business need.

Students will analyze and organize data for use in pivot tables and advanced logic functions.

Students will demonstrate linking multiple Excel worksheets and workbooks.