In this video, I’ll show you exactly how it works and how it’ll save you oodles of time. I’ve written many articles to help Telecom Pros speed up how quickly their Dashboards can be updated. But I don’t want you to focus only on the time you’ll save. Instead, consider the insights you’ll have when …
Category Archives: Excel
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. …
Continue reading “A pro sports team’s new coach always says this”
Sequential Numbering
Ever been in a meeting or a conference call reviewing an Excel workbook? If the Row numbers are not shown on your printout, it can be hard to find exactly what the speaker is referring to. That’s much easier when the first column is a sequential number. Having each row identifiable by a unique number …
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 …
Continue reading “Excel Telecom Tricks – Dynamic Named Ranges”