Love a Career in Telecoms. Since 2007.
I spend a lot of time talking about Automated Excel Telecom Dashboards. Why? Because they have made a tremendous difference for me. There are 4 main benefits. Save your time by instantly updating periodic charts, graphs, and reports Declutter your brain to focus only on important business metrics Maintain laser-focus on the important metrics in your …
Continue reading “5 Myths about Automated Excel Telecom Dashboards”
In writing about Historical Forecasts I want to know if you’ve been following this series? I’ve written in detail about all the steps to put together a project tracker that was easy to update, quick to use, and did most of the work automatically. It’s my strong belief that any Excel Workbook which you use …
Continue reading “Historical Forecasts for Your BTS Project Tracker”
When I first began writing this article, I set out to create a Project Dashboard; a self-updating, all singing, all dancing dashboard that would automatically reveal everything anyone might possibly want to know about this project. Having such a Dashboard would have fabulous consequences. Like shortening all the project status meetings because the answer to …
An interesting question was posted over on Stack Overflow recently. The question presented a challenge which I’ll paraphrase thus: Based upon the accompanying billing system data, how would you use Excel to list the Base Station generating the highest revenue by Area, Region, and Product? First, let’s pause for a moment of thanks that this …
We’ve never met before. But I already know a lot about you. You probably work in technology, maybe in a Mobile Network RAN. You already use Microsoft Excel, and you’d like to get better at it. You are not a manager and don’t have a team of people to supervise or manage. Lastly, you want …
Continue reading “Excel BTS Project Tracker – Dynamic Named Ranges”