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.
Read on to learn how to add abstraction to your models. Iʼll show you 3 techniques for using abstraction. And Iʼll do it by building on another Excel Telecom Trick which I showed you earlier, the 2-Color Chart Series. Continue reading “What’s Abstract About Excel?”