As per my post on February 23 rd, here are a couple of links to an Excel-based client record keeping demonstration: To view it through the Easy Data Solutions website: http://www.easydatasolutions.co.il/demos.htm and select the "Client information database" demonstration. To view it through the JobShuk website: http://jobshuk.com/uploads/assets/easydatasolutions/ClientRecordsDemo.xls  2 Important Notes: 1) It is probably best to save the file to your […]

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 […]

This blog was authored by Y. Karp. Not knowing how to program in VBA (Visual Basic for Applications) should not stop you from adding some “whiz-bangery” to your Excel spreadsheets. Out of all of the non-core Excel features, the macro recorder is one of the most handy. A macro is […]

This blog was authored by Y. Karp. Excel 2003 is limited to 65,536 rows and 256 columns. That might sound like a lot, but there are often situations where a spreadsheet you have designed can go right up to the limit. In fact, Microsoft increased these limits in Excel 2007 (1,048,576 rows and […]

It’s been a while since I have posted a blog to Jobshuk, but there is good reason as to why it has been so long. I have just completed 6 months of army service but I have now settled back into civilian life and I have re-opened my business, Easy Data Solutions. I had the privilege […]

This blog was authored by Y. Karp. Visit http://www.ykarp.com for some light-hearted blogs from the same author. One of the easiest ways to find pertinent information in your Excel spreadsheet is to use the sort function. Sorting allows you to display the data in alphabetical or numerical order. While this is an easy solution […]

This blog was authored by Y. Karp. Visit http://www.ykarp.com for some light-hearted blogs from the same author. Let’s say that you have a very complicated spreadsheet, or that you rely on your spreadsheet to give you information that will determine what steps you take next. Now let’s say that the rows and rows of numbers don’t actually make it […]

This blog was authored by Y. Karp. Visit http://www.ykarp.com for some light-hearted blogs from the same author. Excel provides the user with the option to create an almost unlimited number of tabs in a workbook. This is great for enabling the user to spread out the data among different sheets, allowing for a more organized workbook. In […]

This blog was authored by Y. Karp. Visit http://www.ykarp.com for some light-hearted blogs from the same author. Most people, even true beginners, know the very basics of how to type in data into an Excel spreadsheet. After all, an Excel spreadsheet is really just an electronic version of the old-fashioned bookkeeping grid. While<span style="font-size: […]

The other night I saw a great docu-movie called "The Fog of War". It provided a great insight into what happened in the confines of the White House during the early-mid 1960s when the Cold War was at boiling point and US intervention in Vietnam was intensifying exponentially. The docu-movie was centred around Robert McNamara who was […]