2022-2023 Pierce College Catalog 
    
    Apr 29, 2024  
2022-2023 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BTECA 123 Microsoft Excel: Financial Formulas and Charts (1 credit)



Formerly BTECH 210C

Course Description
Students learn advanced-features of Excel to align with the Microsoft Office Specialist (MOS) objectives. This is the third class in a series to prepare students for the MOS exam.

Course Content
A. Advanced workbook maintenance
B. Chart creation and manipulation
C. Financial Formulas

Student Outcomes
1. Demonstrate the ability to apply advanced format features to enhance worksheet data.

2. Apply financial formulas to create meaningful reports for business use.

3. Create charts to manipulate and showcase key business data and increase readability for business reports.

Degree Outcomes
Program Outcome: Apply technical skills to meet industry standards in the office. Manage time and multiple tasks appropriate to the office. Employ software and/or technology to manage information. Information Competency: Graduates will be able to seek, find, evaluate and use information and employ information technology to engage in lifelong learning.

Lecture Contact Hours 2
Lab Contact Hours 16
Clinical Contact Hours 0
Total Contact Hours 18



Add to Portfolio (opens a new window)