Love a Career in Telecoms. Since 2007.
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 …
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”
So far in this series I’ve written 4 articles building our Project Tracker. I’ve set up the Updates table and created progressively more complex Pivot Tables by using Lookups, Synthetic Data and Bucketization. But let me stop for just a moment to talk about where I’m going with this. I’ve written before about Excel Dashboards. …
Continue reading “Excel BTS Project Tracker – New Date Format”
What kind of Engineer are you, how would you describe yourself? Are you the kind who uses a straight edge when you write so the lines will be beautifully aligned, or do you scribble something barely legible to get done and to move on to the next thing? Do you calculate cell boundaries using 8-digit …