Excel pr fix to subnet mask

How does Excel pr fix to subnet mask work? Looking for a convenient way to calculate IP address subnetting wherein I can simply enter an address and select a subnet mask. Is there such an application that will show the Host Address Range, Broadcast Address, and Subnet Address?
How can calculations be shown as binary octets to assist in understanding subnetting? How can an address List can be generated showing subnet addresses, broadcast addresses and host address ranges for the subnets calculated.? I need these list to be printed or copied to the Windows' clipboard and excel.
