20. CCNA Ch11 - Create a Subnet Calculator in Excel

Опубликовано: 11 Ноябрь 2020
на канале: danscourses

44,062

521

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:
   • Learning Subnetting Part 2 - The Subnet Ma...
   • Learning Subnetting Part 3 - Dividing a Ne...
   • Learning Subnetting Part 4 - Using Binary ...
   • Learning Subnetting Part 5 - Find the Netw...
   • IPv4 Subnetting Practice for the CCNA
   • IPv4 Subnetting Practice for the CCNA - Cl...