Description

If we use a filter or manually hide some rows in a dataset, we may want to perform operations with visible rows only and ignore hidden rows.

This session looks at how to ignore rows hidden by a filter or manually hidden rows.

After completing this session, you will be able to use the SUBTOTAL function to ignore hidden rows.

Instructions:

• Please complete the course, review questions, and successfully complete the qualified assessment with a minimum of 100% accuracy within one year of course enrolment.
• To retake the course, please refresh your browser and the course will start again.

Instruction before the Final Exam:

• The following exam will test your knowledge of this course.
• You can take it as many times as you want.
• You must have a score of 100% to pass this exam.
• You are required to complete the qualified assessment within one year of the date of purchase or enrolment.
• You must pass this exam to receive continuing education credits.
• You would need to retake the course before attempting the qualified assessment again.
• To redo the course after passing, you would need to reset the course.
• You won’t be awarded additional CPE if you re-take the qualified assessment after passing once.
• Please fill in and submit the survey after passing final exam to get CPE and Certificate of Completion.