An Excel Hero saves money. Lots of money.
Image via Wikipedia
The vast majority of users are doing some business activity with Excel. An Excel Hero looks at an activity and sees how to use advanced techniques to save time. It might be a small formula; it might be an entire project integrated with a database that can eliminate wasted time, possibly in your own job, department or division.
You may even be able to eliminate your position… or your office! All businesses that succeed are ever mindful of the bottom line and that translates into keeping expenses in check. In most organizations, labor is the number one cost. Look for ways to prune and you’ll definitely be a hero. Believe me, just about every company has wasteful activities done by staff by hand or on computer. Ironically they’re often done in Excel. And that’s the crux of this book. Excel offers so many ways to do things that well-intentioned managers and executives choose simple over better. Simple to them, that is.
My goal is to post entries that will spark your imagination, so that you’ll be anxious to craft time-saving solutions immediately. Go ahead. Money saved today is better than money saved once you become a master. Keep returning and I promise to keep posting new techniques. At first you may learn how to shave minutes even hours on a daily task. Later you may learn how to eliminate the task from your business altogether! I want this blog to be that valuable.
Just the other day I delivered a project to one of my clients. They are in the business of modeling subtle and complex trends in historical stock market data, tracking dozens of indicators such as business cycles, credit availability, and sector risk to see what affect myriad variations of these have on selected portfolio returns. Using Excel, it was taking a minimum of 10 analyst-days of highly compensated analyst time to complete each simulation. My Excel solution for them completes a simulation in less than five minutes and makes no mistakes. They run thousands of simulations. My project eliminated a department. I’ve done this type of thing many times. You can too.
When you start saving your company serious time, you’ll be noticed. You’ll have wonderful choices. As you read this blog always ask yourself, can I use this to save my company money?
In short order you will be an Excel Hero!