Registration for September courses is open until Sept. 24 (subject to availability). Monthly intake courses for October, November, and December are also open.

Please note: Program and course information and registration services on the Professional and Part-time Learning website will not be available from Friday, September 27 at 5 p.m. to Monday, September 30 at 6 a.m. due to a scheduled service outage. We apologize for the inconvenience. For questions about Professional and Part-time Learning, please contact us by email or live chat.

Connect with Us

Computer Applications for Human Resources

Code:
COMP 3282

This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the previous Excel course. Students will learn how to create and analyze spreadsheets using PivotTables and PivotCharts, and Excel’s What-If analysis tools. Students also learn many of Excel’s advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create their own custom functions. In addition, students learn how to protect and share their workbooks. This course helps prepare students wishing to pursue the MOS certification exams for Excel Expert (Excel Expert 2016 exam 77-728 and Excel Expert 2019 exam MO-201).

Notes:

This course is designed to support both Microsoft Excel 2019, 2021 and 365 for Windows, you will not be able to complete the course with any other version of Excel, or with any version of Excel running on a Mac.


Textbooks:

  • Fall - None required

Equivalents:

  • COMP 3252
  • COMP 2205

Prerequisites:

  • (COMP 2209 Business Computer Applications 2
  • Or COMP 2251 Business Computer Applications II
  • Or COMP 2289 Business Computer Applications II )

This course is part of the following program(s):

Note: Clicking on any of the following links will take you to the program of studies where you can obtain more information or choose additional courses for your shopping cart.

Scheduled Dates

Click here to be informed when this course becomes active

CRN Day Date Time Hours Location/
Delivery Method
Fee Availability
10835September 10, 2024 to December 17, 202412:00 am - 12:01 am42Semester Intake Online$342.50CLOSEDNotify Me