Inventory

Inventory is necessary but always dull (whatever kind of inventory you do). Since some time ago and I was a member of the Inventory Commission, this experience has served as an inspiration to write an article about a good way of using collaboration tools in Excel (Shared tables) to facilitate inventory process. This is also a good way to use Windows tablets that your company have bought. Most of the time they are only used for show off, and now they could have a real purpose.

Randomly generated data

What is the most common problem for programmers and report makers? Certainly, it is a lack of adequate information they need to launch the report and see if it works. Data can be entered manually. But hey: imagine yourself to manually enter 100,000 records!?! This article demonstrates simple techniques to create tables with data to test the most demanding reports.

Tracking home budget

More than a year ago I noticed that my money is missing! I never doubted members of my family, but I started to check ATM transactions. Problem is that, most of the time, I take same amounts of cash. And since I am not very penny-wise it was very hard for me to „connect the dots“. Sounds familiar? That’s why I decided to end this phenomenon and started to track family’s incomes & expenses. I created „Simple Home Budget“ which helped me to track money transactions…

Creating a poll

How often do you create a poll? How much time does it take to enter and process the responses? Do you think that you can work faster? While you’re conducting a survey do you sometimes wish to be mobile? If you have these issues to the attention then it will certainly be interesting text that follows. Excel is a great software for creating and processing of survey results. Whereas, with the release of new versions, you can also keep the polls “in the cloud”, the process of surveying has never been easier …