Bangkok Beach Telecom – Page 11 – Love a Career in Telecoms. Since 2007.

Do you Tag in your updates?

When you tag someone, LinkedIn shares your update in the feed of that person’s connections. So your audience grows.

LinkedIn also messages the tagged person. For example, “Russell Lundberg tagged you in a post.”

To tag, type “@“ sign, then begin typing their name exactly as it appears in their profile. Select the correct name from the popup menu. If you always add value, are respectful, and write to drive engagement, tagging is a big win for everyone.

Pro Tip: if the person’s name doesn’t appear in the popup, try using 2 “@“ signs. Or after typing their name, also type something else from their profile, such as the company. Thanks to …….ANDY FOOTE……. for this suggestion.

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

Who’s going to #MWC19?

Mobile World Congress is the preeminent annual event in #Mobile Telecoms, with almost 110,000 attendees expected this year.

We are so easily distracted by the shiny and new. Industry press is full of articles about cutting-edge technologies:

#5G #IoT #mmWave #MIMO #NetworkSlicing #CBRS #blockchain #eSIM #ORAN #URLLC #MEC #kitchensink

I threw in that last one just for fun.

But let me ask you: How many of you have ever actually worked on or even seen any of that kit?

More likely, the work you’ve done in the past will continue to be required in the future.

So enjoy the new.

But don’t let it distract from developing your core, basic #Telecoms skills.

👉 If you like this, please comment, share, and follow me on LinkedIn for more updates, insights, tips, tricks, and tactics to love a career in #TelecomTribe #TelecomPros

Note to self: ambient noise interferes with auto-captioning #AI.

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 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.

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 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.

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.

Adjust the Print Area
Expand Pivot Table source data
Allow user input to influes your models
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”