IP addressing and subnetting are part of the day to day life for Network Engineers and there are many techniques and tools to make this job easier, managing large lists can be difficult and timeconsuming to manage and visualize.

We'll show some techniques and formulas in Excel and Power BI to accomplish some of these tasks.