A pro sports team’s new coach always says this

“We’re gonna work on fundamentals: blocking, tackling, passing the ball.” As Telecom Pros, we love the shiny and new: 5G, mmWave, network slicing, #MIMO, URLLC, CRAN. OK, so we like acronyms, too. But when the excitement of sexy new technology wears off, there’s still a mobile network to maintain. And what does that mean? Reports. …

Dashboard Automation with GETPIVOTDATA

Do you use Excel Pivot Tables? If you do, then you know that Pivot Tables are a great way to categorize, sum, and average a table with many rows of numbers. If you aren’t yet using them, you really should. This article assumes you already use Pivot Tables comfortably. But more importantly, Pivot Tables are …

Excel Telecom Tricks – Dynamic Named Ranges

Dynamic Named Ranges are unquestionably one of the most important tricks for automating Excel Telecom Dashboards and recurring reports. Dynamic Named Ranges (DNR) are exactly what the name implies: an Excel named range whose size can change automatically. It’s hard to imagine a real-world example of a recurring report which does not benefit from Dynamic …