20. CCNA Ch11 - Create a Subnet Calculator in Excel

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:

[baryonicphoton]

The straightforward way to calculate the magic number is just "=2^(8-(FIND("0", G2)-1))". Bonus tip: pressing "enter" instead of moving the mouse to the checkmark will drive your viewers less crazy.

[chrisertsos]

Excellent video. I came for the cheat sheet and left with a knowledge of how subnetting works which had confounded me in a high level class having no previous exposure to basic networking. I'll be checking out your other videos for sure.

[YamaSaghar]

It's just amazing!!!
Thank you so much for sharing such magical tricks!

[sf]

Excellent video. I have learned so much. Thanks for the info.

[runrunsomethings]

I still believe in Magic . Its Awesome.

[Hypocrisy.Allergic]

You are amazing man, i love this kind of content, shortcuts and stuff.

[majiddehbi]

hi sir i was following at netcad and now I m about to take CCNA 200-301 EXAM Iin jaunary I will love that u do some tutorial about automation netwaorking programmability thx a lot

[alexdominguez]

Hi Dan, Amazing Video. Thank you so much, Like all your videos. Question? Is this calculator just for the class C network? How about when we have a class A or B network address? by the way, Is your website de-activated?

[zakariajouimaa]

hi sir, it will be nice if you write this to a pdf file or docx file to be able to read it offline, because i dont have internet all the time, many thanks sir, good luck <3

[DougSJBrooks]

why not have G4 look at D5 to save you trouble of working it out, loving the idea of building this into a powerpoint :)

[lojdfic]

Greetings what if I wanted to get the translated the /29 Mask via command how should I go about it?

[The_Frozen_]

@DansCourses Do you have a method to create a IPV6 subnet calculator?

[Igor-ceul]

how to add broadcast and gateway addresses ?