With any tool you use frequently to solve many problems, there’s sure to be lots of tricks and shortcuts that can make your job so much easier. Microsoft Excel is one of those tools for Telecoms, and there certainly are tricks and shortcuts. Learning them will help you become more proficient with Excel, and give you a pocketful of shortcuts for doing real work quickly.
This will do more than simply save your time. It allows you to derive insights and identify opportunities. You can actually start to understand what the data mean.
A common problem in Telecoms is that machine-generated raw data isn’t in the format you want. Or maybe there is data missing which is required to complete your analysis.
In this article, I’ll show you a technique I call Synthetic Fields. Synthetic fields allow you to modify data, or add data related to the raw data. Often Synthetic Fields are used to provide additional ways for Pivot Tables to summarize your data. This helps when you want to automate your Dashboards and recurring reports. Continue reading “Excel Telecom Tricks – Synthetic Fields”
Here’s a challenge we face all the time in Telecoms: we need a list of the most recent months of data in a table. For example, a Telecoms Dashboard, which might show data for each of the most recent 12 months.
For example, your Dashboard for May 2018 might show data from May-18, April-18, March-18, etc., all the way back to June of 2017. Those are the most recent 12 months.
A typical Telecoms Dashboard shows one or more Key Performance Indicators (KPI) by month for each of the last 12 months.
Using the most recent 12 months is quite common in many industries. So common, in fact, that is has a special name: Trailing Twelve Months, often abbreviated TTM. Ideally, the Trailing Twelve Months (TTM) are re-calculated as soon as you add data. That is, if you automate it.
In this article, I’ll show you how to set that up. Like so many things in Excel, it’s surprisingly simple. It’s more work to explain it than to actually do it. But it’s worth figuring it out. It’s a big part of automating your Dashboards. Continue reading “Automate Telecoms Dashboard Dates”
As a Telecoms Technical manager, your job is often about speed. Make a report faster. Prepare a presentation faster. Forecast usage faster. Analyze a problem faster. Create a budget faster. See the pattern?
Youʼll use Excel to create models in all these examples; make assumptions and build them into those models. Often, there will be several use cases for you to model.
How do you do that? What’s your style? Do you work on one case to completion, then copy/ paste to start the next case?
If you want to impress your boss and propel your career, learning how to properly model different use cases is an indispensable technique. A key trick to effectively modeling different use cases is called Abstraction. Abstraction is also an important trick for automating your dashboards and recurring reports.
I cried this morning when I watched the live video stream of the launch of Falcon Heavy. As an Engineer, I was overwhelmed by the magnitude of all the work and planning and preparation and testing and science and engineering and everything that went into that entire project to make that launch a success.
Beyond the success of the launch itself, the proper separation of the two Falcon 9 side boosters, continued operation of the Main booster, the placement of the capsule into proper orbit, everything just worked so well. When the two side boosters returned and landed back at Cape Canaveral, within less than one second of each other, I just shook my head in amazement and bawled with more joy. Continue reading “SpaceX Marketing Soars on Falcon Heavy”
I have on my website a link for people to submit writing topics for me.
Responding to readers requests helps me stay focused on things which interest my readers and also encourages me to write about things I might otherwise never get round to. For these reasons, I’m always grateful to my reader when they submit a question.
Reader Sean W. recently asked this question:
Will Mobile Operators make the investments in 5G required to meet consumer price points?
David Dean was a long-time salesman with a very successful track record. He began his sales career selling books for the Southwestern company during summer recess while attending university.
This book is in the genre of motivational or self-help.
The book chronicles his sales efforts during several of those summers and he uses his own experiences to illustrate 7 principles which he believes are important to success in any endeavor. These little vignettes tie the book together and give it a helpful air of storytelling. Continue reading “Now is Your Time to Win – David Dean”
Did you ever start working on an Excel spreadsheet and realize you needed it to do something you didn’t know how to do? I’ve been working on the next article in my Excel BTS Project Tracker series. I needed an Excel Hierarchical List, and I didn’t know how to do that. I have to learn a couple new things to do that and I wanted to share that with you.
The trial and error approach is an agonizing way to find the key to learning something new. Often, there is a deadline, your boss wants the spreadsheet done pretty quickly. What if one of your coworkers recently presented an Excel spreadsheet that was very good, and you feel like yours needs to be equally good or it will suffer by comparison?
I need to list all the BTS and every task for each BTS. You might need to do something similar. Examples I can think of include documenting port cards in an RNC, or maybe DS-3 circuit IDs and DS-1 assignments, or mapping trunk group and trunk numbers. Anyplace where there is hierarchical numbering you might have to do something similar.
Of course, there are applications for this outside of Telecoms, too. How about sample tests grouped together, or deliveries addressed to different postcodes, or student IDs in different grades. I’m sure you can think of many more.
I tell you, these days the workplace can be so competitive. You might quickly be left behind if you aren’t continually upgrading your skills by reading the right blog. Excel is definitely one of the skills you need to constantly be improving. Continue reading “Excel Hierarchical List”
During the late 1980s, I was attending university and living on the beach in San Diego. My studies required me to spend a considerable amount of time on the beach (ahem!) and I started using a sunscreen product from Neutrogena. The sunscreen had the requisite SPF 30, but I liked it because
it had a great texture and felt good for my skin. To me, it seemed more like a skincare product than the typical sunscreen lotions and oils I used to use. It sold for around USD7.00 for a 30ml tube.
I remember once going to buy more but was unable to find it in the sunscreen section. However, I noticed a very similar-looking product in the cosmetic section. The similar product was being sold as a face cream, which also had SPF 30. The price was comparable to the other face creams around it, which was about three times as much as the price of the sunscreen product. Continue reading “A Critic of Marketing Repents”