May 23, 2022  
West Shore Community College Catalog 2021-2022 
    
West Shore Community College Catalog 2021-2022 [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BIS 211 - Advanced Applications: Spreadsheets


Offered FL
Lecture‐2 Lab‐2
3 credit hrs/4 contact hrs
Prerequisite:  BIS 160 - Computer Applications: Microsoft Office  with “C” or better (2.0 out of a 4.0 scale)
This course will cover advanced topics in spreadsheet creation and manipulation to perform business applications using the MS Excel program.  Advanced features will include data validation, pivot table manipulation, advanced functions (amortization, present value, and future value), linked workbooks, scenario manager, and solver.  The course prepares students for MOS Expert Excel certification.This course will cover advanced topics in spreadsheet creation and manipulation to perform business applications using the MS Excel program.  Advanced features will include data validation, pivot table manipulation, advanced functions (amortization, present value, and future value), linked workbooks, scenario manager, and solver.  The course prepares students for MOS Expert Excel certification.



Add to Portfolio (opens a new window)