|
May 04, 2024
|
|
|
|
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.
Placement Eligibility English 097 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 20190612T13:21:24
Grading System Decimal Grade Variable Credit Yes Range 1-5 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 1. Getting Started with Excel.
2. Formatting Workbook Text and Data.
3. Performing Calculations with Formulas and Functions.
4. Analyzing and Charting Financial Data.
5. Working with Excel Tables, PivotTables, and PivotCharts.
6. Managing Multiple Worksheets and Workbooks.
7. Developing an Excel Application.
8. 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.
Add to Portfolio (opens a new window)
|
|