Channel: danscourses
Category: Education
Tags: excelsubnetcalculatorandbinarysubnettingdecimalccnaconversion
Description: In this video I use Microsoft Excel to create a subnet calculator that will convert an IP address and subnet mask to binary, then logically bitwise AND them to find the network address. The calculator will also find the magic number in the subnet mask which can be used to easily figure out the subnets. This video is useful for networking students studying for the Cisco CCNA. Here are some of my previous videos on subnetting: youtu.be/uE5gdwr1mE0 youtu.be/fTTfbxrYRE4 youtu.be/140IIdZlL44 youtu.be/fCzjUV_ofMM youtu.be/HuLcsCH4V-c youtu.be/PlU9qNrVUh0