BAP 130 Advanced Excel

Students will build on the skills learned in the beginning Excel course (BAP 115). Additional concepts include logical functions, nested logical functions, statistical functions, Lookup functions (including Xlookup), date and time functions, PivotTables and GetPivotTable, ETL Query Editor, Macros, and introduction to OLAP. Hands-on practice will allow students to prepare for the Excel Expert Certification.

Credits

1 credit

Prerequisite

BAP 115 with a C- grade or higher.

Course Content Charge

$40.00 (Certiport Advanced Excel exam) *If a student has not purchased SIMnet access prior to BAP 130 there will be an additional $23.00 charge.

Offered

Fall, Winter, Spring