BAP130
Download as PDF
Advanced Excel
BusinessLDSBC - Ensign College
Course Lead
Jennifer Warnas
Course Description
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.
Credit Type
Fixed
Minimum or Fixed Credit
1
Semester and Block Offered at SLC Campus
Winter, Block 1, Winter, Block 2, Spring, Block 1, Spring, Block 2, Fall, Block 1, Fall, Block 2
Maximum potential student account charge (subject to change by semester). See Course Materials for details.
$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.
Will this course require CPT authorization for international students?
No