Making Excel Useful
In too many cases people misuse Excel and they are not even close to realize that. From beginners euphoria about Excel as ultimate tool they end up drowning in Excel hell. At this point they blame Excel for everything: working too hard, loosing themselves, giving the wrong figures - or even worst several different but correct figures… After some time they do not know who to trust and as instinct command they start looking who to blame for their situation.
Let’s face the ultimate truth: Excel cannot be good or bad, only the way you use it can be good or bad. Continue reading ‘Making Excel Useful’ »
I have never thought about myself as a salesman. Simple reason is that person cannot be the best at everything. We have to choose. My choice was technical skills. Not sales ones. I cannot imagine myself selling crap products (if you are a salesman you often cannot afford to choose). I was prefer to be the one making product and assure no crap product will be produced with my participation.
Guys, I’m terrible sorry for my absence on my blog. Last two years were extremely busy for me - I started to work as Business Information Manager for one of major company in beer industry worldwide. In year and a half I’ve participated in two SAP implementation projects in Serbia. Both was successful and recognized as fastest implementations ever. At this moment no big project left for me in this company+country so I’m busy with much smaller IT projects… This mean I would have more time for my blog… But again, even I do not have big projects on professional plan, my private life is under major undertaking - very soon I’m going to be a father! And I need to get married of course…
I’ve been witness for the second time how people like to be creative on the wrong way. Instead of inventing a new fragmentation, why don’t use existing one? What I have on my mind is to copy country post office route organization. It’s very simple, since all what we need is available to everyone. You do not need anything else but ZIP/Postal code of the cities! 
Couple of years ago I’ve faced with unpleasantness when I’ve upgraded couple of Windows 98 workstation to Windows XP: FoxPro 2.6 applications simple consumed so many system resources that everything is hit: printing takes longer than usual, network traffic throughput is reduced since processor does not have free time to deal with these issues, it’s mainly occupied with currently running MSDOS session with foxpro application within. Some recommendation was to adjust idle sensitivity settings on shortcut but it does not solve the problem: depend of settings you can choose between two extremes: to confess all resources to foxpro process, or to take them from it (in which case foxpro application is running very slow - almost useless). 
Several months have passed since I’ve become a proud owner od Western Digital My Book 750Gb External HDD which came in blue carton box (this version shipped with eSata, 2xFirewire and 1xUSB ports). Initially it was or I choosed to format with FAT32 file system since there were no requirements for some security issues and that was reason to discard NTFS option. After two months I’ve realised what mistaqes it was. Due to 2Gb file size limit I was unavaiable to store my several vmware virtual machines on this drive, they required more additional work (to split virtual hdd into files of 2gb) and after this there were no problem with my virtual machines.
For the last several months I’ve been trying to find apropriate solution to track my money incomes and expenses, together with budgeting… I’ve been tested several solution but if they were good enough there were not free, otherwise they have lack of functionality… I’ve spend some times on some spreadsheet documents I was able to download and try to adjust them to my needs… Even I made them suit my needs, it was only for the limited time due to lack of spreadsheet design and logic… I have had difficulties to reconcile with fact in case when I borrowing money to my friends, I’m the one who should record this transaction and later remind them to pay me back… And I’m not making any profit in that! It was too much… Then I’ve decided to look for some online solution and on third attempt I’ve discovered Buxfer!
Due to security issues on previous Wordpress engine, this blog has gone unmaintained for some time. Now it’s upgraded with newest Wordpress 2.5.1 and hosted on powerfull Xeon server 
IsError function is used to check for errors in expressions or cells. At first sight most usefull case when you will need to use this function is to suppress division by zero error automatically. If not, you can always check for #DIV/0! cell by cell - but it would be inappropriate use of all this comfortable technology. This can’t be done without IF function which one is described in previous post on this website right