Over the past year or so I have posted a few blogs every now-and-then about the importance of understanding the information generated by your business. I have also posted some handy tips on using various Microsoft Excel functions to assist you in understanding and manipulating your business data. Obviously, Excel is a great tool for managing data and when used efficiently and correctly, it can give you greater insight into your business on all different levels
The average Excel user is capable of designing basic spreadsheets with various functions and calculations. But Excel is much much more than a giant calculator. It is a powerful program that can do a lot more than most people realise and becomes even more powerful when it is coupled with the functionality that Visual Basics for Applications (VBA) provides.
Not many non-programmers know what VBA is in relation to Microsoft Excel. In short, VBA allows you to write code that sits at “the back” of Excel and integrates into “the front” of Excel, that is, the spreadsheet you see on your screen. VBA is so powerful that it can turn your Excel spreadsheet from a screen full of grid-lines, cells and awkward calculations into a professional computer program with buttons, drop-down lists, check boxes and much more.
I have recently designed a template using VBA and Excel which allows you to enter client information into a form, stores the information in hidden sheets, recalls the data when prompted and generates client reports. I guess it is a bit like a database with Excel functionality. The beauty about this program is that it is adaptable to almost any business you could imagine. It is totally customizable. I am currently using the foundations of this program to design a model for a prestigious health clinic in Jerusalem, who need to manage patient details, medical histories and operation schedules.
Whether you are a health professional running a clinic, an accountant, a business consultant, or a personal trainer, the program can be tailored to your needs, exactly to your specifications. And, you don’t need to buy any CDs or install any software to run it. If you have Microsoft Excel (preferably version 2003 or later), you can run it!
If you would like to see a FREE SAMPLE of this Excel program to get an idea of what it can do, please feel free to contact me at ra**@******************co.il and put "JobShuk" in the subject line.
It is important to note that this sample is a very very basic demonstration designed simply to give you an idea of what is possible. It is in no way a complete program. It is just "the tip of the iceberg". It is your business requirements and your imagination that will allow us to design the perfect Excel based program for you. The sky is the limit!
If, after viewing the demonstration, it strikes you as something you would like to integrate into your business, I will be more than happy to organise a free consultation with you to see how we can adapt it to meet your needs. Looking forward to hearing from you!
For more information about Easy Data Solutions, visit www.easydatasolutions.co.il or email in**@******************co.il.
Very powerful pitch! If the program “walks the walk” as well as Easy Data Solutions “talks the talk” — very powerful product!
As for the Excel design “walking-the-walk”, it provides a great method for recording, storing, recalling and analysing manageable amounts of information without the need for building a whole database or spending thousands on complex software. It really can be powerful. When it comes to Easy Data Solutions “talking-the-talk”, well, we try our best!