In Layman's Terms:
With Netgear, as with most devices, the Tagged Ports allows tagged traffic to traverse said port.
Untagged Ports will tagged the traffic on that port with the ID for which it is untagged traffic.
Excluded Ports will not partake in traffic associated with said VLAN on said port.
In even simpler terms:
Tagged VLAN tells the switch what to do with the tagged traffic on that port.
Untagged VLAN tells the switch what to do with untagged traffic on that port.
Exclude tells the switch what VLANs should ignore that port entirely.
Example :
Cap AC (Local Tagged 10) <-> Switch Port 15 (Tagged VLAN 10, 50)
Cap AC (Guest Tagged 50) <-> Switch Port 15 (Tagged VLAN 10, 50)
PC (Untagged VLAN 50) <-> Switch Port 2 (Untagged VLAN 50)
Android TV (Untagged VLAN 10) <-> Switch Port 3(Untagged VLAN 10)
Switch Port 4(Untagged VLAN 10) <-> NAS (Untagged VLAN 10)
Switch Port 16 (Tagged VLAN 10, 50) <-> Hex Port 2 (Tagged VLAN 10, 50)
^ In this scenario a PC and Guest WiFi is on Guest VLAN 50 and the Android TV box ( and it's NAS media library), as well as the Local WiFi is on the Local VLAN 10.
This is the simplest I can explain it. You can change things up all you want but the basics stay the same.
My personal advise is to not mix tagged and untagged data, unless the situation requires it - or do mix it, it is up to you. Some manufacturers do not play nice with others when it comes to mixed traffic, and sometimes it simply requires a little extra digging/tweaking. Nothing wrong (from non-enterprise standpoint) with mixing it either, so ...
FYI: Above example's principles holds true if you use VLAN 1 and 50.