Making a difference for Telecom Pros
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 …
I’ve been writing about how to create a BTS Project Tracker using Excel. Let me tell you a bit about why. Frequently in my career, my teams have had checklists they needed to perform at every BTS or Site in the network. These checklists were of a manageable size. I couldn’t justify a dedicated Program …
Continue reading “Excel BTS Project Tracker (This Technique is Much More Useful)”
Have you ever tried to use Excel to track the progress of a project? How did you do it? Did it work out OK? Or was it a huge mess, one that barely succeeded in reporting the status of the project? Often, before people start using Excel, they imagine a piece of paper that might …
Continue reading “Excel Project Tracker with Task Weighting”
One of the most common projects in Mobile Telecoms is to complete a checklist of tasks for each BTS in a group. In this series of blog posts, I’ll show you how to create an effective Tracker for this type of project using Excel. If you work with Excel, and especially if you are a …
Continue reading “Excel Project Tracker (with the Coolest Excel Function Ever!)”