An objective common to almost every Telecoms activity you’ll do in your career is to share your work with others. Sharing in this sense can take many forms:
- Document steps taken.
- Identify a problem.
- Teach a task to others.
- Reveal a hidden truth.
- Propose another plan.
- Brainstorm fiercely.
The context for each of these tasks is Telecoms. But the actual process might seem only distantly related to the courses you took and theories they taught. Yet it is this process of data collection, manipulation, analysis, and, most importantly, presentation and sharing, which is at the very core of Telecoms.
Communicating your ideas so that others can understand them is a huge challenge. The technological skills and comprehension of your audience can be so unpredictable. Their goals and objectives may differ wildly from your own. So to achieve your goals and objectives, it’s up to you to communicate them in a way which is suitable for your audience.
There are entire courses taught on data presentation and visualization. It’s a big topic with lots of angles. In this article, I’ll discuss a very narrow technique from the field. It’s called “normalization”. Normalization is a way to present data so that it’s meaning or implications are more clear. I’ll show you several approaches for using Excel to normalize your data. Continue reading “Excel Telecom Tricks – Normalization”