What is Dashboard Automation?

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 your mind is no longer numbed by the many tiny details to be certain everything is updated.

Imagine how your influence will grow when you are the one with the bestest, most up-to-date, most decision-ready data.

Picture yourself in your next annual review with your boss. When you have a long track record of having the most insightful analysis.

Yeah. Focus on that.

👉 #TelecomTribe: Follow me on LinkedIn, Russell Lundberg, for more updates, insights, tips, tricks, and tactics to love a career in Telecoms.

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. Lots and lots of reports.

Dashboards, analyses, forecasts, budgets, financial models, capacity planning. Not very exciting. But this is how a modern mobile network is run.

For you, that probably means Microsoft Excel. Which is fine, because #Excel is not very exciting, either.

But it’s pretty much the best tool you’ve got for all those uses. You owe it to yourself to acquire a reasonable facility using Excel.

Check out this article: Dashboard Automation with GETPIVOTDATA. One simple technique to automate your Dashboards. And if you can automate all the mind-numbing manual updates you have to do now, it does more than free your time.

It frees your mind to think hard about what the data are telling you. You’ll have new insights and synthesize new possibilities.

Try it before you say “they’re only reports.” Because reports are a huge time sink. Get in front of it.

👉 If you like this, follow me on LinkedIn, Russell Lundberg, for more updates, insights, tips, tricks, and tactics to love a career in Telecoms.

Sequential Numbering

Excel Telecom Tricks
Excel Telecom Tricks

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 makes it easier for everyone in a meeting or a conference call to know exactly which row of data is being discussed. Simply refer to the sequential number.

Continue reading “Sequential Numbering”

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.

Excel Telecom Tricks
Excel Telecom Tricks

But more importantly, Pivot Tables are very important for automating your reports. This may seem obvious, but to automate your reports, you must eliminate the manual steps. Duh!

The #1 Excel Telecom Trick for automation is to use Pivot tables and the GETPIVOTDATA() function.

GETPIVOTDATA() allows you to place Pivot Table data anywhere in your report. Once you see it in action it will make complete sense to you. Continue reading “Dashboard Automation with GETPIVOTDATA”

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.

Excel Telecom Tricks
Excel Telecom Tricks

It’s hard to imagine a real-world example of a recurring report which does not benefit from Dynamic Named Ranges (DNR). DNR makes many complex things simpler, and some otherwise impossible things possible. You’ll see huge benefits if you begin using DNR in your reports after reading this article.

I’ve already written many Excel Telecom Tricks. If you’ve followed along and applied these tricks, your Dashboards and reports should already have improved dramatically. You should be well along to complete Excel Automation.

This trick might be the key piece you are missing. Why do you need a DNR? Here are some typical use cases.

  1. Adjust the Print Area
  2. Expand Pivot Table source data
  3. Allow user input to influes your models
  4. Extend a chart series

In this article, I’ll illustrate the first 2 use cases to show you exactly how to create DNR. I’ve written another article automatically extending a chart series. Continue reading “Excel Telecom Tricks – Dynamic Named Ranges”