In this module, discussions and practical hands-on demonstrations will be had on the use of Excel’s Count functions; COUNT, COUNTA, COUNTBLANK, and COUNTIF.
Table of Contents
00:00 Introduction
00:46 Learning Objectives and Info
02:18 Count Function
05:04 CountA Function
06:33 CountBlank Function
09:17 Donut Fair Count Examples
13:26 CountIf Function
15:37 Counting Phrases in a Survey
17:04 Practical Hands-On Exercise – Knowledge Check
21:58: What did we Learn?
22:15 End of Module 4 – Stay Tuned for Module 5
Link for Hands-on Practical and Download Instructions:
https://www.dropbox.com/scl/fi/z8w0vd9lshj797veqzuzz/Excel-Lesson-5-Module-5-Project_CountA.xlsx?rlkey=n6bbk5d5leo701uis5c6pp5jc&st=abms1zqn&dl=0
Instructions: Load link in URL. Click the dropdown arrow to the right of the "comments" icon. Select “Or continue with download only.” File downloads to your computer’s downloads folder.
Download
0 formats
No download links available.
Intermediate Excel Training Lesson 5 Module 4 - Using Count Functions | NatokHD