Excel Telecom Tricks – Synthetic Fields

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.

Excel Telecom Tricks
Excel Telecom Tricks

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”

Automate Telecoms Dashboard Dates

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.

Excel Telecom Tricks
Excel Telecom Tricks

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”