| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
00:00 – Subscribe to the channel!
00:12 – Like the Video!
00:26 – 1st method
01:45 – 2nd method
03:11 – 3rd method
In the 1st method, we gonna select the entire data set and then press the shortcut key Ctrl G to open special cells selection and the we can choose blank cells.
The 2nd method, we gonna use the filters to see everything we information and everything with no data. And we can combine multiple filters to create an compound filter or we can coupled filters together in excel using many columns.
the 3rd method, we will use one of most important functions in excel, the count blank function or the count blank formula. Then, we can count not everything, but the blank cells. We can also use the filters to sort the blank values and then rid of them.
#JopaExcel #Dashboard #Excel
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
